Friday, March 9, 2012

Newbie for 2000 SQL Server

Dear All, I would like to know whether I can create a distributed database
by using SQL 2000 Server? If possible, any reference? Thanks alot!!The short answer is yes. The long answer is - what are you actually trying to
achieve as there are multiple ways to implement a "distributed database"

> Dear All, I would like to know whether I can create a distributed database
> by using SQL 2000 Server? If possible, any reference? Thanks alot!!

Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvfor...p?SRV=MSDevApps
(faqxxx.zip in lib 7)
or http://www.ntfaq.com/Articles/Index...epartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq|||Hi,

Refer sp_linkedservers T-SQL in SQL Books Online. Distirubted database
is called linked database. You can search for "Linked Server" keyword
in helps.
Also, refer SQL Server Enterprise monitor/Security/Linked Server
section.

Thanks Amit.

"Chris" <router88@.sinaman.com> wrote in message news:<bearmh$5ls2@.imsp212.netvigator.com>...
> Dear All, I would like to know whether I can create a distributed database
> by using SQL 2000 Server? If possible, any reference? Thanks alot!!

No comments:

Post a Comment