create view on sql 7 from sql 2005

hi

i need to create view in sql 2005 db from table in sql 7 db

when i try to connect to the sql server i get this messeg:

This version of Microsoft SQL Server Management Studio can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (ConnectionDlg)

there is away to resolve this problam?

yaakov

How did you try to achive this, did you use a linked server for getting the data ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

I try to connect via the database engine and i get this messege

maybe can i do it with script?

TITLE: Connect to Server

Cannot connect to 10.216.50.2.

ADDITIONAL INFORMATION:

This version of Microsoft SQL Server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (Microsoft.SqlServer.Express.ConnectionDlg)

BUTTONS:

OK

|||SSMS uses SMO under the covers, SMO olnly supports 2000 and 2005. YOu will either have to use a 7.0 or a 2000 console.

Jens K. Suessmeyer.

http://www.sqlserver2005.de