Sql Server 2000

While creating the database script using EM

right-click the database to script, point to All
Tasks, and then click Generate SQL Scripts.

This creates a script with owner of the objects, like
CREATE TABLE [usera].[tbl_wi_lookup] (
[wi_lookup_id] [int] IDENTITY (1, 1) NOT NULL ,
[wi_lookup_type] [varchar] (50) COLLATE
SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[wi_lookup_value] [varchar] (100) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

But i want to create a script without the user of the
object, because i want to run the scripts
under another user name. So that the owner of the
object will be changed. I want to get the
ddl of the database objects only (without the user
owning the object).

Is there a way to do it? Please shed some light.

Kumar


________________________________________________________________________
Yahoo! India Insurance Special: Be informed on the best policies, services, tools and more.
Go to: http://in.insurance.yahoo.com/licspecial/index.html
MS Sql Server LazyDBA home page