Tags: 818windows, access, adv, build, create, database, ent, environmentsql, guru, microsoft, mysql, oracle, reporting, server, services, sp3a, sp4running, sql, violation, xp_sqlagent_notify

xp_sqlagent_notify Access Violation

On Database » Microsoft SQL Server

749 words with 0 Comments; publish: Mon, 19 May 2008 17:36:00 GMT; (25046.88, « »)

Hello Guru's,

Environment:

SQL Server 2000 ENT SP3a build 818

Windows 2000 ADV SP4

Running reporting services 2000, trying to create a new subscription

receiving execute permissions on MASTER..xp_sqlagent_notify extended

procedure. This called caused an ACCESS VIOLATION and brought down SQL

Server. Verified the RS logon account does indeed have execute permissions.

Traced the call, copied and paste in my test environment. (statement is

below), and it also brought down my test instance. Has anyone encountered

this issue and have a resolution?

exec master.dbo.xp_sqlagent_notify .sqlserver.todaysummary.com.op_type = N'G', .sqlserver.todaysummary.com.job_id = default,

.sqlserver.todaysummary.com.schedule_id = default, .sqlserver.todaysummary.com.alert_id = default, .sqlserver.todaysummary.com.action_type = default

All Comments

Leave a comment...

  • 0 Comments