Generate Script File Name

• SqlUser-529296

  SSCarpal Tunnel

  Points: 4072

  More actions

  July 2, 2008 at 12:15 am

  #194602

  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.

  ---

• GSquared

  SSC Guru

  Points: 260824

  More actions

  July 2, 2008 at 8:17 am

  #837261

  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