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 |
|
akak1997
Starting Member
2 Posts |
 Posted - 2007-08-20 : 19:56:25
|
| Hi all, I'm running in to the exact same problem described in this post:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67406[/url]However there were no replies to that post and the forum is closed. Has anyone figured out what the problem was and if there is a solution for it?Please help and thank you for your time.H |
|
|
akak1997
Starting Member
2 Posts |
Posted - 2007-08-23 : 15:25:45
|
| I guess there isn't a way to get NS to work by detach a SQL2000 NS database and attach it to SQL2005 and run nscontrol repair.So I basically recreated the database in SQL2005 and exported data from SQL2000's database, and that works for me. All the notifications subscriptions got transferred and adding new subscription works without changing code (do have to update the reference for NS to the 9.x version) |
 |
|
|
|
|
|
Upgrading Notification Services from SQL2k-> 2k5