question sql server

what is the best way to distribute one stored procedure to 50
different databases in 50 different servers?<soalvajavab1@.yahoo.com> wrote in message
news:1178036848.568869.225690@.o5g2000hsb.googlegroups.com...
> what is the best way to distribute one stored procedure to 50
> different databases in 50 different servers?
>
Script it out and use OSQL in a batch file.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||On May 1, 10:31 am, "Greg D. Moore \(Strider\)"
<mooregr_deletet...@.greenms.com> wrote:
> <soalvajav...@.yahoo.com> wrote in message
> news:1178036848.568869.225690@.o5g2000hsb.googlegroups.com...
> > what is the best way to distribute one stored procedure to 50
> > different databases in 50 different servers?
> Script it out and use OSQL in a batch file.
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
Is this the best way?
On other topic, what is the best practice to take care of syslogs?
and what is the best way to move a large database?
thanks|||<soalvajavab1@.yahoo.com> wrote in message
news:1178053985.861219.308440@.y80g2000hsf.googlegroups.com...
> On May 1, 10:31 am, "Greg D. Moore \(Strider\)"
> <mooregr_deletet...@.greenms.com> wrote:
>> <soalvajav...@.yahoo.com> wrote in message
>> news:1178036848.568869.225690@.o5g2000hsb.googlegroups.com...
>> > what is the best way to distribute one stored procedure to 50
>> > different databases in 50 different servers?
>> Script it out and use OSQL in a batch file.
>> --
>> Greg Moore
>> SQL Server DBA Consulting Remote and Onsite available!
>> Email: sql (at) greenms.com
>> http://www.greenms.com/sqlserver.html
>
> Is this the best way?
Given so little detail, it's hard to say, but it's definitely one possible
way.
> On other topic, what is the best practice to take care of syslogs?
>
Take care of how?
> and what is the best way to move a large database?
Depends on if you can take downtime or not, version of SQL etc.
> thanks
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html