MS SQL query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

MS SQL query

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-10-26 : 07:33:07

Ankita writes "how can I fire a trigger to update the table on another MS SQL server."

activecrypt
Posting Yak Master

165 Posts

Posted - 2005-10-26 : 07:58:12

Hi,
then you have to add server to your server and your server to another server using
sp_addserver
sp_addlinkedserver
sp_addlinkedsrvlogin

and then as routine we do with triggers

HTH

-----------------------------------------------------------
MSSQL Server encryption software http://www.activecrypt.com

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2005-10-26 : 08:30:28

quote:
Originally posted by activecrypt

Hi,
then you have to add server to your server and your server to another server using
sp_addserver
sp_addlinkedserver
sp_addlinkedsrvlogin

and then as routine we do with triggers

HTH

-----------------------------------------------------------
MSSQL Server encryption software http://www.activecrypt.com

Are you sure in triggers its works..

since i was trying to do it once it gave me some weaired Errors.

Complicated things can be done by simple thinking

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources