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

You need to stream this out with ADO. It doesn't need to be C# code, simple VBScript or Powershell could help here.

http://support.microsoft.com/kb/258038

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=4&txtCodeId=7354

http://andrewu.co.uk/clj/load_and_save_file_helper_functions/

you can call system functions in the trigger (suser_sname(), user user_name()) to find out which account is used.