Does anyone know what dba_tlog_shrink is? I can execute it on my server but I can't seem to find any object with that name. Dave ...more >>

please, what is the difference between foxpro and sql server ? and what are the disadvantage and advantage of foxpro ?...more >>

Hi all I am very new to SQL Server, I am working through my SQL Server 2005 for beginners book. I have SQL server 2005 installed on a Win 2003 Server. I have workstation components installed on my Vista Box. I am trying to create a database diagram. The DB is basic with just 4 tables....more >>

Hello, I have a problem that I'm hoping someone will be able to help me resolve. 1) I have a C# Web Site in which I connect to the database: "Install Microsoft SQL Server 2005 Express Edition" via the link on: http://msdn2.microsoft.com/en-us/express/bb410792.aspx This Web Site has...more >>

Two environments: ASP.NET 2.0; SQL2005 STND SP1. This morning the web site got virtually non-responsive. The number of logical connections just kept rising on the SQL server and most of them(over 300) looked like this in sp_who2 output (both CPU and I/O at 0): WEBSERVER . dbname EXECUTE 0 0 8...more >>

We use Avaya IP Office. Call records are stored in programs such as Delta Server and Database Server Supervisor and backed up with SDX Archiver. Avaya says it's using Microsoft's SQL database. Question: How do I restore a database? I have a .BAK file that I need to restore, to try to retr...more >>

Hello, Is there any way to use profiler and just show the 'Writes' it does. I do not want to display anything else for a specific DB. Thanks, Tmuld ...more >>

Hello, I have a Db that has user name of 'dbo' and login name of 'sa'. For security reasons, I want this gone. This user was the owner, but I changed the owner to another user and verified. After doing this, I still cannot remove the dbo - sa user from the DB. I get errors: "Selec...more >>

I have a view in SQL Server 2005 that is sorted. When I import to Excel, it comes in not sorted. Where the problem on this? I also posted on Excel Gen Questions. Thanks. -- Regards, Pat...more >>

How can I go about safely renaming the data and log files for a database? Thanks. ...more >>

Hi All, I have a stored procedure that if I run it takes over 40 minutes to complete. I use exec stored_procname and parameters. However, if I run just the inside of the stored procedure (just the code) with hard coded parameters it takes under a minute to completed. Why would exec stored_p...more >>

Hi, I am running SQL Server 2000 and was wondering if there was a way to query the state of any given SQL Agent job? So i want to setup a seperate SQL Agent job that's going to go out and tell me if a particular sql agent job is in a "Executing Job Step 'x'" status or in a "Not Running" sta...more >>

SQL 2000 sp 4. I have a spid in sysprocesses with a waitresource of UNK: 0:393219:0:0. I've never seen this waitresouce type before - does anyone know what it means ? During this time the above waitresource occurred my application was suffering from a poor performance 'glitch' so I want...more >>

Does anybody have a way to re-write this without using a cursor? This takes a long time to finish. The goal is to cut the processing time. DECLARE @the_emp_id nvarchar(50) Begin Declare EmpCursor Cursor For SELECT Employees.dbo.tbl_emplist.emp_id FROM Employees.dbo.tbl_emplist WHERE emp_a...more >>

Hi I have trouble with SQL 2005 optimize. I set up new SQL server with SQL 2005 SP2 and move database from old SQL 2000 server and after that I starting getting some performance problem. In some case the SQL server is not using indexes. In select statement where I select TOP X record from t...more >>

I'm trying to use "Copy Database" to copy a database from a SQL2000 instance to a SQL2005 instance; everthing looks ok until I execute the operation and get an error message on the action "Create Package" of "One or more arguments are invalid (Copy Database Wizard)" I've gone over it and ...more >>

Hi all, Does anyone know how to do the search and replace in multiple stored procedures using SQL 2005 Management Studio? Any help will be appreciated. Thanks! ...more >>

What is the difference in table-level and column-level check constratint? Any example? ...more >>

Can SQL Server 2000 + sp3 work on Windows Server 2003 enterprise edition R2 Please I need a reply urgently ...more >>

I was setting up the backup for a new database last evening and seem to have created a small problem. Although I was able to create a backup and restore it, in the process I seem to have left a couple of other copies of the database files in a state where they cannot be moved, deleted or copie...more >>

Hi, Please let me know how can I check SQL Server database physical files fragmentation and do the defragmentation using any third party tools or MS provided tools. Is it possible to check it from SQL Server extended stored procedures or any other native objects. I know one such utility ...more >>

Hello 1)How can you make Sql Server 2005 and Sql Server Express both be registered servers on the same server? 2)What do you do if when you start the Sql Server Express "service" and it always fails with an error message and it's icon remains red when the regular Sql Server runs as expect...more >>

Hello Since there is no Enterprise Manager to access Query Builder how do you access Query Builder on Sql Server 2005...more >>

What size should i allocate the paging file for SQL 2005 on say Windows 2003 64 bit with 16GB or 32 GB of RAM ? ...more >>

Running SQL 2005, SP1 on WIN2K3. I am in the midst of troubleshooting High CPU and have identified several queries that could use some performance tuning. However, in the midst of performing some traces in Profiler, not wanting to rule anything out, I included some of the "Errors and Warning...more >>

Hi, I've looked through net but I couldn't find any simple soulution to this problem anybody knows?? Regards, Bartolo ...more >>

It was suggested that we run DBCC INDEXDEFRAG on one of our databases. How do I go about doing this? Do I run it in Query Analyzer or someplace else? I'm not that familiar with SQL and any help would be appreciated....more >>

