Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2008-04-02 : 14:17:22
|
| Hi all,I tried to script a group of stored procs into files. I was expecting them to be .sql files, however I got .PRC.I am in sql200 EM. What is the trick? I don't want to manually rename them individually. Am I missing something?Thanks! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-02 : 22:20:36
|
| Did you do it in all tasks -> generate script? |
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2008-04-03 : 08:43:57
|
| Yes, I did. I have to get several dozens of them, and saved each to its own file. |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-04-03 : 08:53:20
|
| That's predefined extension SQL Server assigns when you script SPs.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2008-04-03 : 09:17:06
|
| Is there a way to change that? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-03 : 22:16:12
|
| Should be. Change file type to all files and put .sql in file name. |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2008-04-04 : 09:06:41
|
| rmiao,Thank you for the reply, but please be more specific. From where can I make the change? Did you mean after I saved them as .PRC files?I have noticed that if I saved them as one file, the default extension is .sql, but when I selected the option of Create one file per object, then I got these .PRC files :( |
|
|
|
|
|
|
script stored proc as .sql file