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.
I have numerous startup events for ULTRASOUND in the Applicatiosn events area and it's just wasted space.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
QPR... Ok, I'm not an SQL type at all. How do I use what you have stated above?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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 ?
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 ?
ASKER
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.
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