Dear folks,
I’m wondering how do I obtain full scripts of all the current databases in
a
Sql Server of an automated way instead of choose one in one out from EM.
Does anyone knows or is awared of any mechanism for that?
Thanks in advance and regards,Hi
You may want to look at using DMO to do this for an example see
http://www.nigelrivett.net/DMOScriptAllDatabases.html
John
"Enric" wrote:
> Dear folks,
> I’m wondering how do I obtain full scripts of all the current databases
in a
> Sql Server of an automated way instead of choose one in one out from EM.
> Does anyone knows or is awared of any mechanism for that?
> Thanks in advance and regards,
>|||Eric
There is no such mechanism provided by MS. You'll have to write your own
script to go throu EM
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:469BD8F7-FBAC-4DB2-A20A-AEAF1A9CD565@.microsoft.com...
> Dear folks,
> Im wondering how do I obtain full scripts of all the current databases in
> a
> Sql Server of an automated way instead of choose one in one out from EM.
> Does anyone knows or is awared of any mechanism for that?
> Thanks in advance and regards,
>|||http://www.karaszi.com/SQLServer/in...rate_script.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:469BD8F7-FBAC-4DB2-A20A-AEAF1A9CD565@.microsoft.com...
> Dear folks,
> I'm wondering how do I obtain full scripts of all the current databases in
a
> Sql Server of an automated way instead of choose one in one out from EM.
> Does anyone knows or is awared of any mechanism for that?
> Thanks in advance and regards,
>
没有评论:
发表评论