Scripting DB Objects using TSQL 
Author Message
 Scripting DB Objects using TSQL
Greetings ALL,

How can I script DB objects dynamically using TSQL - I need to get the same result as I would have got
If I have used the Server Manager and Scripted the Objects.

TIA,

Dummy & Dummy



Sat, 03 Jun 2006 22:16:10 GMT
 Scripting DB Objects using TSQL

I don't think you can do this directly using t-SQL. The only alternative to
using Enterprise Manager to scripting the objects is to use SQL-DMO directly
with a programming language like Visual Basic.

--
- Anith
( Please reply to newsgroups only )



Sun, 04 Jun 2006 04:43:51 GMT
 Scripting DB Objects using TSQL
Ken Henderson's new Guru's guide book has got an example of how to script
objects from T-SQL, but I think it's along the lines of what Anith
suggested - it drives the COM interface for DMO.

Regards,
Greg Linwood
SQL Server MVP


Quote:
> Greetings ALL,

> How can I script DB objects dynamically using TSQL - I need to get the

same result as I would have got
Quote:
> If I have used the Server Manager and Scripted the Objects.

> TIA,

> Dummy & Dummy



Sun, 04 Jun 2006 07:36:32 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Generate SQL Script for all objects in a database programmatically using TSQL

2. How can I script db from tsql script?

3. scripting object through TSQL

4. any body has a script to script users permissions on db objects

5. DB Creation using TSQL

6. Scripting db objects

7. Scripting DB objects

8. generating all objects from db via script

9. Job to Script DB Objects

10. scripting for modif the DB - missing some objects

11. Automated db object scripting

12. how can i script my db objects with stored proc running by a job


 
Powered by phpBB® Forum Software