Tempdb is a database, like the others ones on your system. If it grows, it needs that space to grow. It does not shrink back down once a process is...

Not sure you can read the error log with T-SQL. It's just a text file, so you can scan it with FIND, TAIL or other command line utilities. The downside...

That's an interesting thought on the partitioning. I would think it would be an issue. If you go to SSDs, I think you want to use the entire drive as...

You're certainly not forced to pay for an upgrade, but why would you expect someone to upgrade a tool for free?

Will the database still be correct for testing if you have orphaned rows?

Typically you truncate the children, then the parents. That way your relationships are intact.

I don't believe you can do this with the mdf as well.

ALTER LOGIN (http://msdn.microsoft.com/en-us/library/ms189828%28SQL.90%29.aspx) doesn't map to users. the ALTER USER (http://msdn.microsoft.com/en-us/library/ms176060%28SQL.90%29.aspx) is what you use to connect the login to the user.

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...