Well I did get the correct answer, and when I try it on a SQL 2005 server where the SQL excecutables are installed on O: and the databases are on...

I do disagree with this answer,

If I run

DECLARE @STR NVARCHAR(10)

SET @STR = '1, 2, 3, '

SET @STR = LEFT(@str, LEN(@str)- 2)

select len(@str)

SELECT

I have run this against SQL 2008 Enterprise x64 and it works the same as SQL 2005 Enterprise x64.

We implement HA in various ways here. We have some clusters of SQL 2005 on Windows 2003 which means we cannot geographically separate the servers. We use Log...

Great article and I can already see many uses. One thing I did find is that the tSQL scripts to install the jobs assumes that the SA account has...