Hi All, We get very strange hang situation at our customers from time to time. I execute very simple query like insert into <table1> select <columns> from <table2> where <conditions> Table <table1> has clustered index on float column. Normally this query is executing, say, 2 minutes. ...more >>

Hi (We are using Sql 2005) I'm using the master.dbo.xp_cmdshell stored procedure to move files from one folder to another as part of a backup maintenance place. We have to move the existing files to another folder and the files in that folder to another folder prior to archiving. Question...more >>

I am looking to create a forum for our users to fill in order to get access to sensitive data on our SQL Servers. Does anyone know if there is anything out there that I can start with? Any help is greatly appreciated. Thanks in advance! ...more >>

one table is growing too huge in production server (sql server). It will threaten our server, and becomes the bigger problem needed to be solved. Could anybody tell me normally for big size table, what and how should you normally do on it? thanks a lot! ...more >>

Hi, In a table I have tblID, customerID, test_results. Summing the content of test_results, gives 89. Counting the results for a giving customer gives 24. To calculate the average test results is done simply by 89/24 = 3.71. However: Sum(test_results) / Count(test_results) gives 3. ...more >>

Dear all, I really need you help on this. One table is growing too huge (millions) on our production sql server. It becomes an urgent issue to our company, and my manager asked me to solve this problem. Could you give me any suggestion? what and how should i do? For big tabke size, normally...more >>

Hi I'm interested to know what the besrt way would be to create a sequenze number. How can I prevent that a number will be created twice? What are your thoughts? Thank's Michel ...more >>

one table is growing too huge in production server (sql server). It will threaten our server, and becomes the bigger problem needed to be solved. Could anybody tell me normally for big size table, what and how should you normally do on it? thanks a lot! ...more >>

I have a SQL Server linked server setup on a SQL Server 2000 Standard Edition. When I run the query listed below with literals I received the error listed below. If I run the same without literals listed below I received 0 output rows. I know this query should output approximatel...more >>

Hi, We will be trying a trial of Quest's LiteSpeed on one of our SQL2005 servers soon. Is this a good package that does what it says it will do in terms of compression and speed? Is it easily configurable? Any comments are very welcome. Thanks Chris ...more >>

Hello, this might be a stupid question, but how would i go about getting the dates that are NOT in the table. For instance: Table contains these dates: like a calendar with sat and sun missing, but also some of the dates are weekdays too. I need to find out which date(s) are missing from the li...more >>

SQL2005 EE I am seeing the following block excessively throughout day. Any ideas why? what can i do? tia Chris EXECUTE msdb.dbo.sp_sqlagent_log_jobhistory @job_id = 0x1B5CB78EFCD08241B30869DAF75B9723 , @step_id = 1, @sql_message_id = 0, @sql_severity = 0, @run_status = 1 , @run_date =...more >>

Hi: After a disk failure in the RAID was fixed (disk replaced and resych completed), a DBCC CheckDB shows the following allocation errors but only on the TempDB. I restarted the Services, got a new fresh tempdb with no errors when checkDB'ed but as soon as users get on-line and the databas...more >>

I know that even amongst the guru's here we sometimes get differing opinions....I'm curious about a couple of issues very important to me right now. 1. I've asked about performance related issues that might arise from queries that execute across databases in the same sql instance. For the...more >>

I am looking at the performance of one of our production servers and have done Perfmon. I am seeing a definite bottleneck on the following drives I, L, H and J What do you thing and is there anything else I am missing here. Thanks for your help. PhysicalDisk E T ...more >>

I have a table with identity inserts off. Depending on incoming id values, i need to bypass this and allow the incoming values to be inserted. Is it possible to do this using triggers? I tried to create an INSTEAD OF INSERT trigger on the table, did a SET IDENTITY_INSERT ON statement there ...more >>

Hi, We do SQL 2000 Log Shipping of about 15 databases from two local servers to our remote disaster recovery site. In general, it works just fine. But, I have one database for which the shipped transaction log files never get deleted, and they just keep building up until I manually delete...more >>

For an existing database is there an automated method of calculating the storage saving of using varDecimal storage type? ...more >>

Before migrating an application to SQL2005, I am checking the performance of it and comparing it with the performance in SQL 2000. I have found a big query that has 1000 selects of constant values joined by union all; in the first execution, it takes more than 20 seconds to run but in sql 200...more >>

i have to restore database from production bakup to development everyday, there is a program which does this bakup and names the file like PROD_20070523.BAK based on the date. is there any way to run this with SQL agent and make sure everytime the current file is backed up. can i rename the fi...more >>

Hi, to all I'm planning to upgrade my Windows 2000 server (No Domain/AD, its just a stand alone server) to Windows Server 2003 R2 SP2. I have Microsoft SQL Server 2000 - SP3a running on the server. Can i make a normal upgrade without losing any configuration, does the SQL Server 2000 an...more >>

