TADODataset : incorrect syntax near "fn_listextendedproperty"


2003-09-24 08:19:06 AM
delphi67
I've got a TADODataset connected to SQL Server 2000. ParamCheck is
set to off, command text is:
SELECT
objName as TableName,
value as TableDescription
FROM
::fn_listextendedproperty (
'MS_Description',
'user',
'dbo',
'table',
default,
default,
default
)
Order By objName
When I try to open the dataset, I get the error mentioned in the
subject line. Odd thing is, I have another TADODataset running a very
similar command text (except at column level) and it runs just fine.
Running SQL Server 2000, Delphi 5 with latest fixes.