I just noticed that if I do a straight select on the users table i get the same error message.

The compatibility level is set to 8 (2000) for both servers.

Remus is a sql server 2000 instance.

CREATE TABLE [dbo].[GL7ACCOUNTSECURITY] (

[GL7ACCOUNTSECURITYID] [int] IDENTITY (1, 1) NOT NULL ,

[USERSID] [int] NOT NULL ,

[GL7STARTACCTSID] [int] NULL ,

[STARTACCOUNTMASK] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[ENDACCOUNTMASK] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[QUERIES7ID]...

CREATE TABLE [dbo].[PS_BMC_FE_ACCT_SEC](

[BMC_FE_TBL_ID] [decimal](10, 0) NOT NULL,

[BMC_FE_NAME] [char](20) COLLATE Latin1_General_BIN NOT NULL,

[BMC_FE_MASK_START] [char](30) COLLATE Latin1_General_BIN NOT NULL,

[BMC_FE_MASK_END] [char](30) COLLATE Latin1_General_BIN NOT NULL

) ON [PRIMARY]

CREATE TABLE [dbo].[SECURITYUSERS7] (

[SECURITYUSERS7ID] [int] IDENTITY (1,...

There is no trigger involved here.