In SQL Server 2000 or earlier, logins that come from remote instances of SQL Server can be marked as trusted by using the ...

In SQL Server 2000 or earlier, logins that come from remote instances of SQL Server can be marked as trusted by using the sp_remoteoption system stored procedure. SQL Server 2005 and later versions do not support this method of labeling remote logins. After you upgrade to SQL Server 2008, remote logins will no longer be marked as trusted.