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

It won't be in program files. This is a service that is installed with SQL Server. Right click My Computer, select Manage, pick services, look for SQL Server Browser Service.

I'd do the backup and restore thing. Be sure that you use WITH MOVE to move the files to new locations/names.

You install SQL Server, this create a master database. Then you overwrite this one with your backup.

This help?

http://msdn.microsoft.com/en-us/library/ms186348.aspx

It's often laziness, people just start writing things and don't discriminate. If we could have a CCIE/MCSE/A+ with 12 years .NET and 5 years SQL Server 2005, that would be...

One more, if the data is supposed to be the same, you could export using BCP to char format and "diff" the text files. DIFF would work, or a source...

I like Matt's solution, had forgotten the EXCEPT clause.

you can also get a tool, Red Gate, ApexSQL, a few others make "compare" tools that will compare the schema and/or data...

create table mytable (id int, firstname varchar(10), lastname varchar(10), tele varchar(10))

go

insert mytable select 1, 'John', 'Smith', ''

insert mytable select 2, 'John', 'Smith', '5553333333'

go

select * from mytable

go

update a

set a.tele =...

I think George has it right in his last post above here.

Great discussion!

http://blogs.conchango.com/jamiethomson/archive/2005/12/05/2462.aspx