Is it posiable to close the screen

Hai

Is it possiable to close the current connection screen in the query
analyser , not to close the query analyser.

With Thanks
RaghuControl+F4 or click the window close button.

--
David Portas
SQL Server MVP
--

"Raghuraman" <raghuraman_ace@.rediffmail.com> wrote in message
news:66c7bef8.0402150118.44139866@.posting.google.c om...
> Hai
> Is it possiable to close the current connection screen in the query
> analyser , not to close the query analyser.
> With Thanks
> Raghu|||
Dear Portas

Thanks for your suggestions. Actually i meant that query thru code .

Eg

The shutdown command(sql server7.0) removes the network connection from
sqlserver.Like wise is there any command to close the current screen of
the query analyser.

With thanks
Raghu

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||No. Transact SQL isn't an application development language - it doesn't
control the client GUI at all.

Use another language to execute your SQL or, if you want to run some batched
process without a GUI, run the OSQL utility from the OS command line.

--
David Portas
SQL Server MVP
--

Is editing possible in QA 2000 debugger?

Hi,

Just started using the debugger in Query Analyser in SQL Server 2000.

Is there a way I can edit the code? It's nice to be able to step through the code,
but I don't seem to be able to edit it.

Cheers!

Eric.

use the alter statement

you can use it with Sps, table, view, udf etc

here some example

http://doc.ddart.net/mssql/sql70/aa-az_5.htm

you can also right click on the object in the object browser

and click on script object to new window as and then

clcik on alter

|||You can't edit in debug mode, as Joey says you need to issue an Alter proc command from the editor