| Hugo Kornelis 2005-07-20, 8:24 pm |
| On Wed, 6 Jul 2005 07:34:01 -0700, shif wrote:
>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.
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.
>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.
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
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
|