Another point...

For a Clustered instance, always use Cluster Manager to start, stop, failover SQL / SQL Agent (or any clustered component), not SQL Server Configuration Manager or Services Manager. If...

Can you identify when the logins first started, and then tie that back to some event on the client (e.g. software install, configuratin change, etc)? If you can identify both...

Not going into the depth that Steve, Grant, Lynn et al went into above (they already covered the background info) ...

The strategy we use as a standard (modified if necessary,...

All the options presented here are better than pushing files to client machines (I personally like the concept of pushing the file to a share that the clients can access,...

Is the T: Drive set as a dependency of SQL Server in the Cluster Group?

I just went through an off-site DR recovery Exercise (Scottsdale AZ, in June - no matter how dry it is, 110 is still HOT; and for all you people in...

Malleswarareddy - No offense intended, but maybe you could try a translator, your English is not understandable. //translate.google.com/?hl=en#hi|en|

For reporting, mirroring with database Snapshots is an option you should consider. You will need to recreate your Snapshot(s) on a regular cycle (depending on your requirements). You may be...

snu155 - fragmentation as caused by file growth is OS file level fragmentation, not data fragmentation (as resolved by re-indexing). SQL Server is susceptible to file level fragmentation just as...

A couple of general points to take into consideration...

(1) MS recommends that you dont have any SP content database over 100GB, so if any of your content databases are over...

DMV's are not in SQL 2000 - this won't work in that release.

Question - If you are rebuilding the Clustered Index, why do you then rebuild all the other indexes?

ProcessNextServer: the : is a label identifier, in this case the label is a target of a GOTo statement -

ProcessNextServer:

--

--Code goes here

--

GOTO ProcessNextServer

I did originally design the system using Service Broker Queues, but that just added complexity without functionality, I finally realised that KISS applied, and stopped trying to using SB Queues...

The article was about how to process a single data set using multiple processes. The concept is how to start multiple independant non-overlapping processes against a single table. My example...

[p]Charles, I think you missed the point ... [/p]

SQL will SMP parallel-process out of the box, automatically generating query plans to take advantage of multiple available processors as appropriate. The...