Actually when you are consulting as a "freelance" things are very different you plan your vacations, you look for your own clients and you get usually a better deal in...

>>> i want to replicate the dev db to live but this causes problems with the live text catalogs <<<

What Problems are you seeing ?

After you Detach, the Database Properties is not available (you won't be abe to see it in EM any more until you attach)

By the way when you attach you will...

....

While @@Fetch_Status = 0

BEGIN

Exec Master.dbo.xp_sendmail @MyRecipients, @MyMessage

Fetch Next From MyCursor Into @MyRecipients

End

....

Change the order

 I know some people that manage 200+ servers, for them 20 is small-ish

IF Object_id('##table') > 0

begin

...

end

... Tag Team  strikes again

[edit:]

Remi,  What do you mean by ...team tag team .. ?

if exists (select * from

INFORMATION_SCHEMA.TABLES

where

TABLE_NAME = 'Your Table'

and

 TABLE_TYPE = 'BASE TABLE' )

begin

--- create table ...

end

Ross,

You still need a Primary Key to be able to determine which of the duplicates gets the First id or the second or the thrid ...

For example: