Blocking chain (query from activity monitor).

--Borrowed from the activity monitor

SELECT

[Session ID] = s.session_id,

[User Process] = CONVERT(CHAR(1), s.is_user_process),

[Login]...

I stopped asking why many moons ago.. just give you headaches ;-).

Do you have the new execution plan? At least we can see how we can help there.

Ninja's_RGR'us (8/9/2011)

---

Yes, but will it do it if the db name is different from...

All of them... http://technet.microsoft.com/en-us/library/ms179932.aspx

Are you reffering to the inserted and deleted tables only available in the triggers?

Yes, but will it do it if the db name is different from the...

Never tried that. What happens when you run the test?

Weird!

http://msdn.microsoft.com/en-us/library/ms189799.aspx

What did google turn up?

This sounds like an interview / exam question.

What did your research find out, where are you getting stuck and where do you need o go with...

Sounds like ram failure. But I'm not a network admin so I might be 10 miles away on this one.

Can you run the same query straight on the correct...

Adam Durr (8/9/2011)

---

if you use the overwrite option during the restore then it will succeed, but the data will be overwritten. Thats the only way I could see the restore...

You know where to find me when you need me :-P.

Just remember that ungodly amount of $ is whatever figure you have in mind now and then multiply by...

Thanks to everyone's who's helped so far.

I've heard he's...

CptCrusty1 (8/9/2011)

---

This "individual" is supposedly very skilled in SS2K8, but then asks me stuff like this...

Ok... I have a proc now:

sproc_blah (@table varchar(5), @ID int, @returned_Stuff INT OUTPUT)

HOw the...

P.S. I'm done skimming this and there seem to be a lot of things that could be merged.

There's no way we can refactor this over a forum thread. We...

This is where the 1000 of man hours come in.

Install 2005 trial (or the real thing if you have the license).

Run the upgrade and test the code.

You have to do...