-osql to generate database script????? Please help

[sanjdhiman]

Hi

A very quick question, like you have in Enterprise manager you can right click a database and then choose all tasks and Generate scripts. You get a window to choose all the objects you want to script out.

Is there anyway you can do that using osql?? is their some SQL built in stored procedures or commands which do the generating for you? SQL-DMO???? etc etc

Please help if this is possible or not

thanks

sanj

 

[mrdenny]

Can't be done via osql. It's the actual Enterprise Manager which does the scripting, not the SQL engine. That functionally wasn't built into osql.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com