The situation may arise when you need to create a new SQL Database at the SQL server.
Follow the steps below to create a new Database with the script at the bottom of this article:
Note: You should be logged into the DB as SA or have equivalent permissions as the built in SA account
1. Open Microsoft SQL server management studio.
2. In the object explorer expand the database tree
3. Right Click Database and select New Database
4. At the new database screen give it a name of GuardPoint Pro and leave all other settings as default, click ok. A new database will be created:
5. Click onto the new database to highlight it, then from the top menu click New Query. The query window will open:
6. Open the file CreateNewDB.sql in notepad, copy the contents and paste into the New Query window:
7. From the top menu click Execute or press F5
8. The script will run and a new GuardPoint Pro database with the correct tables will be created. You will review details created in the message window below:
Comments
0 comments
Please sign in to leave a comment.