Hi After running maintenance wizard, I getting a backup file that is the same size like the DB but with .bak. Is there a way to compress this file automaticly? The original size is 11GB after compress the size is 700MB. Any idea? Than'x Shay ...more >>

Hi, I have a PC with XP home installed and want to use SSIS to import text files to the SQL 2005 at my webhost, can the developer edition of SQL 2005 install SSIS Integration services to do the import?, or will that checkbox be greyed out when installing? ...more >>

I'm posting this so maybe it will help others. Our SQL 2005 server, within 18-24 hours after reboot, would start to slow down. Queries that normally took 1 second would take 3 or 4. Task manager showed CPU usage at 30% even when no users were active. On investigation: - The third and...more >>

Hi All, i have a doos script that downloads from an ftp site and extracts data from zip files before running a DTS Package. my question is; is there a way to check to see if SQL is running and if not start it? any help woudl be appreciated Simon Whale ...more >>

I know the difference between the two. If I take production database that's in Full Recovery and move it to a test server, would changing the recovery model to Simple affect any performance tests I run? The ldf file will be on a separate disk from the mdf file. ...more >>

I am having trouble creating a primary key on a large table (6 mil rows)... on a SQL Server Express 2005 database... After I make the changes to the table and Save, the operation starts but times out after about 30 seconds, saying that the timeout has expired. I tried looking for a timeout ...more >>

Hi, on an SQL 2000 server I'm using the maintenance plan to manage my backups etc... in the last year, no problem. but in the last weeks I see that the job never ends!!!! the SQL Agent consume 38% of my CPU and the never stops. the backup is done correctly, the files are created normall...more >>

