Hi ALZDBA

Believe me, I got burnt my fingers burnt few times with that message 🙂 so I know how SQL Server cluster should work. As I wrote, I discovered lack...

Hi Steve,

Yes, I did it. It was one of my first actions becasue queried column was indexed. But I got zero errors.

Cheers,

Bartek

I have been spending too much time with SS2000, Chirag advice is definitely faster.

In my solution you can use in SS2005 sys.objects table.

Hi San,

Try to build script with sp_helptext 'procedure_name'. It resolves procedure's body to rowset.

You can use cursor which will go through all procedures (which are in sysobjects table) and...

Problem resolved.

I did some workaround:

- scripted existing table which caused error

- created new one with the same objects (indexes, constraints..)

- copied data to the new one

- changed table names

I still...

For those who has encountered similar problem:

Finally I did not find solution (lack of time, other priorities) and do what I should have done days earlier. I removed SQL Server...

I forgot to put cluster error message from sqlsp.log to my post, it was enclosed in the post description:

15:57:39 "C:\Temp\1\SqlSetup\Bin\remsetup.exe" C:\WINDOWS\remsetup.ini

16:03:19 Process Exit Code: (2) The system cannot find...

Hi Swirl,

Yes, all databases have both options turned on. Do you imply that auto statistics update could have place?

Maybe, I don't know, I will have to make deeper analysis, if...

Thanks for reply Steve.

Most heavy queries finished in the half time of that peak, this had been my first thought when I was checking but CPU utilization was much...

Definietly I have to run this tool which you've suggested.

Thanks for help.

Bartek

Thank you for all your posts.

Of course, I had done CHECKDB against master database and no error messages.

I also checked system log, none of those messages appeared.

Thank you Jack for reply.

As I wrote, my RS secutity is based on local server groups. On RS Windows server in Domain1 I had created RSUSER group where users from...

Hi,

Maybe it could helps http://support.microsoft.com/?scid=kb%3Ben-us%3B290991&x=13&y=13

This is MS how to manually uninstal from Windows 2k3, 2k, xp.

Regards,

Bartek

Yes, I did DBCC CHECKDB, and succeeded without errors.

I am not questioning what SQL ORACLE wrote but at my playground it works. I cannot see that process in activty monitor, sp_who etc. and I did whatever I want...