Is there a way to generate the files so that they won't contain the "type"?
For example, generating a stored procedure script will result in
sp_name.storedprocedure.sql. I want to generate sp_name.sql.

Thanks

Alex (alexdinu1 (AT) hotmail (DOT) com.(donotspam)) writes:
No, you would have to find some batch-renaming tool to post-process the
the file names.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Hi Alex,
I also find this irritating but it is only one of serveral issues I have
with the way SSMS generates scripts.

I use a tool called "Bulk Rename Utiility" that works pretty well. I
generate the files with the default names and then use the tool to change
them to Create_xxxx.sql.


http://www.bulkrenameutility.co.uk


--
Ray Herring


"Alex" wrote: