I have 2 Windows 2003 r2 servers with a SQL failover cluster installed across the 2 node. Generally I have been running off node1 with node2 as the...
hi I am trying to understand the best time to bring down a server for maintenance. I have a number of SQL 2000 and SQL 2005 servers which have many...
Hi Im testing Point in time restores and I put together this test which doesnt work: I have a database called resTest with a table tbl_people(id...
Hi Setting up log-shipping can only be done at 1 database at a time. Is there any way of automating the Wizard in SS to setup it up for all...
I am having a problem using the SQL Server 2000's Copy Database Wizard. After entering the source instance and the target instance I hit next and I...
hi I am trying to use DTS to copy databases using the transfer database object and after I select the locations tab EM freezes. I have 2 instances...
Hi, Does anyone know of what problems will I encounter If I run a dedicated SS 2005 instance and reporting services with DBs replicated from a 2000...
Hi I am running a trace on an SS instance looking at RPC: Completed and TSQL: Batch completed and for some of the very long running queries the...
hi I am trying to move a transaction log file from the same partition as the data file to a new parition. 1) How do I do it ? 2) do I need to...
I am running a performance monitor and am having trouble in identifying the real problem. I have about 5000 Lock Blocks and 25000 Lock Blocks...
Hi How can you identify if a windows machine is running hyperthreaded processors ? Regards
Hi I have a windows 2000 HP-Compaq Server (Proliant ML530) which I have installed the Windows 2k windows component: Network monitor. However I still...
Hi What would I see if I placed a trace on a set of nested stored procedures ? I have looked on the web any information, but haven't found anything....
Hi I have an issue with a very large csv file I have extracted from from performance monitor. It has extracted a file with 2337 columns and I cannot...
Hi I have been looking all over the web recently and I have not been able to solve this problem. I am trying to setup logshipping but it fails over...
I am trying to Link an Excel 2003 spreadsheet to a Enterprise Ed of SQL Server running Windows 2000 AS. I add the spreadsheet as a Linked server...
I have a slight problem with a full-join query which is based upon sub-queries. I have two tables called Activity and Store_activity which are...
Separate names with a comma.
