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 |
|
yxcvb
Starting Member
2 Posts |
 Posted - 2009-12-29 : 14:07:11
|
| When I try to create new Alert of type SQL Server Performance condition alert in SSMS under the SQL Server Agent-> Alerts node, I always get this error:Cannot create new alert. (SqlManagerUI)Additional InformationCould not load type 'Microsoft.SqlServer.Management.Smo.Agent.JobBaseCollection' from assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. (SqlManagerUI)And it fails to create new alert.Yes I started SQL Server Agent under the local Administrator account.Any ideas why? Mybe it's a bug? Please help.... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
yxcvb
Starting Member
2 Posts |
Posted - 2009-12-29 : 19:28:32
|
| Yes it's working now. I've upgraded my Developer Edition of SQL Server 2005 to SP3, and now I can normaly define Alert object under the SQL Server Agent. Probably this was a bug in SP1.Many Thanks for help........ |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL Server Agent - Fail to create alert