On Fri, 29 Jun 2007 02:57:44 -0700, Maria wrote:

> Hi folks,
>
> I created a new Notifiction 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, 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

On 29 Jun, 14:13, Joe Webb <j...@webbtechsolutions.com> wrote:
> Hi Maria -
>
> In SQL Server 2005, SSNS instances are tracked in the msdb database. Try
> deleting the instance row in msdb.NS90.NSInstanceInfo and the application
> row in msdb.NS90.NSApplicationInfo tables. Afterward you should be able to
> create your instance again.
>
> There's a bit more information about this on my blog.
>
> http://sqlns.blogspot.com/2007/04/finding-ssns-instances-using-t-sql....
>
> HTH...
>
> Joe
>
> --
> Joe Webb
> SQL Server MVPhttp://www.sqlns.com