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 |
|
Pinto
Aged Yak Warrior
590 Posts |
 Posted - 2006-09-04 : 08:52:22
|
Somehow I have saved an sp as a template - how do I delete it ? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-04 : 08:55:06
|
| Where did you save the template?In the operating system file system?In the SQL Server Stored Procedures?Peter LarssonHelsingborg, Sweden |
 |
|
|
Pinto
Aged Yak Warrior
590 Posts |
Posted - 2006-09-04 : 09:00:10
|
| Who knows ! But every time I go to create a new sp it opens up with this one. I just delete the text in it and type anew, but it's annoying me ! It doesn't matter which database I am in, if I r/h click for new sp, there it is when the window opens. |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-09-04 : 09:13:20
|
| [code]CREATE PROCEDURE [OWNER].[PROCEDURE NAME] AS[/code]Delete all the code from the new procedure window. and then paste the above code.. and then click on the save template.. sothen everytime you open the code, this code will be displayed.. hope are you looking for this.. Chirag |
|
|
|
Pinto
Aged Yak Warrior
590 Posts |
Posted - 2006-09-04 : 09:50:56
|
| Thanks |
|
|
|
|
|
|
sp template