I have a same situation (one Kill/Rollback process has been hanging last six month) and I just didn't want to restart the service just because of that. It just bug...

It seems be heavy query if there is a lot of rows in those tables. If this is for the reporting, I don't think you need to run this under "read...

Hi Mike,

that is great commend to know. Thank you..

One note that, it is not always accurate though. I have one Killed/Roll back process that has been there last over six...

hmm..

Is he using SQL login or Windows login? Does the insert happening on only one database or cross database?

I've had that experience and AJ's suggestions are the only thing that I know. I'd like just add to that is, sometimes, #2 will take long time to restart due...

I must confused w/ others factors or something. Based on that article, it didn't mention about win2k or win2k3 different license issue. So David is right. Sorry about confusing.

I just went...

And this is sample query

DBCC SHRINKFILE(Test_Data1,1,NOTRUNCATE)

I put "1" for size but with NOTRUNCATE option, it won't be matter so I just put 1 for anytime.

And here is simple query...

hmm.. somehow I keep loosing posting..

Anyway, that error usually comes from either database corruption or SQL bug. To confirm it, try the "DBCC CHECKDB" and make sure you have the...

It is unallocated space that you will be able to shrink it and I am using this script to figure out what database to shrink/expand. This is very nice one...

Here is my 2cents.

If you really want to secure the SSN or CC#, you have to do it from application side and that will prevent "snipping" between App and SQL...

A few questions. Do you want to have all users have the same permission?

If that is the case, you can just make NT Group from AD and add that NT...

I don't know about Yukon but here is for SQL2K

How to manually remove SQL Server 2000 default, named, or virtual instance

http://support.microsoft.com/default.aspx?scid=kb;en-us;290991

Only minor problem with that is there is possible that you loosing transaction log if you need that. If you don't need that, just change the recovery model to just...

When you talking about SQL Server memeory, do you mean, SQL Server memory that takes up from O/S? If that is the case, once SQL server reserve the memory from...

Please anyone correct me if I am wrong.

I assume that you are using HypherThread since you are talking about logical CPU. Then, first, I'd like to know what is the...