In Enterprise Manager for MSSQL Server 7.0, scripts can be created for creating tables, users, views, and granting user rights to those objects, etc.<br>
<br>
Has anyone found a way to create these scripts from the command line? I have heard of the scriptdb.exe that ships with the Back Office Resource Kit but receive an error (CoCreateInstance Failed) whenever I try to run this utility. I need to be able to move native SQL logins and table rights from one server to another after the sp_detach_db and the sp_attach_db procedures have moved the database. If you are familiar with these stored procedures, they allow moving a database and if the authentication model is the NT model then all is fine, but the only native SQL user ID that can be moved is 'sa' or the database owner.<br>
<br>
I am hoping to find a command line utility that will script This file could then be executed on another machine after moving the database.<br>
<br>
Thanks... JS
<br>
Has anyone found a way to create these scripts from the command line? I have heard of the scriptdb.exe that ships with the Back Office Resource Kit but receive an error (CoCreateInstance Failed) whenever I try to run this utility. I need to be able to move native SQL logins and table rights from one server to another after the sp_detach_db and the sp_attach_db procedures have moved the database. If you are familiar with these stored procedures, they allow moving a database and if the authentication model is the NT model then all is fine, but the only native SQL user ID that can be moved is 'sa' or the database owner.<br>
<br>
I am hoping to find a command line utility that will script This file could then be executed on another machine after moving the database.<br>
<br>
Thanks... JS
