Closing Stored Procedures - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Closing Stored Procedures

Author

Topic

asm
Posting Yak Master

140 Posts

Posted - 2010-09-20 : 21:31:21

Hi,

When i open any procedure for modification and close it.
and again i want to open another procedures then again i have to
select Database-DB Name--progra..--store procedure -- then open the desired procedure...

But i want when i open any procedure and close it.. it should close all selected procedure... like tables

thanks

asm

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-21 : 01:13:44

That's just not how it works. You can build a custom tool I suppose, but it wouldn't be worth it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

X002548
Not Just a Number

15586 Posts

Posted - 2010-09-21 : 10:25:00

What would the world be like if M$ decided to do away with all GUI development tools?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-09-21 : 11:25:31

quote:
Originally posted by asm

Hi,

When i open any procedure for modification and close it.
and again i want to open another procedures then again i have to
select Database-DB Name--progra..--store procedure -- then open the desired procedure...

But i want when i open any procedure and close it.. it should close all selected procedure... like tables

thanks

asm

You should do modifications using a Query Analyser. To open a stored procedure run this

EXEC sp_helptext 'procedure name'

Madhivanan

Failing to plan is Planning to fail

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-21 : 13:38:48

I refuse to use sp_helptext!

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

X002548
Not Just a Number

15586 Posts

Posted - 2010-09-21 : 13:46:38

I would go to PVCS

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

asm
Posting Yak Master

140 Posts

Posted - 2010-10-05 : 04:40:17

Can you please detailed what is PVCS?