Home Forums Programming Powershell SQL Server Detach database RE: SQL Server Detach database

  • April 22, 2014 at 9:59 am

    #1707828

    Thanks

    Tried that, but got the below error:

    PS SQLSERVER:\> $server.DetachDatabase("dbPSXTest", FALSE)

    At line:1 char:36

    + $server.DetachDatabase("dbPSXTest", FALSE)

    + ~

    Missing expression after ','.

    At line:1 char:37

    + $server.DetachDatabase("dbPSXTest", FALSE)

    + ~~~~~

    Unexpected token 'FALSE' in expression or statement.

    At line:1 char:42

    + $server.DetachDatabase("dbPSXTest", FALSE)

    + ~

    Unexpected token ')' in expression or statement.

    + CategoryInfo : ParserError: (:) [], ParentContainsErrorRecordException

    + FullyQualifiedErrorId : MissingExpressionAfterToken

    TDP