Archive for March 5, 2013

PowerShell for Droping Database

March 5, 2013 8 comments

This article will help you to understand how we can drop existing SQL Server Database with the help of SMO and PowerShell V3.0. If you do not have you sample data base created then follow the steps to create your database with PowerShell V3.0. Read more…

PowerShell for Altering Database Properties

March 5, 2013 29 comments

This article will help to understand how to alter databases properties using PowerShell V3.0 and SMO. In previous article we seen PowerShell for Creating a Database. Basically we can alter database options from Automatic, Containment, Cursor, File Stream, Miscellaneous, Recovery, Service Broker and State Categories. Read more…

%d bloggers like this: