Please don't use the subject line for questions. Ask the question in the post.

Back up the model transaction log. I think you can start SQL Server in single user mode,...

No real risk, but I think you might need to grab a full backup when you change it back.

You have no choice there. If you need Agent to restart SQL Server, then you have to do that. However, the local services allow for a restart.

If you have major...

The data has to move, one way or the other. The thing you want to do is minimize things. So, is it less if the data moves to the report...

You don't need internal variables.

You might need to convert/cast to get to numerics and then do your math

select (cast(arrivetime as int)/60) 'Minutes'

Please don't repost full article text. It's a copyright violation. Link to it and quote if you'd like.

They are interesting articles.

Is there a question here?

Please read Books Online or research a little. There are lots of examples for triggers out there.

Replication deals with transactions. If there were an issue in the middle of the transaction, it would roll back. If it is committed, it's there.

Are you using WITH REPLACE?

Not that I know of. The CREATE PROCEDURE needs to be the first command in a batch. You could perhaps call this dynamically

declare @cmd1, @cmd2

select @cmd1='create procedure sql2k as sxxx'

select...

I like that one as well! It's entered in the XPrize.

Never seen that, but if they get around it, I can think of two things:

1. They have linkages between rows, so I know long procs sometimes have two rows in...

Copy and paste will move stray characters. You'd have to retype it.

If you run various sections alone, do they work? Can you run the IF only?

Do you know all the actions? Can you change that to an "IN" instead of a "NOT IN"

DO NOT use domain or local administrator. There is no need and no features are lost.

DO NOT use anything other than Enterprise Manager or SETUP to set the account to...