|
Home > Archive > MS SQL Server > February 2006 > sql 2000 scripts
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| farshad 2006-02-10, 11:23 am |
| How can i set something up so that a new sql script is generated on a regular
basis for the tables, stored procedures ?
This is because the tables, stored procedures change once a day. So that we
can just run the generated scripts on the required sql servers.
Thanks
| |
| John Bell 2006-02-13, 7:23 am |
| Hi
You can write a procedure/program that uses DMO to do this and then shcedule
that. This may help http://www.nigelrivett.net/ DMOScri...se
s.html
John
"farshad" wrote:
> How can i set something up so that a new sql script is generated on a regular
> basis for the tables, stored procedures ?
> This is because the tables, stored procedures change once a day. So that we
> can just run the generated scripts on the required sql servers.
> Thanks
|
|
|
|
|