http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

There are lots of scripts on this site (See the scripts link on the left) that you can moidfy.

I hadn't thought about the repetitive motion thing. I guess long term it could be, but for presentations, they're an hour or two. I wish I could have swiped at...

It's not quite clear what you are doing here, or how you want to use this. We also like to see you do some work, show some effort in T-sQL...

T-SQL doesn't have a way to do a conneciton. You can use T-SQL to set up a Linked server, which then you can query through, but you can't open directly...

Closed to prevent replies

I stumbled on this one last week: http://www.devx.com/dbzone/Article/40531

Once you restore to a 2008 instance, no matter where the backup is from, the structure changes. Therefore you cannot back it up...

db_datawriter would give them insert (and update/delete) permissions. Check all the groups, look for DENY as ADI mentioned, and let us know which roles the user is a member of.

As Perry mentioned, you can have multiple instances and an upgrade will target one. Someone would have targeted one and the others would remain untouched. That's the idea of instances,...

There's still an Informix building here in Denver, pass it at times. It's supposed to be a great DW engine.

http://www.sqlservercentral.com/articles/1084/

Sue moved over to PM'ing full time, not really much SQL Server last year. I actually was thinking to send her an email and see how she was doing as...

The typo is being fixed.

The developer's edition is Enterprise with different licensing. It includes all features so you can build applications with them. Developer's Edition cannot be deployed to a...

We rerun the best articles at times to ensure that people see them. There's no good way to republish the comments.

There's a bug on the article page that doesn't show...

You need a script to do this. Lots here on the site in the scripts section.