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.

I left that alone since it wasn't a correct answer.

It's been removed.

You cannot share ports among services. Doesn't matter if it's SQL, IIS, etc. Each service needs it's own port.

For named instances, they run on another port. The error log will...

I was asking specifically because I haven't seen any that would help you decide here. It seems like it's mostly a gut feel based on some numbers, but a guess...

The typos have been corrected

Wow, a nice technical discussion on The Thread.

Who'd have thought?