thanks for the reply. Not sure whats the difference between yours and mine . Your doesn't work. Thanks

Jeffrey Williams-493691 (8/24/2010)

---

As the error states, create/alter procedure must be the first statement in the batch. In your dynamic query, you need to separate the USE from the CREATE/ALTER...

no replication cannot be an option, firstly setup is complicated as i am talking...

jvanderberg (8/24/2010)

---

You have a BEGIN in your stored procedure code, but no END. That is probably your error.

One of the problems with dynammic SQL is that it can sometimes...

all right another pbm now. Create table works fine but create/alter procedure doesn't work. Can you please take a look at the script which i have attached. Basically i have...

awesome, this is wonderfull. Thanks

I am trying to test this tool, what is Product Code Name? I would like to run DDL's and DML's across different servers on different dbs. Please advice. Thanks

Thanks S.K for the follow up, i haven't looked at the scripts yet but i want the Use[dbname] to be dynamic something like it should get the dbname by itself...

I have something similar to do but my scenario is little different, any suggestion would be highly appreciated. Lets say i need to deploy a stored proc, it has to...

Gail from my previous post i got the second part by using 2008 but does only server level. Still need an explanation for the first part..Thanks again...

Ok Derrick, i have tested it out. The process looks kool but does only at server level, lets say i need to create/alter a single proc but it has to...

Thanks Gail. I still have few questions,

i) How can i use "Use @dynamicvariable" please provide the script if you have.

ii) could you give some more detail on how can i...

let me try that and will let you know.Thanks

so Gail does it mean that i cant use Use @dynamicvariable?. I have a control server and i want to push all the ddl/dml changes to other servers from...

thanks..yeah i knew both the ways..