I have two non-clustered win2k servers (advanced server) with SQL Enterprise installed with local storage. Production use has already started on a limited basis. Would it be possible to to in place clustering using the following steps? 1. Installation and configuration of additional hardwa...more >>

I've come across a Transact-SQL statement as follows: -- Statements start here select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from sysobjects where type = 'U' -- end here Questions: (1) How should the 'select' statement be interpreted? (2) What are the rules for u...more >>

Hello, I have a Dell PE6650 with only 5 drives(15k). what is the best raid configuation i can acheive for higest performace with this amount of drives. I was thinking or either of the following Option 1 --------------------------- RAID 1 - 2 drives - os and backups RAID 1 - 2 drives - d...more >>

Platform: Windows 2003 ent ed, SQL Server 2000 sp3a enterprise We tried to bcp file into our Failover Cluster SQL Server database, but with serious error: SQLState = 08001, NativeError = 17 Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. S...more >>

Article 301600 (http://support.microsoft.com/?kbid=301600) mentions that MSDTC should be in its own resource group. - What is the recommended size for the physical disk that needs to be in this resource group? - Is it necessary to add the Network Name resource to DNS? Thank you....more >>

We are in the process of implementing a SQL server and are thinking about a SQL cluster on Windows 2003 Enterprise Edition Servers. But money is preventing us buying extra hardware at this moment. Is it possible to install first an SQL server with all the databases and upgrade it later to a...more >>

Please help me determine what could cause the SQL Server 2000 Cluster error listed below. This is a server with SQL Server 2000 Enterprise Edition as an Active/Active Cluster and Windows 2003 Server. Please help me with this error. Thanks, 00000780.0000149c::2005/01/05-18:22:53.035...more >>

Hi, I have SQL2000 cluster on Windows 2003 (2 Active nodes and 1 passive), one of the active server is missing the SQL performance counters, the weird thing is, if I run Perfmon remotely connecting to this node, it will not display any SQL Performance counters but if I login locally to the se...more >>

I have a web application that takes in thousands of financial transactinos a day, as well as displays all this financial data. I just purchased two dell pe6650 with quad 3.0 xeons, and 12 gigs of ram a piece. Would I benifit from configuring these servers into a cluster or would it be more eff...more >>

Hello, I need a value for switching time sql-on-node-1 to sql-on-node-2 (best win2003 cluster, slq 2000). microsoft says 2 - 30 seconds. Is this a real value? Thanks ...more >>

I am newbie in SQL server and have one, maybe dumb question. I have SQL2000 cluster on Windows 2003 with shared storage on SAN. Cluster operates with one database only. I need to temporary attach second database to SQL server, but problem is that I do not have enought free space on shared stor...more >>

Hello, I appreciate any suggestions or comments on the following. We have active/active cluster, SQL 2000, Win 2000. All databases on first instance/node are on drive E, and second instance/node on drive F. We are trying to move all database files to new drives, P and Q respectively. One ...more >>

Hello, We have Windows 2000 ADV Server with MSSQL Server 2000 in a clustered environment. We have MSDTC up and running fine. We are having some issues with some distributed transactions, therefore we would like to do some tracing on the DTC. I have found the background tracing options ...more >>

I received the Communication link failure from the Windows 2003 Cluster. What can I do resolve this error? Thanks, Error SQL Server <SQL Server (OLTP)>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed SQL Server <SQL Server (OLTP)>: [sqsrvres] printODBCError: sqlstate = 08S01;...more >>