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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-01-21 : 08:10:07
|
| john writes "I am upgrading to SQL 2000 from SQL 7.0. I was able to create a script to export my user-defined alerts, but when I run the script on the 2000 server I get the following error message: The specified @message_id ('.....') does not exist. the proc raising the error is sp_verify_alert. Is this the right approach for importing the alerts ???" |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-01-21 : 10:47:13
|
| Have you got user defined messages on the SQL7 server that the alerts refer to? If so, you'll need to add them with the same message number to your SQL 2000 server.Raymond |
 |
|
|
|
|
|
Exporting/Importing UserDefined Alerts