SqlDbx
You are not logged in.
Pages: 1
1) Open SQLDbx. Go to DatabseA.
2) Open script window. Enter the following:
Use DatabaseB
GO
3) Run this script.
The database is changed to DatabaseB, however the dropdown still shows DatabaseA, and the object tree still shows DatabseA objects. I have to re-select 'DatabaseA' in the database dropdown to switch back.
I thought that this would execute as a batch, thereby leaving me at DatabaseA after the execution.
Allen
Offline
Database in dropdown is independent from whatever database you switch in Editor.
Also I am not sure what you mean "would execute as a batch leaving at DatabaseA"
SQL batch does not restore previous database.
Offline
Database in dropdown is independent from whatever database you switch in Editor.
Yes it is, but precisely this behavior is unexpected and IMO wrong.
As user, i expect that an 'USE' command changes the database in dropdown,
in effect synchronizing both states (dropdown and real database selected).
Otherwise, any command that don't have the database path executed must fail,
because the 'USE' command changes the current context.
In the past i reported this same situation and this is still not corrected.
Last edited by maac2002 (2012-06-12 13:02:34)
Offline
Pages: 1