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.googlegro ups.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.googlegro ups.com...
>
> 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.googlegr oups.com...
> On May 1, 10:31 am, "Greg D. Moore \(Strider\)"
> <mooregr_deletet...@.greenms.com> wrote:
>
> 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

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:[vbcol=seagreen]
> <soalvajav...@.yahoo.com> wrote in message
> news:1178036848.568869.225690@.o5g2000hsb.googlegroups.com...
>
> 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[/vbco
l]
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:
>
> 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