I'll post the file here. good luck.

Please post it on the T-SQL Challenges site.

We'll never stop all leaks/breaches.

We'll never have perfect security.

We'll never run out of criminals. Sad, but as there are fewer of them, the stakes go up, more people become criminals,...

4th or 5th no-no this year lost in the 9th. We'd have a record no-no year if those had been completed. Props to the manager for leaving him in there.

If the files are detached, they should not be in use. You can grab filemon (http://technet.microsoft.com/en-us/sysinternals/bb896642.aspx) and check that.

I would lean towards permissions as well.

You have to define separate steps in a package to do this. You can either use the export wizard and run it multiple times, or save the package it generates,...

Auditing sysadmins is hard. Especially since the sysadmin has to set things up!

SQL 2008 has good auditing capabilities, and what you need to do is write audit records to a...

Glad you like it. I use Live Mesh as well, to sync writing drafts, sql scripts, etc. across computers. For short notes, I like having them on my phone. Plus...

I'm not a big candy guy, but there is one that I usually can't resist.

I think exercise has worked well for me. We used to play ping pong, throw a football, etc. at work and discuss things. We solved a lot of problems that...

Good to hear.

Note that you can use an FQDN, like "sql.mycompany.com, 4000" or a server name "SalesDBServer, 4000" as well.

I think Andrew is correct. If you have that database selected in EM, or a query window open, there's a shared lock on the database.

Select master, the right click your...

Have a nice, quiet, last day and best of luck in the new...

Very nice idea.

It's not often we get positive feedback, but it can really help.

Wish me luck. My PASS Board interview is tomorrow. We'll see if I'm still in the running after that.