I can't...but if I build the script, I can get it on that server which is linked to the other one....and I just need an output file that can be...

sorry all....I wasn't thinking earlier...the reason it has to be done by script and automated thru a job is that the servers being queried are in a place where we...

SQL Compare is an option, but I wanted to do it by script and run it as a job....

I am interested in the schema differences, not data.....my thoughts were to...

We will check it out for sure!! Thanks Roy!!

Thank you so much Roy!! I appreciate all your help!!

I did script out the replication!! Good move and thank you for the reminder!

ok, I will give it a shot! I was hoping and praying it could be that easy, but my reading of articles had me scared!! What a learning...

THANK YOU!!!! Thank you everyone for all the help!!!!!!

but it is set to true (= 1)....

and in the subscription options it is set to true....

now, in looking at the errors previously, I see where it was trying to...

Roy, where is this set :Set the Replicate Schema Change to TRUE

In the replication script that I printed out, I see this: @replicate_ddl = 1.....is that the same thing??

ok, for today's issue....I have a deployment that includes 3 alter tables (2 with add columns, 1 with a drop column and an add column) and add a default constraint...

this is transactional replication and there is both drop columns and add columns and I am looking now to see if there were any other constraint issues too....

OOPS, I forgot to paste in the code that I found...sorry!!

exec sp_dropsubscription @publication = 'tTestFNames'

, @article = 'tEmployees'

...

One more piece of info I wanted to share....I opened up the replication script for TESTBED and it has in there the variable @replication_DDL = 1 (I think that was...

Thanks Jeff, your agreeing with me makes me feel better!! I wanted to use a CTE...thought this was my chance to BREAK INTO them!!