Viewing 15 posts - 1,516 through 1,530 (of 7,168 total)
I think you are either being killed by a database "sweeper" process (see Gail's response) in which case you can see that in the SQL Error Log (look for "kill"...
March 20, 2013 at 2:18 pm
Ditto if it was not setup for any kind of HA or DR. Was it replicated, log shipped or mirrored to another instance by any chance?
March 20, 2013 at 1:56 pm
Happy to assist. As it played out the configuration file ended up living in the same location in every server in that shop as well but your comment about flexibility...
March 20, 2013 at 1:27 pm
kevaburg (3/20/2013)
opc.three (3/14/2013)
March 20, 2013 at 1:04 pm
kevaburg (3/20/2013)
You would love my environment then! I have 30 instances on a single box!
Love might not be the correct sentiment 😀
For the two instance argument it means I...
March 20, 2013 at 12:34 pm
If you go with a Trace flag you only need to enable one or the other. If I use them I'll pick 1222 because it offers a cleaner output. The...
March 20, 2013 at 12:00 pm
If you have to do flat-file to flat-file then using a Script Task might be the only option and the article linked to above is how I would do it....
March 20, 2013 at 11:30 am
A blend worked well for me at one shop where an environment variable pointed to an XML configuration file, and that XML configuration file contained a connection string for a...
March 20, 2013 at 11:23 am
In the spirit of full disclosure, you could run databases in 80 compatibility mode on SQL 2008/R2 and still utilize the *= / =* syntax but support for 80 compatibility...
March 20, 2013 at 11:18 am
It's the Database!!! (3/20/2013)
opc.three (3/20/2013)
It's the Database!!! (3/20/2013)
March 20, 2013 at 10:35 am
kevaburg (3/20/2013)
And that is my argument for at least two instances on each database server.....one with and one without! 🙂
Yikes! You must print money over there...can you send me...
March 20, 2013 at 10:25 am
Good deal, happy you got it sorted. Thanks for posting back.
March 20, 2013 at 10:19 am
It's the Database!!! (3/20/2013)
Chicken bucket go BOOM! That worked, I am writing all information about (in requested script) all my databases to the table now! Thank you O!
That commerical should...
March 20, 2013 at 10:17 am
That's fair, and you're right to challenge that point in an attempt to keep instances out of mixed-mode, I do the same. The reality is that it just takes one...
March 20, 2013 at 8:07 am
kevaburg (3/20/2013)
March 20, 2013 at 7:41 am
Viewing 15 posts - 1,516 through 1,530 (of 7,168 total)