Question: try { < # Create Database # > Write - Host - ForegroundColor Cyan [ SQL ] : Starting SQL Tasks # Import SqlServer
try
# Create Database #
WriteHost ForegroundColor Cyan SQL: Starting SQL Tasks"
# Import SqlServer Module
ifGetModule Name sqlpsRemoveModule sqlps
ImportModule Name SqlServer
# D: Check for the existence of the database
$serverName SRVPRIMARYSQLEXPRESS
$databaseName "MyDatabaseNetObjects"
# Create connection to server
$connectionString "Data Source$$serverName; Initial Catalogmaster;Integrated SecurityTrue;"
$sqlConnection NewObject System.Data.SqlClient.SqlConnection
$sqlConnection.ConnectionString $connectionString
$sqlConnection.Open
# Create query to detect if database exists
$detectQuery "Select name FROM sysdatabases WHERE name $$databaseName
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
