Hi all

In oracle i used to create sql statements using sql
For example :

sql> spool aa.txt
sql> select ' alter table ' || table_Name || ' disable constraint ' ||
constraint_Name ||';' from user_constraints;


sql> spool off
sql> @aa.txt


How can i do the same in sqlserver ?? Can anyone give me an example of
this ..........


Thanks
Shibu

MS Sql Server LazyDBA home page