Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Nawar.Tabaa
Starting Member
2 Posts |
Posted - 2011-02-02 : 02:18:42
|
I created a performance condition alert that monitors the "CPU Usage %" counter at the Resource Pool Stats object. Once enabled I keep getting the following entry written to the agent error 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]Any ideas? Thanks |
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-02-02 : 05:14:35
|
post the script/query |
 |
|
Nawar.Tabaa
Starting Member
2 Posts |
Posted - 2011-02-02 : 05:36:52
|
EXEC msdb.dbo.sp_add_alert @name=N'CPU Usage', @message_id=0, @severity=0, @enabled=0, @delay_between_responses=0, @include_event_description_in=1, @category_name=N'[Uncategorized]', @performance_condition=N'SQLServer:Resource Pool Stats|CPU usage %|default|>|25', @job_id=N'00000000-0000-0000-0000-000000000000'Thanks, |
 |
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-02-02 : 06:06:09
|
Sorry but not sure if this could be as i think the error is due to an "Inner Select" statement of a "Script" for which you are getting more than one value. |
 |
|
Cristian
Starting Member
1 Post |
Posted - 2012-09-18 : 11:22:28
|
I have the same problem. |
 |
|
|
|
|
|
|