Mike M (9/2/2009)

---

There is an SSMS tool pack that you can install as an addin to SSMS. That allows you to color code each connection. You can find...

As Gus says, you just make a big @cmd string, as big as you need. Put the 'USE [' + @dbname + '];' at the beginning and that should...

Definitely my favorite comment of the day! 🙂

HINT: you are updating the MIN record in a group, but you want to update the MAX instead. So look at changes like: "MAX" vs "MIN", "" and ORDER...

I believe that eHarper is onto the key to this problem. There is a notorious "feature" of SQL Server and Windows in that their Day Zeros are one day...

Still waiting for an answer ... ?

Can you show us an example of what you mean? Plus the BULK INSERT command that you are currently using? thnx...

Elliott W (8/31/2009)

---

If you stop and start SQL I can almost guarantee your database will be corrupted. Been there done that. You will just have to wait or...

Well, A) you cannot do that, and B) that's not what the error message is about.

Try making the t2 index on DATE_TIME into a clustered index.

Where is sp_exec_init documented?

The error message is self-explanatory. What is your question?

No, these are no different the KILL-ing the process. ROLLBACK IMMEDIATE, simply...

No there is no other solution. In fact those previously mentioned are not "solutions" either.

Killing a process is easy, but killing a DML transaction in progress...

thanks, Mark.