Showing posts with label deleting. Show all posts
Showing posts with label deleting. Show all posts

Wednesday, March 7, 2012

Close existing connection before deleting/restore database

I want to be able to force a restore or a delete on a database even if there still have some active connections. In SQL Server management studio there is a checkbox when you're trying to delete a database to "Close existing connection" i want to do the same thing but using SMO. How can i do this ?

ThankHi,

see my blog entry here:

http://sqlserver2005.de/SQLServer2005/MyBlog/tabid/56/EntryID/9/Default.aspx

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Friday, February 10, 2012

clearing out the cache (deleting the temp files)

Could some one let me know how i go about clearing out the cache (deleting
the temp files) on the SQL server.
Thx.
Nero.
duplicate post
"Nero" wrote:

> Could some one let me know how i go about clearing out the cache (deleting
> the temp files) on the SQL server.
> Thx.
> Nero.

clearing out the cache (deleting the temp files)

Could some one let me know how i go about clearing out the cache (deleting
the temp files) on the SQL server.
Thx.
Nero.duplicate post
"Nero" wrote:
> Could some one let me know how i go about clearing out the cache (deleting
> the temp files) on the SQL server.
> Thx.
> Nero.

clearing out the cache (deleting the temp files)

Could some one let me know how i go about clearing out the cache (deleting
the temp files) on the SQL server.
Thx.
Nero.duplicate post
"Nero" wrote:

> Could some one let me know how i go about clearing out the cache (deleting
> the temp files) on the SQL server.
> Thx.
> Nero.