No assistance provided for one server

	Quote:
	Can you correct this section of the query:

Replace schema_id <16384> 0 with schema_id between 1 and 16383

Doesn't work:

	Code:
	select name collate Latin1_General_CI_AS, case when type = 'R' then 'SR' else 'SL' end, principal_id from /db./sys.server_principals sp where type in ('S','U','G','R') and not exists ( select null from /db./sys.schemas where schema_id between 1 and 16383 then 'SR' else 'SC' end, cast(uid as int) from /db./dbo.sysusers where issqluser = 1 or isntname = 1 or issqlrole = 1 or isapprole = 1

It looks like the forum software took the > from one query messed up the < in another, or vice-versa. I need both select queries, the one from server_principals and the one from sysusers.

Here is the complete code, I simplified it even further, to return only schemas with objects.

	Code:
	select distinct name, 'SC', uid from /db./dbo.sysobjects where uid between 1 and 16383

Using that query for schemas caused this error:

---------------------------
SQL Assistant - Error
---------------------------
Message: Specified cast is not valid.
Context: Fetch
select distinct name, 'SC', uid

from [Database].dbo.sysobjects

where uid between 1 and 16383

---------------------------

OK
---------------------------

error ocurred on:
Select

Error only occurs in Management Studio, not in Query Analyzer. BTW, this is the correct schema query:

	Code:
	select distinct name, 'SC', uid from /db./dbo.sysusers where uid between 1 and 16383

Here is the corrected query
http://www.softtreetech.com/support/phpBB2/viewtopic.php?p=19349#19349

The idea was to remove 'sysdba','SL' from the result set.

Perfect! It works awesome now. Thanks so much.