service

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.
--
Thanks
.

Relevant Pages

  • Re: Copying table Structure from one server to another
    ... Most good judgment comes from experience. ... "tab1" from Server A into Server B. I dont want to copy the whole ...
    (microsoft.public.sqlserver.dts)
  • Copying table Structure from one server to another
    ... "tab1" from Server A into Server B. I dont want to copy the whole ... Kiran G ...
    (microsoft.public.sqlserver.dts)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)