AFternoon , Quick question on a related subject

We are going to migrate our two-node SQL2008 clustered instances from a Windows 2003 environment to a WIndows 2008 environment. Our SQL servers...

Dave

"To my knowledge no vendor provides this, and I doubt any ever will. "

Burroughs/Unisys provided the "printaudit" program to do just that for their DMSII database , and Jade...

Afternoon

Apologies I may have not made my original post clear.

We are currently running on SQl2008 R2 sp1 on Windows 2003 , the upgrade is on the o/s not the...

Thanks Luis

We largely use SQL2008 R2 SE , one Bi instance with SSAS and SSIS, the remainder simple database engine

Thanks

Geoff

..And it was ever thus

I remeber being on a training course back in 1984 learning COBOL being told (by the trainer !) that we were the last generation of programmers...

I have 26 years experience within IT - SQL is now my "third age" having been a COBOL programmer and a mainframe (Burroughs/Unisys) DBA working on their DMSII Database.What...

When I used to work on Burroughs / Unisys mainframes , the proprietary DbMS (DMSII) has the ability to perform an archival rollback , i.e. you roll the database back...

Morning

Another thing to realise , if you are running in a clustered anvironment , that if you remove builtin\Admininstrators you have to ensure that the service account that runs...

This year I will be 48 and have been in I.T. for 25 years - what I have found is you have to re-invent yourself every few years or so...

Thanks for this info - I've just has a similar problem with an install of SP2 CU12 on a single-node cluster , copying back the SQAGTRES.DLL and SQSRVRES.DLL resolved that...

Afternoon Nicholas

have loaded up a screenshot of the cluster group as doc4 below

Thanks

Hi Nicholas

Tried that , no joy

Thanks

Additional info

from the sql server log

2008-12-16 09:33:47.32 Server Microsoft SQL Server 2005 - 9.00.3159.00 (X64)

Mar 23 2007 20:11:35

Copyright (c) 1988-2005 Microsoft Corporation

Enterprise Edition...

Hi Nicholas

Thanks for the info , I deleted the cluster group and re-created it plus the resources specified but that has not resolved the issue .

I look to check...

Afternoon Ian

I am trying to do much the same thing .In your query you have

set @fullQuery = 'select * from openQuery(myLinkedServer, ''' + replace(@query, '''', '''''') +...