I am sure that this can be achieved by loading the SQL Server Management Objects assemblies but I am curious as to whether the 'Start Powershell' item in the context menu within SQL Server Management Studio 2008 will give me a headstart.
+1
A:
The SMO Server class has a DetachDatabase method that you can use from Start PowerShell. From the server level in sqlps you can use something like this:
PS SQLSERVER:\SQL\Z002>get-childitem | foreach{$_.DetachDatabase("pubs",$false)}
Chad Miller
2009-12-29 18:02:45
Your answer tells me that the SQL Server is implemented as a PSDrive which pretty much answers my question. I would however be interested in understanding why you needed a 'foreach' here.
Scott Munro
2010-01-04 13:39:08
Get-childitem when run at the machine level will return all the SQL instances on the server. If you have multiple instances foreach would be neeed. Probably doesn't make sense in this case though. But I have multiple on the machine I ran command on. If just one instance you could either assign the Server object to a variable or do something like this:(get-childitem ).DetachDatabase("pubs",$false)OR assign server object to variable$server = get-childitem$server.DetachDatabase("pubs",$false)
Chad Miller
2010-01-05 00:40:04
Thanks chadwickmiller +1!
Scott Munro
2010-01-05 08:47:18