Solved

Automatically run configuration queries on SQL at start up

Posted on 2007-04-02
2
153 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

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…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

726 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