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 |
|
cat_jesus
Aged Yak Warrior
547 Posts |
 Posted - 2008-07-28 : 15:05:00
|
| When I try to change the failsafe operator in SSMS nothing happens. This is to say that I make the change in the dialog box under SQLAgent/properties/Alert System and press OK I get no error but when I go back to check, I see that the value is the same as it was before.Does anyone know how to change this?An infinite universe is the ultimate cartesian product. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-28 : 22:51:42
|
| You mean assign another operator there? Do you have sysadmin rights? |
 |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-07-29 : 08:13:25
|
| I do have sysadmin rights. Yes, I mean assign another operator as the failsafe operator.Edit: Build # 9.0.3042An infinite universe is the ultimate cartesian product. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-29 : 23:02:52
|
| Is ssms in build 3042 too? |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-07-30 : 09:46:42
|
| Is this one of the settings that requires a server restart?e4 d5 xd5 Nf6 |
|
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-07-30 : 10:11:11
|
| Microsoft SQL Server Management Studio 9.00.1399.00An infinite universe is the ultimate cartesian product. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-30 : 23:00:50
|
| >> Is this one of the settings that requires a server restart?No, not necessary.>> Microsoft SQL Server Management Studio 9.00.1399.00Apply sp2 on client tools then try again. |
|
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-08-04 : 14:56:54
|
| That did it, rmiao. Thanks.An infinite universe is the ultimate cartesian product. |
|
|
|
|
|
|
Change Failsafe operator