Hi
when I run this query

SELECT *    FROM OPENROWSET('MSDASQL', 'DRIVER={SQL
Server};SERVER=test;UID=sa;PWD=amish;','select  name,
databasepropertyex(name,''status'') as status from
master..sysdatabases') AS a  

It gives status in varbinary format.

If we run select databasepropertyex('dbname','status') it gives result
as character  , why here it gives varbinary results in status column?

Regards
Amish Shah


*** Sent via Developersdex http://www.developersdex.com ***

Toughy Normalization Problem
Timeout expired - on a simple SqlDataReader:Read() call
Is it possible to join two tables in a View/Query where the Second Table is based on a Name in the F
Primary Key Question
OBJECTPROPERTY problem