Groups | Blog | Home
all groups > sql server replication > may 2006 >

sql server replication : Error 14150 in SQL Server Logs


Wilma
5/30/2006 2:17:02 AM
Hi,

In my SQL Server Log the following message occurs:
"Error: 14150, Severity: 10, State: 1"
This occurs every time the distribution agents runs and there are no
replicated transactions available.
I know it's an informational error, but it annoys me. The strange thing
about it is that the error only occurs in our test environment and not in our
production environment, while they have the same installation and settings of
SQL Server.
I do not have the "Replication: agent success" alert enabled.

Some technical information:
SQL Server standard edition
version: 8.00.2039(SP4)
Transactional replication
Publisher, Subscriber and Distributor are on one machine.

--
thanks,

Wilma
Wilma
6/8/2006 4:52:02 AM
I solved it myself.
For anyone who is interested:

Go to the tools menu in the Enterprise Manager, choose "Manage SQL Server
Messages". Give the error number (14150) in the Error number box and hit
"Find".
Now you'll see the error message with a column "logged", if this column is
checked the error message will be logged in the SQL Server logs. Choose
"Edit" to modify the message properties.
--
Wilma
DBA


[quoted text, click to view]
AddThis Social Bookmark Button