Solved

question about MS SQL 2005  server management studio

Posted on 2008-10-01
4
158 Views
Last Modified: 2010-03-19
hello:

could some expert here tell where are the sql interface and import data interface in MS SQL 2005  server management studio?

thanks very much!

0
Comment
Question by:lilyyan
  • 2
4 Comments
 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 200 total points
ID: 22618145
right click on the database, select tasks, then IMport.  From there a wizard will guide you.
0
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 300 total points
ID: 22618172
By "SQL interface" I assume you mean query editor.  If you have a server or database highlighted, you should have a new query button below "File" in the menu bar.
0
 
LVL 41

Expert Comment

by:graye
ID: 22618688
Also, make sure you're using the "real" Management Studio, and not the one from the Express Edition
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22619145
graye:

What if that's all (s)he has access to?
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now