how to know auto_close off or on

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

how to know auto_close off or on

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-07-22 : 02:29:20

Dear All,
i came to know that if we are using a database very frequently, then the database should be in auto_close off mode.
i'm running the command to set it. working fine. how to know wether it is in on or off?

alter database mydb set auto_close off

Arnav
Even you learn 1%, Learn it with 100% confidence.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-07-22 : 02:34:29

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

KH
[spoiler]Time is always against us[/spoiler]

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-22 : 03:43:27

Autoclose should never be set to ON for production databases.

E 12°55'05.25"
N 56°04'39.16"

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-07-22 : 03:55:04

Dear experts,
select DATABASEPROPERTYEX ('acl','isautoshrink')
result : 0
means autoshrink is off am i correct

Arnav
Even you learn 1%, Learn it with 100% confidence.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-07-22 : 04:03:11

isn't this stated in that link ?

KH
[spoiler]Time is always against us[/spoiler]

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-07-22 : 04:36:10

true ......... false and on .......... off a littlebit confusion.
anyway thank you very much KH

Arnav
Even you learn 1%, Learn it with 100% confidence.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-07-22 : 05:20:28

0 - false. So your database is NOT auto shrink

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources