hmmm, I'm lost on the logic on this one, could some step through it please?

any sort of server, clustered and stand alone.

yes, that's right.

nope, none at all. I am running SSMS via an admin box, not locally to the servers.

It wasn't on. I turned it on but the result was the same unfortunately.

But to be clear I can run the query successfully on this and any...

I am just running the query in SSMS or Redgate MultiScript.

no, absolutely any xp_cmdshell would fail, e.g. "date /t".

Many thanks!

Has anyone used the sp_changepublication to include a post snapshot script to include these updated procedure definitions? And do you know if it's OK to run sp_changepublication...

yes, in a query window I paste in, sp_scriptdynamicupdateproc, and it cannot find the procedure.

Not sure how this procedure, sp_scriptdynamicupdateproc , is used, it won't parse for me. Can you give an example of it beign called please?

"There is one other option for...

Not sure how this procedure, sp_scriptdynamicupdateproc , is used, it won't parse for me. Can you give an example of it beign called please?

"There is one other option for...

Not sure how this procedure, sp_scriptdynamicupdateproc , is used, it won't parse for me. Can you give an example of it beign called please?

"There is one other option for...

Many thanks for the post.  I'll experiment with this alter.  I am hoping for an anwser that doesn't require batch files, I had used a similar method a long time...

I have found that maint plans occasionally fail to clean up properly, also believe that maintain backups read from a table in main plan so ad hoc manual backups will...

Any thoughts for SQL 2000 on data files and their space available?