The company I am working with use Small Bussiness Server 2003. I think it came with SQL 2000. We got a large transaction log file. It is 15G last week and the database file is about 5G. I did try BACKUP DATABASE, BACKUP LOG, SHRINKFILE(<logfile>,0), SHRINKDATABASE, SHRINKFILE(<logfile>, 0, t...more >>

dear all i am using ASP.net ,c# and SQL server 2000. i have create all table, stored procedure .views in my application which is running well in localhost but now i want to deploy it on server. for that pupose i need to create all table, stored procedure, views on the domain server dat...more >>

I was working originally with what turned out to be a very unreliable Offshore IT firm in India. I had to finally sever our working relationship with them. They were about 70% complete even though they demanded 100% payment upfront. WON'T EVER DO THAT AGAIN! My problem is they site me all the ...more >>

Hi everyone, I need to write a SP to check the available free space in a certain database filegroup(SQL Server 2000 database). Any help will be appreciated. Best Regards, ...more >>

Hello Everyone, Im a bit stumped in doing DTS. I really have basic knowledge on it. anyway, here's my issue. Im trying to import data and my source is a text (.txt) file. The information in the text file was cut and pasted from Excel. This is what I a normally used of doing. Anyway, so I...more >>

Which is a better option to transfer data between two sql servers: 1. Over a linked server: SELECT * INTO <table name> FROM <server.database.dbo.table> with (nolock) 2. bcp "SELECT * FROM <database.dbo.table>" queryout "temp.txt" -N -k -E -U <username> -P <password> -S <server> BUL...more >>

Can anybody tell me when i complete the sp4 upgrade to my sql server 2000 why when I type "select @@version" under sql query analyzer it doesn't releft latest upgrade to sevice pack 4? ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 2000 00:57:48 Any reply to help would ...more >>

Can you use the 2000 Query analyser to connect to SQL 2K5 ? ...more >>

Hello, Is there a way to migrate my Reportserver project for SQL 2000 Report services developed with VS2003 so that I can use and modify them in VS 2005 or have I realy to install VS 2003 on my new machine? Greets Jean Paul ...more >>

Hi There, This is vexing to say the least. Setup: Single SQL 2005 standard server: 2 databases, with the same table structure and query structure. Table Count: 78 Query Count: 3 Database A has 8 customized security roles, with different permissions across all of the tables. Da...more >>

When we run the "EXEC SP_SPACEUSED" command it is reporting 22GB of unused space yet every day that unused space grows by about 1GB. The data size and index is only roughly 11GB. So my question is why is there so much unused space and it why is continually growing and what we can we do to pr...more >>

Hello, We did a restore of a database to a test database, however after the restore the database is still showing as loading. I was not present during the restore but it looks like the norecovery option was not used. We tried the database restore dbname recovery option but that did not wor...more >>

Hello, I'm trying to create a linked server for the last week and it's still not working. I'm using "Microsoft OLE DB Provider for DB2". Here is the error that i have: Msg 64, Level 20, State 0, Line 0 A transport-level error has occurred when receiving results from the server. (provider: ...more >>

I'm sitting at the server itself (SQL 2005 Standard), logged in as admin and get an error trying to backup to a local drive: Cannot verify the existence of the backup file location. I read how this usually refers to backing up to a network share or something, but this is a local drive. I ...more >>

Hi! I'm looking for a way to retrieve Licence Info from SQL 2005 Server with VBScript From a remote location I connect to the server and grab those info with my administrative rights, but I'm not accessing the DB with a SA account... With SQL 2000 Server I retrieved those info from re...more >>

I am trying to run through a trace log to improve one of our databases here, however, the calls originate inside a read only database, goto another database on the same server before they finally end up in the destination database that i want to tune. How can i get the advisor to travel thr...more >>

Hi - I apologize in advance for the newbie question... I have been asked to gather some db statistics. We have 11 dbs and some have 70 or more tables. I need to gather is number of fields for each table in the database. I've used this so far: SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMN...more >>

Hi, I have a weird issue happening lately on our new SQL Server 2005 standard box. Each night we run a maintenance plan that checks integrity, rebuilds indexes, updates statistics, cleans up history, and backs databases up in that order. Then each morning we notice this one stored procedure t...more >>

Hi, I need to prepare an Installshield project that restore a database on my target machine. No problem with script RESTORE DATABASE BIGStudio FROM DISK=MyDir\MyBackup.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10, MOVE 'DB_dat' TO '\Data\DB_Data.mdf', MOVE 'DB__log' TO '\Data...more >>

Anyone tested this? Does auto update stats when it kicks in overwrite a full scan? A full scan is run every night and update updates/creates are turned on. Puzzle A table has 200000 rows and with auto updates the sample rowcount is about 50000. If auto updates kick in will the new sample ...more >>

I have a MSDN SQL Server 2005 Developer edition disk called as SQL Server 2005 CTP what is this CD ? is it the 2005 beta CD please confirm. Is it OK to install from this disk. Thanks Karen ...more >>

I just install new server for testing only. I have problem about user in master database. How to copy all user from production server to testing server?...more >>

Hi, I've been experiencing some very strange, intermittent failures connecting to an MS SQL database... basically at seemingly random times the server decides that it can't open the requested database (reporting error 4062: "Cannot open user default database. Using master database instead"). I...more >>

i have a query that deletes a large range of rows but the where clause is not indexes delete from instructor where lastteachdate < '2005-01-01' lastteachdate does not have an index and the instructor table has 100,000 records. sp_lock shows a table lock. I understand why. Since there is...more >>

Hi Using SQL Server 2005 SP1 Are ther any way to create scripts that will recreate the maintenance plans that are on the server? We need to rebuild the server with a different collation, so the master, msdb and model will get recreated. Also where are the configurations for database ma...more >>

Hi All, I have a requirement in which some of the text fields are customizable by the super admin for eg: Dropdown options, Chek box options, Can any one tell me how best we can do the table design Thanks in Advance Thomson ...more >>

So on the source system say ServerA, I can see the physical and logical disk counters using perfmon But when i go to another machine say ServerB or ServerC and use perfmon to connect to ServerA, I cannot see the counters from there. I am using Windows 2000 Advanced Server with SQL 2000. It...more >>

Is it possible to CL command in "Execute SQL Task" by using ODBC connection Btw I'm using "SQL 2000/8.0" (e.g. CL: CPYF FROMFILE(LibraryA/TableA) TOFILE(LibraryB/TableB) CRTFILE(*YES)) ...more >>

Hi, I am looking to update my SQL 2005 knowledge to be a DBA, does anyone know any good CD based or online training or any other quick resource. I have basic SQL admin knowledge of SQL 2000. thanks-Rob...more >>

Two of my clients have their databases setup on one of my Servers ( SQL Server 2005). I.e. both Databases are sitting on the one SQL Server. Queries executed by Client A takes a very long time and hence effects the performance for the queries performed by Client B (simply becuase Client A is ...more >>

Hi, I have a server running 2005. I have a SP that dumps data into a table. When it runs, it adds 100K records (200Mb?) but the database grows to 19GB! but 18.5 is just space. When I shrink the DB I goes back down to 500mb? If I run the SP again, I get the same problem Thanks for the help! ...more >>

Last night we made the backup as usual, in the morning a table is completely all nulls except for the elements of the key. We thought there was some error or accident, so we copy that table from the backup, 30 min later we saw another table with the same problem, then checking another DB used ...more >>

Hello, my sql server 2000 box is doing excessive compilations. There is no ad-hoc SQL on the system, just stored procedures. In particular there is really only 5-6 sprocs that run day and night. Still perfmon reports something like 30-40 SQL Compilations per second (depending on the day). ...more >>

We are planning to upgrade our SQL Server from 2000 to 2005. We have just started testing the performance on 2005 and found that 2005 query optimizer choose wrong query plan over several queries so far. We can force the query to use the right plan. But what worried me is the query is so simple an...more >>

Who do you change the database owner in Database Maintenance Plan that was created with SQL Server 2005? Thank You,...more >>

Hi, Per a request from a client, I added a few new columns to one of their tables. In both the table and column permissions, I don't see these new columns have any different permissions than other existing columns. But the client said he was not able to see the new columns even after he ...more >>

My production seems to, either upon admin rebooting it for updates, or for someother reason set the Recovermy Mode FROM Full TO Simple??? Weird. How can I track down what is doing this? its SQL 2000 SP4. Thanks Erik ...more >>

Greetings, I am running MS SQL 2000 here. We've just found that queries with "not in list" where clauses do not return the rows that have NULL values in the column that the "not in list" clause pertains to. For instance, let's say the column is Auto.makers. The column has the values of Fo...more >>

I have a SQL Server 2005 database that has been having problems since monday. There have been no database changes for about a month, so this strange behavior is recent. Unfortunately, our Test box is not a good mirror of production, so tests to narrow down this problem are tough to perform. ...more >>

I known in SQL Server 2000 it's MS best practice to create database owner as 'sa'. Is this still the case using SQL Server 2005? ...more >>

I have a database on SQL 2000 that is causing me problems.. I have it setup to do a full backup at 5am then incrementals every hour after. I can restore the database to a certain point where it is functional again. However i am wondering, is there a way to open a .TRN file so i can inspect i...more >>

I am trying to delete a SQL Server 2005 maintenance job that I created several days ago. I received the following error when trying to delete the job. Please help me resolve this error message. Thank You, Error Message: Drop failed for 'Maintenance Plan' An exception occurred whil...more >>

Hi everyone, Is there any way I can create a stored procedure/function that will show the number of hours the sql 2005 server users have been logged in? Thanks, Carly ...more >>