Hi,
I have sql script which creates a database dynamically, I want to convert this script into a stored procedure. Can anybody help me?
Here is my sql script looks like..
set nocount on
set dateformat mdy
USE master
if exists (select * from sysdatabases where name='new_database')
begin
raiserror('Dropping existing 'new_database' database ....',0,1)
DROP database 'new_database'
end
GO
CREATE DATABASE 'new_database' ON DEFAULT = 3
ELSE
CREATE DATABASE 'new_database'
GO
CHECKPOINT
GO
USE new_database
create table a;
How shall I use same script within a stored procedure passing a parameter as 'database_name' to create a new database.
Thanks in adavance
I have sql script which creates a database dynamically, I want to convert this script into a stored procedure. Can anybody help me?
Here is my sql script looks like..
set nocount on
set dateformat mdy
USE master
if exists (select * from sysdatabases where name='new_database')
begin
raiserror('Dropping existing 'new_database' database ....',0,1)
DROP database 'new_database'
end
GO
CREATE DATABASE 'new_database' ON DEFAULT = 3
ELSE
CREATE DATABASE 'new_database'
GO
CHECKPOINT
GO
USE new_database
create table a;
How shall I use same script within a stored procedure passing a parameter as 'database_name' to create a new database.
Thanks in adavance