June 29, 2007 at 4:21 am
Hi folks,
A bit of an oddity here.
I created a new Notification Service, and stopped it halfway through creation as I realised I hadn't saved an ADF file. Now the NS databases appear to have been partially created, and I can't delete the instance because it doesn't appear in the list in Server Explorer. I tried to delete it with nscontrol, but it claims the instance does not exist. However if I try to create a new instance (with the same name), it fails because the instance already exists! If I choose List Versions from the Notification Services right-click menu, my instance is in there.
Any clues? I've only been developing NS for a couple of days, am I missing something obvious? I'm more curious than anything really, it's easy enough for me to change the instance name!
Thanks
Maria
June 29, 2007 at 8:01 am
This guy's blog had the answer:
http://sqlns.blogspot.com/2007/04/finding-ssns-instances-using-t-sql.html
NS Instances are stored in msdb, deleting the record for my rogue instance did the trick:
SELECT * FROM msdb.NS90.NSInstanceInfo
Hopefully this might help un-confuse someone else, further down the line!
Maria
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply