doh the script i posted was coded for tempdb specifically, this will work in any old database:

SELECT

SCH.schema_id, SCH.[name] AS schema_name,

...

run my script against any database; look at the column...

for files originating from unix, i've always used ROWTERMINATOR = '\r' ({slash r} if the forum doesn't like to print it),

otherwise regualr PC files get {slash n}

sys.index_columns has a 0/1 column named is_included_column;

here's a script example that pulls some of that info out into a comma delimited list that i use for scripting out indexes:

SELECT ...

also if you don't actually turn off the original satellite servers, change all the databases to read only on the old servers the moment you switch over;

it will help...

what i...

you need to do two things;

you'll need a Tally Table so you have all the possible values for your comparison;

second , you have to get your data into a table,...

dtopicdragovic (8/25/2010)

---

Therefore, I guess for Countries Table if I have just a column CountryName I can set it as Primary Key. I don't need to create a new field CountryID....

my table is similar, where we have an ID, cityname,state;, witht he PK being on the identity column ID, but with a unique constraint on cityname,state; at least in the...

one of the options when you do a full backup is the "Copy Only Backup" command, which allows you to take a full backup without disrupting the existing trnasaction/differential backups...

i know SSIS is built for this, but I always end up using what i know well...like you suggest, i do it the way you describe: bulk insert into a...

i believe the error you are seeing is because the service MSDTC (Distributed Transaction Coordinator)

must be running on both servers in order to support the cross instance transaction; you'll need...

low hanging fruit, my friend; so easy i couldn't resist 😀

looks like all you are missing is the FROM clause:

update ct_user

set dbo.nt_name = [ct_users1$]._nt_name

FROM [ct_users1$]

where dbo.ct_user.name = dbo.[ct_users1$]._staffName

i've done something similar two differnet ways; i ended up making an application because i had more control;

you can get a list of servers several ways, form osql to using...