Viewing 13 posts - 1 through 13 (of 13 total)
I see no reason you would have an issue in a newer SQL instance running in a Compatibility mode equal to your current version.
The only issue is configuring...
August 28, 2017 at 3:50 pm
Has anyone ever tried running BizTalk with the DBs in a lower compatibility mode?
We are currently...
August 28, 2017 at 3:48 pm
October 28, 2014 at 10:06 am
It would have to be mixed in my estimation to allow the OS Administrator role member to start SQL server and add a SQL user, right. If ONLY SQL...
October 23, 2014 at 3:21 pm
One would need the SA password I'm thinking.
Also, the SQLAgent user might be an interesting problem?
I like the article, and have done similar 'hacks' such as booting from a CD-ROM...
October 23, 2014 at 11:32 am
This link worked. You'll need to change the folder's name to the server you want, and then the
server's name below, for EACH SSIS server you want, but it's...
April 11, 2014 at 2:14 pm
So far every comment above I find no fault in our experience and would highlight that we do NOT allow Commvault to perform anything but file backups and rely solely...
May 2, 2013 at 5:38 pm
there must be a way to 'kill' a restoring database and just drop it and then its associated files, where one can create the db again and restore from a...
October 25, 2010 at 1:18 pm
ok, perhaps I'll have to dig deeper to understand how to set up a typical user to get a simple sp_helptext
nice to have a simple check box system setup
March 5, 2009 at 3:12 pm
we are getting the same results, but when I exec it as dbo I CAN see the results.
The problem exists for a user we created with datareader, and MSDynamicsSL. ...
March 2, 2009 at 3:42 pm
great response, except, what if the indexes exist? The article is valid as you say, for finding deadlocks in general and therefore has worth.
February 3, 2009 at 2:17 pm
totally agree: how hard would an interface using the simple steps outlined in the article be to generate a quick pull of that page.
Would help in profiling and devo evoluton...
February 3, 2009 at 2:14 pm
we have the same problem here, [FYI: We are ALWAYS up on the latest patches and fixes, of which the above, did NOT solve...SO: ] with a dozen or...
October 28, 2008 at 11:08 am