Automatically run configuration queries on SQL at start up
Posted on 2007-04-02
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.