Roy Ernest (12/4/2009)

---

I hope it is not bad. Maybe the next bunch that takes over the helm will be way better than this bunch. Now is the time when you...

Jack Corbett (12/4/2009)

---

Unfortunately I agree with Grant here. It's never a good sign when...

Grant Fritchey (12/4/2009)

---

GSquared (12/4/2009)

---

I found out late yesterday that the CEO, the President, the Chairman, and the CFO, of the company I work for, all resigned late Wednesday, without prior...

You can also do it through CLR procedures.

I personally like SSMS. Fits my needs nicely.

Since I almost always have it running, I don't use either Notepad or Word, I just fire up a connection window, type...

That makes sense.

No appology needed. Sometimes it takes a second look to find things.

i² ? 42

I found out late yesterday that the CEO, the President, the Chairman, and the CFO, of the company I work for, all resigned late Wednesday, without prior notice, and without...

A usual way to do this is with either a Not Exists statement, or by counting the total records and the number of records in the status you want and...

Q: What is SSRS?

A: 42

Q: What are the advantages and disadvantages of SSRS over competing products like Crystal Reports?

A: 42

Q: Why do you keep saying "42"?

A: 42

All seriousness aside: If...

This is how I like to do that kind of thing in SQL 2000. (It's easier in SQL 2005 with the Pivot command.)

if object_id(N'tempdb..#T') is not null

drop table #T;

create...

Add "and e.server_name is null" to your Where clause.

Left join will hook the data up, but then you need to exclude the ones that have a match.

Your text says you want the second column to be blank, but the actual code tests the exact opposite, so far as I can tell. What am I missing?

And...

Take a look at "Execute As", specifically "Execute As Owner". That should handle the permissions issue you need.

Execution plan caching, or lack thereof. Data caching, or lack thereof. Those two would be my prime suspects.

After you do the restore, try running a few queries with...