script in text in 2005 EM?

Hi,

In 2000 you could script out a file (tables SP's etc.) as text by going under Options -> File Options and choosing the MS-DOS text (OEM) format. I'm wondering where/if this same capability is in 2005. Right now, it looks like the default is binary. Can anybody share some information on this?

Thanks,

Phil

Using SSMS, in the Object Explorer, right click on the database, table, Progamable object, etc., and select [Script ... as]|||

That's only how to script an object. My question is how to script an object as text. If you notice when you script an object like the way you are suggesting, it will by a binary file (atleast when I check it into sourcesafe). This was an issue I had before in SQL 2000, but atleast it gave the option to script the file out to MS DOS (text). Does anyone else know what I'm referring to?

Thanks,

Phil

Script Generation

In SQL 2000 Enterprise Manager, you can create SQL scripts for
procedures by right clicking and choosing generate SQL script. It sets
some database defaults and turns some things on and off. Is there a
way to modify the things that are created to return more data? Is it
in a template where i can add some code. I want to include 1 line in
each script it generates but cant find where to do it. Can it be done?
How?
Thanks so much in adavnce!
-dL
Hi DL,
You can not customize that. Instead you can use SQL DMO to generate customized scripts.
See the below link:-
http://www.karaszi.com/sqlserver/inf...ate_script.asp
Thanks
Hari
SQL Server MVP
____________________________________
Sweet Daddy Coconut Wrote:
In SQL 2000 Enterprise Manager, you can create SQL scripts for
procedures by right clicking and choosing generate SQL script. It sets
some database defaults and turns some things on and off. Is there a
way to modify the things that are created to return more data? Is it
in a template where i can add some code. I want to include 1 line in
each script it generates but cant find where to do it. Can it be done?
How?
Thanks so much in adavnce!
-dL
Sent via SreeSharp NewsReader http://www.SreeSharp.com