Hello Is it possible to connect to SQL Server 2000 Analysis Server from SQL Server 2005 Management Studio? Should I use some special settings to SQL Server 2000 Serevr or SQL Server 2005 Client? I`ve tried to connect in the same way i do it for 2005 Analyzis Server (using Widows Authentication) ...more >>

hi, when trying to automate a job using the agent in sql server 2005 i am getting this error TITLE: Microsoft SQL Server Management Studio ------------------------------ Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Ma...more >>

Sqlserver 2005 SP2 Hi All, Upon completion of a job, an email should be sent to an operator but instead it return the following error: Message The job succeeded. The Job was invoked by User. The last step to run was step 1 (Daily Backup). NOTE: Failed to notify 'John' via email. ...more >>

Hi all, I wonder if someone could explain to me why the script below runs fine against an SQL2000 server but fails against an SQL2005 server with: invalid object name 'People'. . The connection to the database works fine. If I supply the wrong password I get a login error message. Here i...more >>

looking for a script to run so that it will stop all SQL server services and start them later . I need to do system backup and need to capture every thing and then start SQL server services. Any help Thanks, ...more >>

I have the following problem in a Win 2000 Server + SQL Server 2000 environment and I hope somewhat can help me to resolve it (after many days of useless attempts I am desperate). In my database I have two table: - master(id, field1, field2, ...) - detail(id0, id, progr, data, sede, esecuto...more >>

Is there a way to have SQL Server Management Studio save the script for everything necessary to alter a table when changing the design of a table? The older Visual Studio interfaces would allow this - maybe I can discover where to turn that on in Visual Studio 2005? -- Thanks in advance, Les ...more >>

Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'PAC_APPS2' as 'PAC01\Administrator' (trusted) Starting maintenance plan 'DB Maintenance Plan_weekly' on 5/27/2007 2:00:01 AM [1] Database IER: Database Backup... Destination: [E:\MSSQLSERVER\DATA\MSSQL\BACKUP\IER...more >>

Could someone point me to a website for examples of vbscripting to a sqlserver 2005 db? I need to truncate a SQL Server 2005 table from a remote server and I just don't want to put any more effort into this than I have to. Microsoft's script repository isn't of much help. I have a piece...more >>

Programatically in a stored proc, Is there anyway to copy/create all indexes from one table to another table provided both tables have same column deifinition? Please let me know....more >>

I've been running a SQL script for years, now it keeps erroring with a 1204 lock. The quantity of data hasn't changed. I'm running SQL Server 2000 SP4 8.00.2039. on a Windows 2000 Server with 2 gb RAM and of my 100 gb drive I have 40 gb free. The # of locks was set at 10,000 and I upped it ...more >>

I have a A/A/A/P Sql cluster with one default and 2 named instances. I installed SP2 on the default instance, when I go to install on one of the named instances is says it cannot install and stops(does not say much at all). what can i look at to see why it will not install? thanks Rick. ...more >>

am using Sql Server 7 as my database and it resides on a server ruinning on Windows XP. I have used the ODBC DSN for sql server and it worked on stand alone perfectly but when i tried to reconfigure the ODBC DNS for other client syustems to connect to the SERVer it is giving me this error ...more >>

All, I'm trying to understand some index fragmentation I'm seeing in SQL 2005. (I'm using the dm_db_index_physical_stats view for fragmentation information). There are about 5 indexes on a table that has INSERT and SELECT activity only, there are no updates once a record is written. It's somewh...more >>

I'm trying to migrate a mysql database to sql server 2000 (then I'm going to upgrade that to 2005). I downloaded myODBC and was able to import most of the tables, however when I try to import the largest table (about 18GB) it fails by running out of memory. The machine I'm using has 4 gigs of ...more >>

Is it possible to have a pre-built trace run daily for example at a certain time for an hour. Save the results to a new table in a database after each run? ...more >>

Problem of update Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896), tried many times still can't update this... Is this necessary to update this ... who can solve this update failure problem to me .....more >>

Hello! We have a Java application where some things are indicating that it can not run against a SQL Server 2005 database when database mirroring is enabled. We're getting an error message in the application. SQLState:HY000 ErrorCode:0 [DataDirect][SQLServer JDBC Driver][DataDirect][SQL...more >>

Hi, Someone send me a SQL db which they said they compressed. The guy who sent it to me is on vaction. It is compressed with .lsb compression. Does anyone know how the heck I get it unzipped? thx...more >>

Does anyone know of any general KB articles or other resources I can check to troubleshoot stack dump? Thanks, Mike - mstuart_at_gates_dot_com...more >>

Hi, We have 8 SQL2000 databases running in a live enviroment with 2 developers needing write/read/create access. Inside one of the DBs I have created a new DB Role called db_nodelete and revoked delete access which works fine for the dev team. To do this across all 8 DBs and tables will take ...more >>

Hi Could someone tell me whether I need to use the same edition of Sql Server in Dev, UAT & Prod. I need Enterprise Edition in PROD but wonder if I need to develop and then test it in UAT on Enterprise Edition and thereby consequently buy 3 Enterprise Edition licenses. -- Cheers Bil...more >>

I created a view with a join between a table in the master-database & a table in a linked database. When I run this view, there is no problem at all. When I try to save this view. The system is hanging. When I stop the process and look in the current activities there is a locking process caused b...more >>

Good day. I am using sql 7 right now and i think there might some problem in connecting in single-user mode.The situation is like this i need to connect my database in single-user mode for me to issue a dbcc checkdb repair_rebuild command.So in command prompt i issue a sqlservr -m after stop...more >>

I have SQL Server 2000 link server set up on the nm_lights server. I am only able to list out the system tables from the linked server. When I run a query from this server to the linked server (nm_lights) I received the error listed below. Please help me resolve the error listed below ...more >>

Anyone using HP Blades for their SQL servers ? Any cons that I need to be aware of ? Thanks ...more >>

I had SS 2005 standard installed on my laptop ( my only computer at home), then tried to install the Developer Edition of SS 2005, I wasn't paying attention and should have known it would not install properly, as I have Windows XP Media Center Edition (I used to have XP Pro which had no proble...more >>

How to copy the .bak file from another computer(which is on differnt domain) to local computer using windows commands. I would like to do that file copy using command prompt. Here is what I wanted to do: 1) logon to different computer(in different domain) 2) copy the file to local comput...more >>

Hi. I'm trying to use xp_sendmail with SQL2005 in 9.0 mode. I know i should be moving foward with dbmail but I can't right now. I have set it up correctly - the mapi profile test from sqlagent works I have allowed use of xp_sendmail in surface area configuration. but... when i run 'xp_sendmai...more >>