I am running SQL Server 2005 and I am using the Transfer Logins Task SSIS package to transfer logins from SQL 2000 to SQL 2005. I select the options to also bring across the SID. Unforunately, we can not use these accounts to succesfully log on after a migration. We are forced to reset th...more >>

Hello. Take this simple backup statement: Backup Database MyDB To Disk = N'p:\Backup-MSSQL$MySqlInstance\MyDB.BAK' With Name = 'MyDB full backup' Would you think that if MyDB.bak already existed it would be overwritten with the new backup? Or would it double in size, effectively containing ...more >>

This is more looking for an opinion then a clear answer I have a Point Of Sale table that has 500 million records Contains PointOfSaleID Primary Key BIGINT UPC NVARCHAR(11) Quantity INTEGER PurchaseDate DATETIME, HouseholdID INTEGER, ExternalID NVARCHAR(50), ExternalHouseholdID NVARCAHR...more >>

Hi, What's the default locking setting for SQL 2005 EE. In BOL, "By default, SQL Server Mobile uses row-level locking for data pages and page-level locking for index pages." Does SQL 2005 EE have same setting. What's the adv and disadv for each setting? How can I change the setting if...more >>

I am currently running sql 2005 standard build is 9.0.3161 I am looking to update it with the cumulative pacth3 for sp2... I notice on the builds page there are a number of builds after mine. Do I have to install each fix seperatly or do I have to reinstal sp2, becuase it has been refreshed ...more >>

OK, I am assuming that by reorganizing my indexes it will do just that to optimize the indexes vs. rebuild will do the same but it will also let me adjust the amount of free space for the index. If I continue to use the default free space % would these tasks not have the exact same result? A...more >>

I've seen a dump of the TDS traffic going from my webserver to the SQL Server database and it seems encoded in Unicode (it has two bytes per char). Seems it would have a huge impact on performance if it travelled in one byte. Why might this be? rj ...more >>

I have what seems like a commonish problem. I have copied my database (mdf and logfile) to a remote XP desktop machine .... when using SQL server managment express tool when I try to attach the DB it ends up readonly. The file permissions are not set to read only (a problem I have read) ...more >>

I was wondering if there was any way to add a linked table reference into a SQL Server 2005 Database to an Oracle 7 Database. I am able to do this in Access but i really want to move my database on to SQL Server and this link is very important. Thank You...more >>

I have been working with databases for nearly 10 years now, but for the life of me I can't figure out how to move database tables from one server to another in SQL Server 2005 without using scripts. I used to use DTS in SQL Server 2000 and everything seemed to go smoothly. I used a combinatio...more >>

I have been working with databases for nearly 10 years now, but for the life of me I can't figure out how to move database tables from one server to another in SQL Server 2005 without using scripts. I used to use DTS in SQL Server 2000 and everything seemed to go smoothly. I used a combinatio...more >>

Can anyone offer any advice in collecting user access? We have a server that hold at least 2 dozens of databases and I've been asked to collect the database names that reside on that server and also to compile a list of user accounts and access levels for every database. Thanks! ...more >>

I have a database which has been moved from one server to another using backup/restore. Of course there were some problems with mapping of userid to logins. That was solved by running sp_change_users_login. But one problem remains. I had one userid that I had aliased to dbo. That userid is ...more >>

Hi there I feel a bit silly here. If spent the last 45 mins searching the web trying to find a definite list of the differences between SQL 2000 Standard and SQL 2000 Enterprise. All the links at microsoft.com seem to redirect to the 2005 version. If anyone can link me to a feature comparis...more >>

Does anyone knows if its possible to know which objects my session access to? ...more >>

does anyone knows if it's possible to identify the obejct my session is working on? meaning to correlate spid from sysprocesses to id at sysobjects. for exmaple, I run a select query on Table1 , and table 2 under session 56. can I see 56 correlted to the object Id of Table1 and Table2 ...more >>

Hello, I am still trying to get my head around this one. I have been working on a new version of a website and decided I wanted to make a backup of the old database file before I tried running any scripts against it. Since the production website is currently down, I decided to detach the d...more >>

Hi All, Hoping someone can assist with this. Is there an SQL trace flag, or other method, where I can get the SQL server error logs (2000 and 2005) to log database detachements, and changes in DB status (eg to read only from online etc). I thought about a trigger on sysdatabases (sys.datab...more >>

I am relatively new to sql server. I have sql server running on a development machine and can access it with no problem from any application that I develop. My question is, if a new application is to be put onto a SINGLE machine with no network access, what is the process for putting that datab...more >>

I am going to paste the quesry I have below. This seems to work fine for = what it is, but I need it to drill down a bit further and I am at a loss = so any ideas would be helpful... This pulls a count, as you can see, for every time a worker select a bit = field in an online db. It has a Wher...more >>

I'm running a test, but I have a job that I want to start at 3:10 AM and end at 2:50 AM. SQLagent took the job, but it isn't starting and when I ran it one time manually, it said the next start would be 3:10 AM. I would like to know my answer before Friday morning. ...more >>

Can you still create a backup device in SQL 2005 and if so How? Thanks! ...more >>

Is there any other way to do load-balancing other than SQL Server 2000's Distributed partition Views? I am aware that 2005 has done something like Distributed Tables, but that is, for my purposes, the same thing. What I do not want to do is try to guess what gets accessed in what fashion an...more >>