On Fri, 04 May 2007 06:00:28 -0700, Mwob wrote:

> Hi all,
>
> We install the SSNS database tables into our application database,
> rather than have a separate database. A client has sent us a backup of
> their database which contains their ssns tables, and i need to drop
> the ssns tables and schema from this database. I thought that this
> would do the trick...
>
> nscontrol delete -name MYDATABASE -server MYSQLSERVER -force
>
> But it doesn't. Can anyone help?
>
> Matt.

On 8 May, 12:27, Joe Webb <j...@webbtechsolutions.com> wrote:
> On Fri, 04 May 2007 06:00:28 -0700, Mwob wrote:
> > Hi all,
>
> > We install the SSNS database tables into our application database,
> > rather than have a separate database. A client has sent us a backup of
> > their database which contains their ssns tables, and i need to drop
> > the ssns tables and schema from this database. I thought that this
> > would do the trick...
>
> > nscontrol delete -name MYDATABASE -server MYSQLSERVER -force
>
> > But it doesn't. Can anyone help?
>
> > Matt.
>
> Do you have an instance with that name on that server? The msdb database
> contains an entry for each SSNS instance. Here's a link that describes how.
>
> http://sqlns.blogspot.com/2007/04/finding-ssns-instances-using-t-sql....
>
> HTH...
>
> --
> Joe Webb
> SQL Server MVPhttp://www.sqlns.com

On 8 May, 12:57, Mwob <mattwobe...@gmail.com> wrote:
> Joe,
>
> I'm not sure what you mean. We don't have SSNS setup for that database
> on our server, what we want to do is completely remove all the SSNS
> tables, views, schemas etc from the database backup once we have
> restored it.
>
> Thanks
>
> Matt
>
> On 8 May, 12:27, Joe Webb <j...@webbtechsolutions.com> wrote:
>
> > On Fri, 04 May 2007 06:00:28 -0700, Mwob wrote:
> > > Hi all,
>
> > > We install the SSNS database tables into our application database,
> > > rather than have a separate database. A client has sent us a backup of
> > > their database which contains their ssns tables, and i need to drop
> > > the ssns tables and schema from this database. I thought that this
> > > would do the trick...
>
> > > nscontrol delete -name MYDATABASE -server MYSQLSERVER -force
>
> > > But it doesn't. Can anyone help?
>
> > > Matt.
>
> > Do you have an instance with that name on that server? The msdb database
> > contains an entry for each SSNS instance. Here's a link that describes how.
>
> >http://sqlns.blogspot.com/2007/04/finding-ssns-instances-using-t-sql....
>
> > HTH...
>
> > --
> > Joe Webb
> > SQL Server MVPhttp://www.sqlns.com