.sql File -- sql server clients

Sue Hoegemeier
4/5/2004 8:15:20 AM

Noor,
In Enterprise Manager, right click on the database, select
All Tasks and then select Generate SQL Script. From here you
can select the object to script out. In the options tab, you
can select the option to Create One File per object.

-Sue

On Mon, 5 Apr 2004 18:54:01 +0500, "Noorali Issani"
[quoted text, click to view]

Noorali Issani
4/5/2004 6:54:01 PM

Dear Professional

I want to export the stored procedures, functions and tables into
textfiles.sql Like if there are 100 tables then it will create 100 sql files
and if there are 200 stored procedures then it will create 200 sql files,
how can I do this task.

Thanks
NOOR

Noorali Issani
4/5/2004 7:50:47 PM

Thanks -Sue

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clients

sql server clients : .sql File