Disconnecting from engine does not closes database

I connect Managment Studio to MSDE 2000SP4.

Open database, open some object, then disconnect from engine (not simple collapse DB objects). In other programm try to drop database. Until you don't close MSSQL MStudio, database is in use.

In older version collapsing DB objects in tree closes DB.

Hi!

I don't have access to MS from 2000SP4, but I can tell you that MS in SQL2005 have Disconnect command in context menu of the server node. I think this is what you need.

|||Does not matter what engine you use. I wrote, that when I DISCONNECT (using this command from menu - this is one way) from engine, database is in use while MS running. So, MS does not disconnect from DB, only delete engine from list.|||Strange, when you Disconnect from server, it must lost connection and must release locks on any DB that was locked.|||

Please, read my first post and try to reproduce it. After disconnecting, try to drop database you used in SSMS. Open new query in SSMS and try. "Cannot drop..."

It's not strange, IT IS A BUG.

|||I have "Drop connections" checkbox for that case. It works in SQL2000 and I see it in SQL2005.|||

Where did you see this checkbox in SSMS?

May be this checkbox exists (I don't find it, but when I DISCONNECT from server all objects incl DB MUST be CLOSED.

I had no this problem in SQL2000 cause database was auto closed after collapsing it's objects in tree and when it wasn't selected in tree.

|||

I have it in window that appears after "Detach" command. Also I remember there was switch "Auto close" in SQL2000 Enterprise Manager (last tab in DB properties).

Perhabs this is MSDE behavior? I run on SQL Server and don't use MSDE for a long time.

|||

I don't need detach database.

Autoclose is a DB property (must NOT overrides by SSMS) and it's "TRUE". And Autoclose have another purpose - it closes DB after all users disconnects.

I had try with Autoclose = True and AC = false. Result: Cannot drop database.

There is no difference between MSSQL and MSDE for such things.

May be you'll try?

|||Please, describe steps to reproduce, I will try it.

Disable SSIS Studio validations?

Is there any way to disable the validations within the package upon startup of the SSIS studio? We have a few really large packages that can take almost an hour to validate, since the packages could be pointed to different environments (depending on each developer). The alternative (which could get messy) is to alter the *.dtsx file to point the connections to the correct DB before starting them up in studio.

Any ideas?Try setting DelayValidation=TRUE on the package.
-Jamie|||You can use configurations so that the connections point to the correct place on any server (as long as the configuration is valid and that way you don't have to alter the dtsx file directly).

You can switch into offline mode before opening the package.

You can use DelayValidation set to true.

HTH,
Matt

Disable Save Changes prompt

Is there a way in SQL Mgt Studio to disable the "Save changes to the following items?" prompt that comes up every time I close a query window?

No, currently there is no way to disable the prompt to save unsaved changes in the T-SQL script editor.

You can submit suggestions for Management Studio functionality at http://connect.microsoft.com/sqlserver. We use customer feedback like this when we are prioritizing future work.

Thanks,

Steve

Disable Save Changes prompt

Is there a way in SQL Mgt Studio to disable the "Save changes to the following items?" prompt that comes up every time I close a query window?

No, currently there is no way to disable the prompt to save unsaved changes in the T-SQL script editor.

You can submit suggestions for Management Studio functionality at http://connect.microsoft.com/sqlserver. We use customer feedback like this when we are prioritizing future work.

Thanks,

Steve