Vista - Disconnecting from SQL server

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.

On Aug 8, 8:38 am, Sandiyan <sandi...@yahoo.co.uk> 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.

Hi Sandiyan,

Your post is too incomplete and vague to understand. Please be more
specific with your request, and post more of your script. The two
lines you wrote demonstrate very little of your problem.

Regards

- Oisin

"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

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