Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Generate Script File Name Expand / Collapse
Author
Message
Posted Wednesday, July 2, 2008 12:15 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-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
Posted Wednesday, July 2, 2008 8:17 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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 »

Add to briefcase

Permissions Expand / Collapse