Found few online resources,

Cluster Server Hardware FAQ

SQL Server 2000 Failover Clustering

How to configure Virtual Server 2005

Thank you Brian.

What are alternates to Microsoft's clustering solution. What are advantages and disadvantages in case if you have used an alternate solution.

PS: Found this article for alternatives ...

After reading the article "SQL Server:Enterprise Vs. Standard", it answered SQL Server costs as of 2002. Has the prices changed over three year period?

Sushila,

There is no business rule that would dictate any set of guidelines to create this key. Thought about using identity, still debating on using identity. So if you guys have...

Hello All,

Sorry for not mentioning the case clearly.

Sushila guessed it correctly. It's basically generating a alphanumeric key.

For example, in the following table

dbo.Table1 (

Col1 VARCHAR(10) PRIMARY KEY...

Thank you Remi & Yelena:

In the Process Info pane, I saw an open transaction (think its the same that I got when I ran DBCC OPENTRAN). I took a chance...

Less than a second to run four querries, returning more than 2000 records.

There are no processes that are being blocked. So when I ran EXEC sp_who2 all the process have - under BlkBy.

Hi Remi,

I ran DBCC OPENTRAN and got the following result,

Oldest active transaction:

SPID (server process ID) : 68

UID (user ID) : 8

...

Hi Yelena,

There are no process that are Blocked By or Blocking (they are all 0). There is nothing under Wait Resource and for Wait Type they are all "not waiting".

I...

7

I am not sure how many as I am not able to retrieve data from it. SELECT COUNT(*) FROM dbo.TableName is also takeing forever to return the result.

Thank you Brian.

Before I posted the message, I checked for the folder properties and all the files & subfolders in that folder are marked for "Read Only".

I logged in as local admin...

I do not have EM on ServerA where I am having problem with. Is there a SQL command that I can use to change the network configuration?

I modified the windows...