My guess is something broke with the upgrade and there is some dll didn't upgrade correctly. At this point, I'm not sure what you can do, or what I'd suggest....

I somewhat fail to see what's insecure about the Agent XPs. If the auditor's don't like that, did they pass Windows Scheduled Tasks? Is that more secure somehow?

I'd ask them...

The key is for your backup drives to be a clustered resource. They should be visible from both nodes, just like the data files. However the physical drives should be...

This is the first I've heard of it. Does this happen from any SQL 2008 client tool, on any other workstation?

Can you change/add/view linked servers via T-SQL?

Is this what happens?...

Gail is absolutely correct. There is no chance of data loss.

Fundamental backup principle - Do not store backups on the same physical drive as the data/logs. Use a separate drive. In terms of clustering, as George said, get a second...

Lutz is correct. Other administrators will have access, and I'm not sure why they shouldn't have access. What happens if the guy that created it quits?

If you do not assign...

I think I'm in the middle between Jeff and David. The keys are a logical construct. They ought to be decided upon in terms of how we want our data...

It sounds as though you did not stop SQL 2000. You could either detach this db on SQL 2000 or shut SQL 2000 down. Also, be sure that security is...

These are huge topics. It's not something you can do simply.

Here's a link to get starteD: http://www.sqlservercentral.com/articles/70199/

Saw this today. Have you read it?

http://bit.ly/aUh6S

Not that I know of. The counters have to be captured somehow. If clients don't want to do that, then I guess there's nothing to be done.

No idea there. I'm around 21k or so ,and I go 4k a year, so that's a ways away for me.

You can use SETUSER as an admin to check.

Public shouldn't have rights, so be sure there's no deny on that, and check their permissions. If you can't find anything, you...

Jeff Moden (6/10/2010)

---

Heh... I'm going to have to jab my mind's eye out on that one. :pinch: I just got this really live and frightning image of you...