What should the default be? Should all PKs be non-clustered? It has to be one way or the other in the system and I'd like to think that whoever build...

Good to hear! I'll make an announcement to the rest of the site.

If you look by the bottom post there's a drop down with post options. You can choose to apply settings to one or more posts. Not sure how useful this...

Shouldn't be any repearrs. There are some similar ones, but not repeats.

Please try these feeds for the Zune:

http://feeds.feedburner.com/ SqlservercentralcomWmv

http://feeds.feedburner.com/SqlservercentralcomArticlesTaggedEditorial-Mp3

Did you add the new user as a login to SQL Server? By default, administrators have rights to log into SQL Server.

I believe that list is populated from sys.databases, so if it's in there, it should be there.

However it's possible there's some ownership problem. Who owns the new database?

The image doesn't...

sp_help_revlogin is a script that can create a script for logins from the old server.

This sounds like homework. Please show some effort in creating a trigger and using basic logic. This isn't that hard and we'll help point you in the right direction, but...

If it's that important, call PSS. They'll walk you through the process.

What did you do when you created the database. running the script does not necessarily add data to your tables unless there were insert statements in your script.

Look through the...

I'd agree with the above advice in general. DTS or SSIS could be used, or a simple script in a job. However maintenance plans work great.

How much is your data growing by? 75GB isn't that much and it's good to keep free space in there. It's used during index rebuilds, data growth, etc.

As Gail mentioned,...

Is there a reason why you're concerned about this?

They can be different from vendor to vendor, so you might need to go to their training.

However I'd start by buying a cup of coffee or a box of doughnuts...