Cool, now it works!! Many thanks for your quick and good help 🙂

SELECT [MachineName], convert(varchar(255),[ServerDN]), count(convert(varchar(255),[serverdn])) as 'Count' FROM [BESMgmt].[dbo].[MyView]

group by [machinename], convert(varchar(255),[serverdn])

I had do convert it everywhere.

Excellent! 😀

Hm, there is no way to change the original database. The tables and fields are from a Blackberry SQL database (!).

The only thing I can do is to create a...

Column1 is nvarchar(256), Not Null

Column2 is ntext, Not Null

Btw, the two columns are in a view. (two related tables behind it).

Many thanks for the quick reply. This one I have tried already, but it returns always with this error message:

Server: Msg 306, Level 16, State 2, Line 1

The text,...