View Single Post
Old 08-08-2007   #4 (permalink)
Oisin Grehan


 
 

Re: Disconnecting from SQL server

On Aug 8, 1:36 pm, urkec <ur...@discussions.microsoft.com> wrote:
> "Sandiyan" wrote:
> > I do the following to connect to a remote SQL server:

>
> > $Server = new-object ("Microsoft.SqlServer.Management.Smo.Server")
> > $RemoteMachine

>
> > Whats the method to disconnect from this server - or can we reset/delete
> > object..?

>
> > thanks,
> > Sandiyan.

>
> SMO will automatically release the connection unless you explicitly use
> ServerConnection.Connect method. See these links for some information:
>
> http://technet.microsoft.com/en-us/l.../ms162216.aspx
>
> http://technet.microsoft.com/en-us/l.../ms162132.aspx
>
> --
> urkec


hah, maybe I should rewrite my post as:

"*my* understanding of SMO is too vague and incomplete to understand
the problem."

;-)

- Oisin

My System SpecsSystem Spec