Yes I did, argh!  Still not working.  Since it would appear to be working for others, I figure it is probably time to raise the white flag.

Yes - both were created by the same domain admin account and show the owner to be sa

Kevin

Hi Greg,

Same problem there.  This is one of those cases where everything "seems" to be okay but it is not working as advertised.  I have moved onto other things in...

I did (rather defeats the purpose of chaining doesn't it) however, I still need to grant permissions to the individual objects to get it to work.  There is a flag...

Sure - here's the whole enchilada

Use InternetUserArea

go

if exists( select * from sysobjects where name = 'GetUserInfo' )

 drop proc dbo.GetUserInfo

go

create proc dbo.GetUserInfo(

 @sUserLogin  varchar(50),

 @sPassword  varchar(50)

)

as

begin

 if exists( select * from TTCUserInfo.dbo.BasicUserInfo

  where login_name = @sUserLogin and...