Replication question

[ronmon]

I am new to SQL Server and i have started devoleping a distributed database initially i was looking to employ replicaiton a lot but then after discovering Linked Servers it seems a lot easier to use this method to transfer data between servers.

I was just wondering if anyone could let me know why use replication instead of linked servers

 

[mrdenny]

Replication and linked servers are used for different purposes.

Linked servers are used to access data on a remote server, that isn't storred in the local server.

Replication is used to make a perfect copy of the table or tables which are published within the publication.

This could certinaly be done through linked servers via your own code, but why re-envent the wheel.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[ronmon]

thanks but i have come across a problem that with a particular stored procedure thats updates a number of tables on seprate servers that if i use replication it doesn't happen fast enough to maintain integrity is there a way of running a stored procedure that will run another stored procedure when a certain action has happened i.e. table has been updated

 

[mrdenny]

Yes. That would be a trigger. In Books OnLine look under the topic "triggers".

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[ronmon]

Thanks sorted it out at last

 

[mrdenny]

no problem.

Denny

--Anything is possible. All it takes is a little research. (Me)