Error Message

Hi,
I have this error while typing a simple statement

Quote:

---------------------------
SQL Assistant - Error
---------------------------
Execute: ODBC Error: SQLExecute
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot resolve collation conflict for column 1 in SELECT statement.

if @@version like 'Microsoft SQL Server 2005%'

select

name,

case when type in ('S','U','G') then 'SC' else 'SR' end,

principal_id

from

[TOTALVIEW].sys.database_principals

where

type in ('S','U','G','A','R')

union all

select

name,

case when type = 'R' then 'SR' else 'SL' end,

principal_id

from

[TOTALVIEW].sys.server_principals

where

type in ('S','U','G','R')

else

select

name,

case when issqlrole + isapprole > 0 then 'SR' else 'SC' end,

cast(uid as int)

from

[TOTALVIEW].dbo.sysusers

where

issqluser = 1 or isntuser = 1

or issqlrole = 1 or isapprole = 1

union all

select name, 'SL', 0

from master.dbo.syslogins

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

please advise

This seems to be the same issue as in http://www.softtreetech.com/support/phpBB2/viewtopic.php?t=21495
Please see the solution at the end of that topic