Hi
I have started a server in sql2002 named SERVER1.How can i start
another one new service in same enterprice manager SERVER2.
I tried new sql server registration but its asking for the existing server
name.
ANd second thing is i have to servers serv1,serv2.serv1 is having a table
tab1.
how can i create a view of tab1 in serv2.
--

[quoted text, click to view]

Hi shif,

I'm not sure if I understand you correctly. If you want to have multiple
independent instances of SQL Server running on the same computer, you'll
have to use "named instances". You'll have to install these first -
simply repeat the installation of SQL Server, but choose to install as a
named instance and apply an appropriate name.

After that, you should be able to connect to each of your instances
through Enterprise Manager.

For more information, search Books Online for Named Instances.


[quoted text, click to view]

From a Query Analyzer instance that's connected to serv2, run

CREATE VIEW MyView
AS
SELECT Column1, Column2, Column3
FROM serv1.dbo.tab1
go


Best, Hugo
--