Generate Script File Name

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Generate Script File Name

Generate Script File Name

Rate Topic

Display Mode

Topic Options

Author

Message

SqlUser-529296

Posted Wednesday, July 02, 2008 12:15 AM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, October 14, 2009 1:56 AM
Points: 438, Visits: 754

Hi all,

In Generate Script i have an option like "File per Object". If i use this i will get the file name as "dbo.Test.stored procedure", "dbo.Sample.stored procedure". This is ok.

But i want the file name as "Test.sql","Sample.sql" like this instead of above file name.

In Generate Script, how can i achieve this.

Thanks for your assistance.

---

Post #527041

GSquared

Posted Wednesday, July 02, 2008 8:17 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

I don't believe there is an option like that. Either create one file that you name, or multiple files that are named based on what they are.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #527354

« Prev Topic | Next Topic »

Permissions