Solved

Automatically run configuration queries on SQL at start up

Posted on 2007-04-02
2
146 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

707 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now