<div>
use the MS_foreachTAble &nbsp;stored procedure<br />
<br />
and run the sp_changeowner stored procedure First?<br />
<br />
to script out the tables in the first place... <br />
just right click the database in enterprise manager and <br />
select all task &nbsp;- script ...<br />
<br />
make sure your visit each SCREEN and select all the required functions<br />
e.g. indexes / constraints, etc...<br />
<br />
<br />
but this should be a task you use your modelling/design tool for.... &nbsp;<br />
<br />
what did you use to design the database in the first place...<br />
<br />
<br />
<br />

</div>


use the MS_foreachTAble  stored procedure

and run the sp_changeowner stored procedure First?

to script out the tables in the first place...
just right click the database in enterprise manager and
select all task  - script ...

make sure your visit each SCREEN and select all the required functions
e.g. indexes / constraints, etc...


but this should be a task you use your modelling/design tool for....  

what did you use to design the database in the first place...





<div>
i merely added tables/fields etc.<br />
<br />
what is MS_foreachTAble &nbsp;stored procedure<br />
and sp_changeowner stored procedure ?<br />
<br />
How again.
</div>


i merely added tables/fields etc.

what is MS_foreachTAble  stored procedure
and sp_changeowner stored procedure ?

How again.

<div>
To change the owner for all tables of a database at once<br />
<br />
You can use the undocumented function ms_foreachtable and the stored procedure sp_changeobjectowner in Query Analyzer to archive that quite easy. <br />
<br />
Example to take over for dbo: sp_msforeachtable &quot;sp_changeobjectowner '?', 'dbo'&quot;.<br />
<br />

</div>


To change the owner for all tables of a database at once

You can use the undocumented function ms_foreachtable and the stored procedure sp_changeobjectowner in Query Analyzer to archive that quite easy.

Example to take over for dbo: sp_msforeachtable "sp_changeobjectowner '?', 'dbo'".



<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have abt 100 tables in my MS SQL Server 2000.<br />
<br />
I would like to ask how can i generate a script that will auto these<br />
tables when i move them to another server.<br />
<br />
I also need to change the owner for each table, how do i do that?<br />
<br />
Thanks.
</div>
</div>


Hi,

I have abt 100 tables in my MS SQL Server 2000.

I would like to ask how can i generate a script that will auto these
tables when i move them to another server.

I also need to change the owner for each table, how do i do that?

Thanks.

Create tables in a faster easier way

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.