OK, thanks, I will check into it first.

Can you tell me, does the Process id being a negative two (-2) mean anything?

When I tried to kill using that...

Oops, I was mistaken about them being on tempdb. Even though I can access the table now, there are still eleven locks showing for the eorla database. Shoul...

I used Activity Monitor under Locks by Object tab, Selected object of the table in question. It had under Owner GUID the same number of one of the reqtransactionUOW's...

Yes this is a continuation of the other posting.

I ran the select req_transactionUOW command and get 15 id's.

Should I kill all of them?

Thanks.

That's right, sp56 is my connection being blocked by -2.

I don't see a -2 in the list of sp_who2 though. How can I tell if I should kill it?...

I ran the select with nolock and it worked great. I ran without and see blocked by -2, results of sp_who2:

56 SUSPENDED MGH\dmcmillanMGH-9750-05490-2 ...

I did find a couple error messages. It looked like node one couldn't see the SAN where the data files are. We rebooted node one and that solved the...

I did take it offline. We probably won't be using it anymore, the users are accessing a copy of it that I restored on the new server now. Thanks...

We have moved this database to a new server. Now I don't want anyone to use the one on the old server. Could I take the database offline? I...

If restricted user is the same thing as setting the database single user to true then this is what I want. Thanks!

So if model is simple and we add a new user database it will be simple also. Then the new user database can be changed to full and transaction...

I got the file to import. I had set up the connections to the xls file and the sql server database, but was trying to put the location of the xls...

I think the problem might be because the column I don't want to update is taking the first parameter and throwing everything else off.

When setting the transformations I thought I...

That's what I thought but I wanted to be sure.  Thanks very much!

I have seen online a lot of issues with sp2, so I thought I would apply sp1 first. Is everything in sp1 covered by sp2 so you only have to...