Viewing 15 posts - 1 through 15 (of 19 total)
Thanks for the help. It is the SQL Server internal row version update conflict resolution process I am referring to. The applications retry when a conflict occurs but I am...
December 30, 2015 at 10:04 am
1) Yes you can install it. Not really. I wouldn't recommend installing a CTP version of SQL Server onto any server I want to keep afterwards as you can't always...
December 26, 2015 at 7:41 pm
I had to install the advisor on a server too but its not ideal and I really hate to have to do that :blush:
November 2, 2011 at 4:56 am
Great question - unfortunately I got it wrong.
I thought it was too simple so I over compensated and assumed that the code would have "set ansi_nulls off" for the session...
October 10, 2011 at 10:30 am
I was expecting the fragmentation to grow on the basis that pages at the end of a database file get moved to empty pages earlier during a shrink.
When i tried...
August 10, 2011 at 4:11 am
I have admin rights (local and domain), UAC is turned down to minimum, I have redownloaded the package multiple times. I dont think I can execute the installer as administrator...
May 27, 2011 at 7:37 am
you cant uninstall a SQL 2005 service pack. To remove an SP you need to uninstall SQL, re-install, restore the database backups and server configurations.
installation guide just posted at
March 17, 2011 at 10:29 am
1. ensure you have 3gb disk space free on the system drive of all nodes
2. ensure you are logged on with local admin privileges
*edit* and the account you are...
March 17, 2011 at 9:57 am
I experienced the "AppDomains being unloaded due to memory pressure" error recently so I will explain how I fixed that so you can see if it works for you. The...
January 21, 2011 at 5:09 am
The xp_cmdshell is calling a command line program called OSQL which is connecting to the default instance on the local computer with the username teste and password teste.
If you...
July 12, 2010 at 10:31 am
Sorry I haven't been very clear. I was trying to leave the question open for other ideas which I guess is leaving it a bit too open. I was meaning...
July 12, 2010 at 9:00 am
hopefully this should do the trick if you are using SQL 2005 or later.
WITH CTE AS (
SELECT custID
, module
...
May 11, 2010 at 4:21 am
I had a support incident with MS in July and the PSS guy said a month or so. Officially MS announced SP3 by the end of this calendar year so...
December 11, 2008 at 4:49 am
I have the same issue with sql logins not working if the account has check_policy enabled. I am using Guids for the sql accounts so they clearly meet password policy...
July 28, 2008 at 1:25 pm
Viewing 15 posts - 1 through 15 (of 19 total)