It should delete and recreate the Procedures on the remote server. As long
"Daves" <dbspam@simnet.is> wrote in message
news:esxYrZQ3GHA.4932@TK2MSFTNGP02.phx.gbl...
> hi,
> thank you very much for detailed help.
>
> I have "Sql admin studio" which does exactly this, the thing is it scripts
> every object in database, not only stored procs. Even though I'd manage to
> cut out only the sp scripts I don't know how to delete only stored procs
> on the remote server... any suggestions?
>
> "Warren Brunk" <wbrunk@techintsolutions.com> wrote in message
> news:uI8LetD3GHA.4764@TK2MSFTNGP05.phx.gbl...
>> 1.Open Enterprise manager
>> 2.Right Click on teh database name and say generate script.
>> 3.Click Show All
>> 4. Choose All Stored Procedures
>> 5. On the formatting table make sure both Generate the Create and Drop
>> are both selected
>> 6.Click OK and name the file and save it to a location that you can
>> remember.
>> 7. Execute the .sql file on your second server is Query Analyzer making
>> sure you have the proper db selected.
>>
>>
>> There are some 3rd party tools by a company called
www.Red-Gate.com that
>> allow you to do complex compare scenarios as well and make life a little
>> easier.
>>
>> thanks,
>>
>> --
>> /*
>> Warren Brunk - MCITP - SQL 2005, MCDBA
>>
www.techintsolutions.com >> */
>>
>>
>> "Daves" <dbspam@simnet.is> wrote in message
>> news:OZ8eJBD3GHA.3516@TK2MSFTNGP06.phx.gbl...
>>> hi,
>>> I need to synchronise local and remote database but only the stored
>>> procedures...
>>>
>>> Any ideas on how to collect all local ones and then create these on
>>> remote db?
>>>
>>
>>
>
>
