Viewing 15 posts - 1,516 through 1,530 (of 7,164 total)
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?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 20, 2013 at 1:27 pm
kevaburg (3/20/2013)
opc.three (3/14/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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....
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 20, 2013 at 10:25 am
Good deal, happy you got it sorted. Thanks for posting back.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 20, 2013 at 8:07 am
kevaburg (3/20/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 20, 2013 at 7:41 am
All is well now. Thanks for the quick rollout 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 20, 2013 at 12:05 am
Viewing 15 posts - 1,516 through 1,530 (of 7,164 total)