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...

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...

I had to install the advisor on a server too but its not ideal and I really hate to have to do that :blush:

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...

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...

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...

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

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...

Like christian I am wondering why the page is full. Can someone explain why a page with 3 x 1000 bytes rows, 1 x deleted 1000 byte row (now a...

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...

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...

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...

hopefully this should do the trick if you are using SQL 2005 or later.

WITH CTE AS (

SELECT custID

, module

...

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...

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...