Complete list of error codes

Does anyone know where to obtain a complete list of error codes which can occur in SQL Server ? For example : errror number 547 is a foreign key violation - where can I get a complete list of these numbers and there descritions ?

I can't find it in BOL or anywhere

In BOL type in 'errors-SQL Server' in the search box in the index tab and they are listed starting with Error 10008 (DB-Library)

you can also take a look here

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_syserrors1a_10mx.asp

Denis the SQL Menace

http://sqlservercode.blogspot.com/

compilation error

While compiling my ADF I am getting the foll. error:

Notification Services could not obtain an identifier needed to construct a Transact-SQL statement

I am trying to create an scheduled subscription with a user-defined rule. I followed the instructions on Shyam Pather's book on SQLNS and was able to create the event-trigerred subscription with user-defined logic. But when I tries to extend this to a scheduled subscription I got this error.

I have searched the net for this but could find no other info on this error?

Any idea what this could mean?

Thanks

DK

Detailed Error:

===================================

An attempt to run a Transact-SQL CREATE PROCEDURE statement failed.
Instance Name: ContentMonitorAlerts
Application Name: ContentAlerts
Stored Procedure Name: NSFireDeveloperDefined%RuleId%
SQL Command Text:

DECLARE @.ruleId INT

SELECT @.ruleId=RuleId
FROM [ContentMonitorAlerts].[ContentAlerts].[NSRules]
WHERE RuleName=N'MatchNewContentsForSubscription'
IF @.ruleId IS NULL
BEGIN
RAISERROR (N'9714: Notification Services could not obtain an identifier needed to construct a Transact-SQL statement.', 16, 1)
RETURN
END

DECLARE @.commandText NVARCHAR(MAX)
SET @.commandText = N'
CREATE PROCEDURE [ContentAlerts].[NSFireDeveloperDefined' + CAST(@.ruleId AS NVARCHAR(MAX)) + N']
AS
BEGIN

I noticed that the error says there was an error while running NSFireDeveloperDefined%RuleId%

I am not sure why NS is trying to run that SP - since I am creating a user-defined rule and not a developer defined rule.

Any light on this issue would be greatly appreciated.

Thanks
DK

|||

I solved it by making some changes to the ADF file.

Thanks

|||What changes you have done to resolve your problem ?

compilation error

While compiling my ADF I am getting the foll. error:

Notification Services could not obtain an identifier needed to construct a Transact-SQL statement

I am trying to create an scheduled subscription with a user-defined rule. I followed the instructions on Shyam Pather's book on SQLNS and was able to create the event-trigerred subscription with user-defined logic. But when I tries to extend this to a scheduled subscription I got this error.

I have searched the net for this but could find no other info on this error?

Any idea what this could mean?

Thanks

DK

Detailed Error:

===================================

An attempt to run a Transact-SQL CREATE PROCEDURE statement failed.
Instance Name: ContentMonitorAlerts
Application Name: ContentAlerts
Stored Procedure Name: NSFireDeveloperDefined%RuleId%
SQL Command Text:

DECLARE @.ruleId INT

SELECT @.ruleId=RuleId
FROM [ContentMonitorAlerts].[ContentAlerts].[NSRules]
WHERE RuleName=N'MatchNewContentsForSubscription'
IF @.ruleId IS NULL
BEGIN
RAISERROR (N'9714: Notification Services could not obtain an identifier needed to construct a Transact-SQL statement.', 16, 1)
RETURN
END

DECLARE @.commandText NVARCHAR(MAX)
SET @.commandText = N'
CREATE PROCEDURE [ContentAlerts].[NSFireDeveloperDefined' + CAST(@.ruleId AS NVARCHAR(MAX)) + N']
AS
BEGIN

I noticed that the error says there was an error while running NSFireDeveloperDefined%RuleId%

I am not sure why NS is trying to run that SP - since I am creating a user-defined rule and not a developer defined rule.

Any light on this issue would be greatly appreciated.

Thanks
DK

|||

I solved it by making some changes to the ADF file.

Thanks

|||What changes you have done to resolve your problem ?