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?

Improve company productivity with a Business Account.Sign Up

x
 
QPRConnect With a Mentor Commented:
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
David ToddConnect With a Mentor Senior 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.