SQL Server Performance Forum – Threads Archive

Generating scripts

when using the management studio i am able to generate scripts of say logins, or permissions. is there some way to generate scripts for objects using a T-SQL command instead?

---

I don’t think there is buildin way for this. However, you might have some luck with sp_helptext. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs

---

See if this helps you
http://www.karaszi.com/sqlserver/info_generate_script.asp Madhivanan Failing to plan is Planning to fail

---

thanks

---

]]>