Are these mapped to users in the databases? Keep in mind that a new instance has it's own logins. If these are used by some process or there is some...

Doh, sorry George. Missed it. My apologies there.

We'll see if the OP responds there. I wonder if they'll go elsewhere.

A crazy requirement, to be sure.

I'm not sure there's a standard. The recommendation from MS is to use trusted connections since you have a nice audit trail, and you can depend on AD for one...

I tend to agree with Colin here. If you're returned some value, it might indicate an error. Does anything return when you execute this?

I would typically recycle logs once a...

Gail,

Thanks, never knew that. Does it apply from 2005->2008 as well?

I would go with A, notify my friend. I'd ask them to point it out to management, for a couple reasons. One is that if that data were copied from...

paul.knibbs (2/2/2010)

---

I wouldn't exactly call it a hole--if someone you don't trust has Admin access to your server then them being able to gain access to the SQL Server by...

I'm not sure it's recompiles. I've seen people report poor performance from procs and queries for a period of time.

Nothing makes sense, but it's like the old "reboot" advice....

I'll disagree in that I like the backup to database. It's easy to copy that data back from a restored db to your primary, and you'll easily identify this as...

richardd (2/2/2010)

---

SQL Search is a very nice tool, but unfortunately it's not going to be free for long:

...

Given Red Gate's policy of forcing their "free" tools to expire and requiring...

blandry,

I think most things become a grind at some point. Even the things you love will be work at times. And lots of it is in your attitude. As long...

LOL, Barry, I'd forgotten about your article. That's a great one!

They have to be stored somewhere since you don't need to rebuild stats on a restart of the server. They should be in a backup, and I would agree that...

Partitioning is only for tables, for certain data. Note that backing up a partition, without considering all of the other related data, might not get you something you can use...