I was finally able to try what you suggested and got this error:

Msg 644, Level 21, State 5, Line 1

Could not find the index entry for RID '161fbfb13a010000' in index...

Gail..here you go:

I ran this:

select '[' + name + ']'

from sysobjects

WHERE id = 984727327

order by 1

it returned:

[BRP001_ACCT]

SELECT * FROM sysusers where uid = 11

retuned no data

Gail,

Your query returned no results.

This one "select * from sysobjects WHERE id = 984727327 order by 1"

returned this:

nameidxtypeuidinfostatusbase_schema_verreplinfoparent_objcrdateftcatidschema_verstats_schema_vertypeuserstatsysstatindexdelrefdateversiondeltriginstrigupdtrigseltrigcategorycache

BRP001_ACCT984727327U 11316106127360002002-01-24 16:44:42.253000U 16702002-01-24 16:44:42.2530000000

Andy

here it is:

Msg 3701, Level 11, State 5, Line 1

Cannot drop the table 'BRP001_ACCT', because it does not exist in the system catalog.

I don't think so !

Andy

YES...that worked !

Thank You...Andy

Thanks for responding...will that allow the user to connect under the other group ?