Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2006-11-01
6
Medium Priority
?
844 Views
Last Modified: 2011-10-03
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
Comment
Question by:Lazarus
  • 3
  • 2
6 Comments
 
LVL 29

Accepted Solution

by:
QPR earned 450 total points
ID: 17855179
USE [master]
GO
ALTER DATABASE [yourDB] SET AUTO_CLOSE ON/OFF WITH NO_WAIT
GO
0
 
LVL 35

Expert Comment

by:David Todd
ID: 17855213
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
 
LVL 20

Author Comment

by:Lazarus
ID: 17859216
QPR... Ok, I'm not an SQL type at all. How do I use what you have stated above?
0
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
LVL 35

Assisted Solution

by:David Todd
David Todd earned 300 total points
ID: 17861037
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
 
LVL 20

Author Comment

by:Lazarus
ID: 17862714
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
 
LVL 20

Author Comment

by:Lazarus
ID: 17862778
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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question