SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Error Message

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Error Message
Author Message
iunknown



Joined: 15 Feb 2007
Posts: 1
Country: eg

Post Error Message Reply with quote
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
Thu Feb 15, 2007 12:05 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
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
Thu Feb 15, 2007 2:37 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.