
$CONNECTION_STRING_IP = "Data Source={0},1433;Network Library=DBMSSOCN;Initial Catalog=master; Integrated Security=SSPI;"
$CONNECTION_STRING_IP_db = "Data Source={0},1433;Network Library=DBMSSOCN;Initial Catalog={1}; Integrated Security=SSPI;"
$TRUSTED_CONNECTION_STRING = "Server = {0}; Database = {1}; Integrated Security=SSPI;"
$TRUSTED_CONNECTION_STRING_master = "Server = {0}; Database = master; Integrated Security=SSPI;"

$CREATE_SQL_USER_Windows = "CREATE LOGIN [{0}] FROM WINDOWS;"
$CREATE_SQL_USER =  "CREATE LOGIN {0} WITH PASSWORD = '{1}';"
$ADD_SQLUSER = "CREATE USER [{0}] FOR LOGIN [{0}]; "
$REMOVE_USER_FROM_DB = "DROP USER [{0}];"
$REMOVE_LOGIN= "DROP LOGIN [{0}];"

$CREATE_DATABASE = "CREATE DATABASE {0};"
$CLOSE_CONNECTIONS = "alter database {0} set single_user with rollback immediate;"
$SET_MULTIUSER_MODE = "alter database {0} set multi_user with rollback immediate;"
$REMOVE_DATABASE = "DROP DATABASE {0};"
$CHANGE_DBOWNER ="EXEC sp_addrolemember 'db_owner', '{0}'"
$REVOKE_USER_PERMISSION = "REVOKE DELETE, INSERT, REFERENCES, SELECT, UPDATE ON {0} FROM {1};"


$BACKUP_DB = "BACKUP DATABASE {0} TO DISK = '{1}' WITH copy_only;"
$RESTORE_DB = "RESTORE DATABASE {0} FROM DISK = '{1}' WITH REPLACE;"

$ALTER_LOGIN = "ALTER LOGIN {0} WITH PASSWORD = '{1}';"

$GET_SQL_Files = "EXEC sp_helpfile;"
$SET_MAXSIZE = "ALTER DATABASE {0} 
				MODIFY FILE
    				(NAME = {1},
    				MAXSIZE = {2}MB);"

$SHRINK_DATABASE = "DBCC SHRINKDATABASE ('{0}', 100);"
$SPACE_USAGE = "USE {0}
EXEC sp_spaceused
"

