Thank you Remi,

I ran it immediately in MS SQL Server-land and it works great. 82 out of 490 rows returned. Now I will convert it for Sybase T-SQL and the membership data...

Informative article. My only complaint is when printing, at our installation, the far right side gets truncated.

Example from Page 3:

@ServerName = TheServerName,

@DBMS_Name = 'MSSQL',@SRV_Security = 1

Results on printout

@ServerName = TheSer 

@DBMS_Name...

SQLBIll,

thanx for the info. Soon I will have access to MS SQL Server files and will test this snippet of code there.

scot

Yelena,

Embarcedero Rapid SQL v 6 is the SQL editor we use. Sybase & Windows SQL Server 2000 are our DB's.

In Rapid, I did not use any databases to execute this query,...

Ran my environment (Rapid SQL v6), the result was 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'.

scot derrer