question

Adrian 2 avatar image
Adrian 2 asked

Repeated SQLServer Error: 512 in event log with no queries or jobs running

Hi to all,

I have a SQL 2008 server that shows the below error messages in the SQL Server Agent log.

Message
[298] SQLServer Error: 512, Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. [SQLSTATE 21000]

I have no jobs running and no queries being executed but the error are just go on and on. I have restarted the server and and agent but still the same problem.

Can someone please help me fixing this problem?

Thanks

sql-server-2008sql-agenterror-message
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image
David Wimbush answered

If this error is being logged it must be coming from a query that's being executed. Use the SQL Profiler to see what activity is going on.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Adrian 2 avatar image Adrian 2 commented ·
It looks like I found the problem. I had alert setup to notify me of hight CPU usage and send me a mail. This I could never get to work but it stayed enabled. I deleted the alret and the events stoped. Thanks
0 Likes 0 ·
nishitan avatar image
nishitan answered
It looks like I found the problem. I had alert setup to notify me of hight CPU usage and send me a mail. This I could never get to work but it stayed enabled. I deleted the alret and the events stoped. Thanks Adrian thanks for the answer ...it really worked for me,,,, thank u soo muched
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.