Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kauind
Starting Member
20 Posts |
 Posted - 2000-12-19 : 01:58:48
|
| Hi Is is possible to create database through vb. I am creating a procedure with one input paratmeter ie: database name but it does not create the procedure it gives errorLine 3: Incorrect syntax near '@DatabaseName'.The procedure is create proc prcCreateDatabase @DatabaseName varchar(50)as CREATE DATABASE @DatabaseName ON ( NAME = @DatabaseName + '_dat', FILENAME = 'c:\mssql7\data\' + @DatabaseName + '.mdf', SIZE = 5, MAXSIZE = 50, FILEGROWTH = 5 ) LOG ON ( NAME = @DatabaseName + '_log', FILENAME = 'c:\mssql7\data\' + @DatabaseName + '.ldf', SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB ) GOBye |
|
|
|
|
|
Create Database