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 2005 Forums
 Other SQL Server Topics (2005)
 Execution Environment

Author  Topic 

MGouders
Starting Member

30 Posts

Posted - 2007-05-09 : 13:02:12
Hi,
I have a question regarding the following server landscape.
A SQL Server 2000 box named A is linked to a SQL Server 2005 box named B.
Scenario: Data needs to be modified on A but the user is logged in on B
Can scripts ,such as stored procedures, be written on B taking full advantage of the newest features such as error handling and trigger objects, such as stored procedures or functions, on A?

Mike
   

- Advertisement -