Hi Paul,

I ran sp_configure but received the following,

locks5000214748364700

which is not of any help in co-relating the alert to the parameter based on the numbers mentioned in the error,

I have searched...

I have downloaded Windows SharePoint Services 2.0 Service Pack (SP2) to my SQL Server 2005 SP2.

http://www.microsoft.com/downloads/details.aspx?familyid=9C552114-DC9A-43EE-9281-B080B7C280B4&displaylang=en

Is it ok to apply it?

Thanks,

Philip

I have around 60 scheduled jobs out of which most of them of type 'TSQL'. I was able to find the text one by one by selecting the name in...

Yes. That's what I'm looking for.

Thanks,

Philip

Just to clarify once again, as SP3 include the SP2 CU# upto 10,

if in case I get any error after the SP3 install (which has a solution...

Just to clarify once again, as SP3 include the SP2 CU# upto 10,

if in case I get any error after the SP3 install (which has a solution...

Hi All,

In this case which cumulative update I should try next? Will it be ok, if I skip all the CU's and go ahead with SP3?

Thanks,

Philip.

Thanks for all those who tried to help me out.

I guess we are going away from the topic. I have SQL Server Management Studio on all of the servers and...

There was a confusion regarding SSMS (I didn't know that it is a reg reading tool) as I thought it is nothing but the Sql Server Management Studio...

I think we are talking about the same thing. When I connect to the DB using Mangement Studio, I get ServerName (SQL Server 9.0.3077 - Domain\username) and I write click...

I have a number of DB's on the server and I thought the AuditLevel is for the entire DB Server as there isn't any Security Tab if you look at...

I have initially checked it via SSMS and it is having the Login Auditing option as 'Failed Logins Only'. Then I have checked the Reg key AuditLogin and saw it...

My question here is why I'm getting different details,

In the control pannel-->Add Remove Programs with updates,

GDR 3077 for SQL Server Database SErvices 2005 ENU (KB960089) installed on 28/02/2009. The same...

Hi Venu,

Tips: Please make sure to provide as much information (db, versions etc) as possible regarding your environment to get a prompt reply from the group.

Thanks,

Philip.

Dear All,

Thanks SA.

When I ran the following SQL on my DB server,

select SERVERPROPERTY('productversion'), SERVERPROPERTY('productlevel'), SERVERPROPERTY('edition')

Result is,

9.00.3077.00SP2Standard Edition

Then ran select @@version the result is,

Microsoft SQL Server 2005 - 9.00.3077.00 (Intel X86)...