Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Automatically run configuration queries on SQL at start up

Posted on 2007-04-02
2
Medium Priority
?
155 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 2000 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

636 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