Re: SQL Server too slow
From: Erland Sommarskog (sommar_at_algonet.se)
Date: 12/27/03
- Next message: Eliyahu Goldin: "Generating hash value"
- Previous message: Kalen Delaney: "Re: SQL Server too slow"
- In reply to: Murtix Van Basten: "Re: SQL Server too slow"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sat, 27 Dec 2003 10:14:07 +0000 (UTC)
Murtix Van Basten (nospam@nospam.org) writes:
> How do I find out a database set to autoclose ?
For a single database you can do:
exec sp_dboption db, 'autoclose'
To check all databases use:
exec sp_helpdb
But since the autoclose information is hidden in the middle, this may
be simpler:
select name from master..sysdatabases
where databasepropertyex(name, 'IsAutoClose') = 1
You can also view it in Enterprise Manager, but it is left as an exercise
to the reader to find out how.
-- Erland Sommarskog, SQL Server MVP, sommar@algonet.se Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
- Next message: Eliyahu Goldin: "Generating hash value"
- Previous message: Kalen Delaney: "Re: SQL Server too slow"
- In reply to: Murtix Van Basten: "Re: SQL Server too slow"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
