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 |
|
Valentino99
Starting Member
5 Posts |
 Posted - 2002-09-03 : 04:53:02
|
| How can I close the Query Analyzer Window after my Stored Procedure ends???Does anyone knows a command to do this??Thanks lot |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-09-03 : 05:51:34
|
| No - why do you want to do this? Usually QA is used for development and testing, not firing off SPROCs in production.To fire off a SPROC automatically, use a scheduled job. That way it fires when you tell it to and quits when done. No need to open or close anything on the client. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-03 : 05:56:40
|
| Theres a little cross in the top right hand corner.If you schedule your hand to use the mouse to click on it when your eyes see the proc end then that should close it.You could maybe schedule a job which looks at sysprocesses for the proc ending then call something which closes the window - maybe an app which accesses the window handle. Doubt if you want to do that though.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Valentino99
Starting Member
5 Posts |
Posted - 2002-09-03 : 06:34:50
|
| I would do that, because I would have no connections to my SQL-Server due the Backup!!! |
|
|
|
|
|
|
QueryAnalyzer