How do I set set the Autoclose property on the RS databases to False

How do I set set the Autoclose property to False in SQL Express?
I have numerous startup events for ULTRASOUND in the Applicatiosn events area and it's just wasted space.
LVL 20
LazarusAsked:
Who is Participating?
 
QPRCommented:
USE [master]
GO
ALTER DATABASE [yourDB] SET AUTO_CLOSE ON/OFF WITH NO_WAIT
GO
0
 
David ToddSenior DBACommented:
Hi,

To expand: The end user and portable versions of SQL do tend to have autoclose. The server versions tend to not have autoclose ...

Regards
  David
0
 
LazarusAuthor Commented:
QPR... Ok, I'm not an SQL type at all. How do I use what you have stated above?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
David ToddSenior DBACommented:
Hi,

Open Query Analyser or Management Studio.

Open a new query and connect to the server (Your PC)

Past QPR's code in from above.

Execute this query.

Regards
  David
0
 
LazarusAuthor Commented:
David, This is SQL Express. The onlythin I see from All Programs is this:

Microsoft SQL Server 2005
     Configuration Tools
         SQL Server Configuration Manager
         SQL Server Error and Usage Reporting
         SQL Server Surface Area Configuration

Is it somewhere in: \Program Files\Microsoft SQL Server    ?
0
 
LazarusAuthor Commented:
I think I have found it. I used "sqlcmd.exe" I'll look in a few minutes and see if that did what I wanted.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.