How to create database using vbscript code?

Question

Please tell me how to create database in sql server using vbscript code? And where we have to write the code?

Nilanka Dharmadasa · Answer

Hi friend You can write this in your script to connect to your SQL server DB. Const adOpenStatic = 3 Const adLockOptimistic = 3 Set objConnection = CreateObject(ADODB.Connection) Set objRecordSet = CreateObject(ADODB.Recordset) objConnection.Open _ objConn.Open Driver={SQL Server}; & _ Server=YourServer\DatabaseInstance; & _ Database=DatabaseName; & _ user id=username; & _ password=password; objRecordSet.Open SELECT * FROM Customers _ objConnection adOpenStatic adLockOptimistic objRecordSet.MoveFirst If this helps you please accept my answer...