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

I think you want to say "I hope it is NOT confusing"

It's still unclear to people how you know it's a mobile number if it's in the home or work...

Hey I'm an economics major! I did have 2 years towards a masters in Computer engineering and my first two years of college were CS, but that doesn't appear on...

Hey, nuclear powered diggers!

That's a good point, and all the extra work that goes into building a nuclear plant as well affects carbon emmissions.

But nuclear runs a long time, and...

I forgot about buying a house! I've bought a few in my life, just did another recently, and there's quite a bit I don't understand in there. I suppose if...

Open transaction maybe? Must be some setting on the dev box to prevent this.

This help: http://technet.microsoft.com/en-us/library/bb283410.aspx

Are you using WITH REPLACE?

You can't make the marketing or sales guys pay attention. Their job is to make money on what you do.

Your job is to let them know the impact of this....

When the roles are switched, you want a failover. That will move things back.

ServerA - Principal

ServerB - Mirror

Event happens, server A fails, etc. You now have:

ServerA - Mirror (down)

ServerB...

Is this just execution?

I'd script out a call, could be a stored procedure to sp_start_job with EXECUTE AS, or it could be an insert into a table, and then a...