Solved

Automatically run configuration queries on SQL at start up

Posted on 2007-04-02
2
149 Views
Last Modified: 2010-03-19
I'm using SS 2005 Express.  In my ASP.NET development project, on my development machine, I changed the web.config connectionstrings to "UserInstances = True" ...because (pardon the confusion...too many technologies...) I think that's the way it needs to be to run on the Hosted VPS Win 2003 Server that I'm using.

So, sometime after that, out of the blue, I started getting this when I fire up the development instance of the app:

"Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances."

I've built two queries to do this, and it only takes a minute through SSMSEE, but it's a little disconcerting, and I'm not sure why I have to repeat it every day.

Is there some way to get configuration queries such as these to run at SQL start up (machine power up)?  Or get these settings to "take" more permanently?

Any help with this would be appreciated.

Thanks!
0
Comment
Question by:codequest
2 Comments
 
LVL 28

Accepted Solution

by:
imran_fast earned 500 total points
ID: 18841947
you can create a batch file using isql and make windows schedule to do this.
0
 
LVL 2

Author Comment

by:codequest
ID: 18861387
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

806 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