I believe if you turn off "fast load" in the options tab the triggers will fire.

HTH

You can use linked servers and the full naming convention. lookup sp_addlinkedserver in BOL

HTH

Yep, placing an instead of trigger will work, I forgot about that, haven't ever used it.

This is something where if you called MS they wouldn't even talk to you until you applied the latest service pack, there have been so many fixes in all of...

Try this one - http://aspfaq.com/show.asp?id=2423

HTH

Not sure on this one but it might be a security check on the security settings of the SQL Server itself. In EM, right-click the servername, properties and look at...

A growth event is not logged, it used to be that way in SQL 6.5. You can sometimes get this error when your process is moving faster than your disks...

There are some quirky things with dtssendmail task, I prefer using a SQL command to call xp_sendmail. You have more control.

I would add that a lot of the physical questions depend on your SCD's and how you handle them. I reccomend any articles by Mr. Ralph Kimball for theory and...

Has the account that runs SQL recently had a password change or become locked out?

Couple other points, if you have created any jobs under the old servername and want to retain them you will have to update the originating server in the MSDB database,...

I believe if you have 50% page frags on a table and you restore it you will have the same, haven't tested it but I don't think restoring does any...

Are you able to reproduce this? And are you saying your .trn backup is 15gb or your LDF?

Ah, OK, I read it wrong, I thought you meant specifically for clustered on idents versus non-idents, thanks for replying

I completely agree Thomas, good questions have led me to test some cool scenarios and thus learn more! (isn't that everyone's goal?)