Anyone faced such issue ?

will reinstalling SP3 resolves this and fix by replacing the corrupted files, any ideas ?

Any help is appreciated.

Yeah, that was stopped from one year. From then its in stopped state.

we have 3000+ instances now. So, it was under covered these many days. This server was pushed into...

Hello Sunil,

Thanks for your link... I have gone through the link before. But couldnt understand the below steps.

Iam confused of working on this issue from past.

replace the SQLAgent.dll and SQLAgent.rll...

Thanks all for your response.

Finally I got access on the folder to read the log file...

Please find the detailed log info of SQLAgent, please suggest me on this....

Would it...

Verified SQL Agent service account, reset password manually, updated on windows and SQL level, checked for permissions on folders and registry folders as well... Everything looks good.

Even rebooted the box...

any help and ideas please :

Event Type:Information

Event Source:Application Popup

Event Category:None

Event ID:26

Date:10/22/2011

Time:11:31:36 PM

User:N/A

Computer:AMRVMRDR

Description:

Application popup: SQLAGENT90.EXE - Application Error : The application failed to initialize properly (0xc0000005). Click on OK to terminate...

New Error:

Service Request Timeout (ObjectExplorer)

------------------------------

Program Location:

at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.CheckServiceActionReturnValueSuccess(UInt32 returnValue)

at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Start()

Hope below links suffice

http://msdn.microsoft.com/en-us/library/ms345146(v=sql.90).aspx

http://www.sqlservercentral.com/Forums/Topic414210-338-1.aspx

- Win.

Could anyone help me on this ??

Please stop your Hyderbad experience, posting here..

Hello Gianluca,

Greetings...!!

It worked for me, thanks much.

One request to add to this : I forgot to verify users on DB. I checked for users who have created an object in...

Granting EXECUTE permission on a stored procedure:

The following example grants EXECUTE permission on stored procedure

HumanResources.uspUpdateEmployeeHireInfo to an application role called Recruiting11.

[font="Courier New"]

USE AdventureWorks2008R2

GRANT EXECUTE ON OBJECT::HumanResources.uspUpdateEmployeeHireInfo

...

Hi,

I am testing the sql on 2000, it failed, since XML doesnt support on 2000. Iam good here.. I would like to have the script for SQL 2000 / 2005...

Gianluca,

Thanks much and appreciate for your code. I will try to work with this on DEV environment and get back to you.

Sorry for the delayed response. was not in office.

-...

SSIS Package and automation.

Please have a look into this : http://sqlschoolhouse.wordpress.com/2010/08/11/executing-ssis-package-as-scheduled-sql-server-job/