Database problem

Hi,

I have MS SQL Server 2005 installed on the computer. I would like to connect to a database in the MS SQL Server from the RS SQL Server I also have got. I have got an instcurtion how to do this but they use MS SQL Server 7.0 which is the problem. When they open MS SQL Server Enterprise Manager they can open up a directory structure and find Databases/Tables which could be find on the computer. Now I wounder how I′ll do the same thing in MS SQL Server 2005?

When I start MS SQL 2005 I can′t find any structure, to find tha database and the tables I want to connect to. I have also got an database in a *.txt-file and I wounder where I should place this file on my hard drive.

Please help me.

Best Regards

Anna

I didn′t get you correctly, could you explain this again please.

HTH, jens SUessmeyer.

http://www.sqlserver2005.de|||"MS SQL server Enterprise Manager" has been renamed to "Microsoft SQL Server Managment Studio" in sql server 2005.

When you open manament studio you will get an "connect to " dialog box. Chose "database engine" and enter you credentials. If in doubt use Server name: (local) and Authentication "Windows Authentication"

On your left hand side you should have "object explorer" in this you should be able to expand a tree like strucutre that is similar to enterprise manager's tree view. If you don't see the object explorer, try pressing F8.

The database you have as a text file is most likely a dump of a table, you can either bulk import using f.eks "bulk insert" or make a import routine using SSIS.|||Just for the common sense, SSMS not just has been renamed, it has been, like other features of SQL Server build from scratch. SSMS relies on SMO as SQL Server EM relies on SQL-DMO. Just for the common understanding of the original poster :-)

HTH, jens Suessmeyer.

http://www.sqlserver2005.de