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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Error

Author  Topic 

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2012-03-12 : 13:17:08
I have created an alert and while selected the propertyi got this error while right click on the alert property..
Please advise to resolve this issue.


TITLE: Microsoft SQL Server Management Studio
------------------------------

Cannot show requested dialog.

------------------------------
ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

------------------------------

Failed to create/initialize Agent Alert dialog. (SqlManagerUI)

------------------------------

Cannot create/initialize Response page. (SqlManagerUI)

------------------------------

An item with the same key has already been added. (mscorlib)

------------------------------
BUTTONS:

OK
------------------------------

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-03-12 : 15:18:43
sounds like there are multiple jobs with same key.
what does below return?

select name from msdb.dbo.sysjobs group by name having count(*) >1




------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2012-03-12 : 17:13:54
Its show 2 count but that dulplicates job relates different reportserver jobs.
Go to Top of Page
   

- Advertisement -