I'd say that you should wrap them in an IF clause, but if you can't add a parameter or logic, that might not help.

Are the print statements used? If not,...

Adding a post to the virtual briefcase has been discussed and it's on the list. Not sure where we are on priority.

Are you trying to sort all threads instead of...

Joe,

Apologies for missing this the last couple days.

It's a good idea. What about an "On the Edge" section with forums for HA, VMs, DR, VLDBs, etc?

Ryan,

Thanks for the response and appreciate your insight and opinion. I'm sure that the testing part is hard and I don't have a solution to implement it. I can definitely...

It's true. I heard about it from people at MS on Sunday.

The funeral is tomorrow in OK, flowers have been sent on behalf of the community.

First I want to be clear that I'm not blaming the developers for this. I have contacted some of them, see them in the MVP newsgroups and I think they're...

Great article!

Andy and I have talked about this for years and I thought this was a great technique for managing things in a small environment. We had something similar in...

Password Safe here. I''ve done the envelope thing and given it to a non-technical person, like the CFO or director.

However these days I'd copy the PWDSafe files and put them...

Create a role, add the user to the role.

Grant permissions to the role with GRANT SELECT on MyTable to MyRole. Use appropriate permissions for your role.

Shrinking a db should be a very rare event, usually in response to a one time load. Keep some pad in your database to accomodate data growth, as Matt mentioned.

The...

Use SQLCMD with SS2K5

Visio will work, but it's a little flaky and that' s not it's intended purpose.

Embarkadero has ER/Studio, which I liked better than Erwin.

Not sure about this. I'd think this is more of a Windows monitoring tool than a SQL Server tool.

I believe you can override your own user level, or maybe just Brian can as a moderator. Not sure what it means, but he has a duck on his shoulder...

The point of the question is to get you to think and maybe look at something new with SQL Server. If you knew all the answers, it wouldn't be fun.

I...