Is there a simple way to update a database that is on another SQL Server via a stored procedure? I do have a IP connection between the 2 servers. I am looking for a way that works on both MS SQL 6.5 and 7.0.
Thanks.
