troubleshooting Question

sql server and importing a new script

Avatar of sydneyguy
sydneyguyFlag for Australia asked on
DatabasesMicrosoft SQL Server 2005
2 Comments1 Solution362 ViewsLast Modified:
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
8080_Diver

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros