Link to home
Start Free TrialLog in
Avatar of sydneyguy
sydneyguyFlag for Australia

asked on

sql server and importing a new script

hi i have a sql server 2005 express installed and am loading up a script, but it keeps going into the master instead of the db that i want it to, were do you configure this please is the a place to change were imports go into


CREATE TABLE tblWebData (
      [ID] VARCHAR(255),
      [Email Address] VARCHAR(255),
      [Linked Text] VARCHAR(255),
      [Page URL] VARCHAR(255),
      [Page Title] VARCHAR(255),
      [Starting URL] VARCHAR(255))
INSERT INTO tblWebData ([ID],[Email Address],[Linked Text],[Page URL],[Page Title],[Starting URL]) VALUES ('1','ariana.nikitas@allscripts.com','Ariana Nikitas','http://www.allscripts.com/en/company/press-room/news.html','Allscripts - News','http://www.allscripts.com/')
INSERT INTO tblWebData ([ID],[Email Address],[Linked Text],[Page URL],[Page Title],[Starting URL]) VALUES ('2','Robin.Williams3@allscripts.com','Go','http://www.allscripts.com/en/company/about-us/in-the-community/cdschallenge.html','Allscripts - CDS Challenge','http://www.allscripts.com/')
ASKER CERTIFIED SOLUTION
Avatar of 8080_Diver
8080_Diver
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sydneyguy

ASKER

thanks for you help