• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 848
  • Last Modified:

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.
0
Lazarus
Asked:
Lazarus
  • 3
  • 2
2 Solutions
 
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now