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

Sorry, bad question. Everyone gets points.

Richard,

As much as I'd like to get up some sympathy for the Marketing guys and gals, I'm sure that they could focus on lying about other products for a year...

The automation is the same whether it's a scheduled job or an unscheduled job. You still would create the scripts to perform the restore.

If you have the logins, you can...

What do you mean change on the fly? Change from 11 to 12 to 1 (13)?

It's not clear from your question what the requirement is.