Utter noob. please advise. - SQL Server Forums

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.

All Forums

SQL Server 2012 Forums

Transact-SQL (2012)

Utter noob. please advise.

Author

Topic

ShaneAvent
Starting Member

1 Post

Posted - 2013-11-08 : 11:00:02

I need to set up a test database, i have never really done anything like this.

I have been given a txt file to put into a query, I was told all i need to do is install an instance of sql express and execute this query but when i did, it gave me a lot of errors, beginning with AssistedSales database doesn't exist, so i found a section in the code that has "CREATE DATABASE [AssistedSales] ON PRIMARY" but it was half way down the file, i put this first in the query, and the errors changed to what you see in the image.

can anyone tell me if this is just completely wrong and i have been given a fools errand or am i missing something. Oh and also, even though the create database is at the top and i no longer receive the error about it not existing, it still doesn't get created in the left pane.

After i altered it.

Before i altered it. this is how it was given to me and told it would sort itself out...

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2013-11-08 : 11:08:10

>>I was told all i need to do is install an instance of sql express and execute this query
Unless you were hired as a DBA I would just copy the errors into a reply and send it back to the person that provided it.

If you need help fixing the errors then post the original script here - not as an image but as text within code tags:
[code ]
...
[ /code]

Be One with the Optimizer
TG

sz1
Aged Yak Warrior

555 Posts

Posted - 2013-11-13 : 06:30:08

What permission have you set yourself on the server?
You first need to set yourself up as sysadmin permissions to install objects. Security - New User - YourName - set permissions to sysadmin for the account. Try script again!

SZ1
Please help me to enable me to help others!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources