Re: Can't call databasepropertyex() on MSSQL over tds version 8.0

I just realized if I use:

SELECT CAST(databasepropertyex(DB_NAME(), 'Collation') AS VARCHAR)

then the query works on tds version 8.0 as well.

That's all I needed.

> On Mon, Apr 05, 2010 at 12:36:30AM -0400, Rafael Kitover wrote:
> > If I change it to:
> > 
> > [global]
> >         tds version = 8.0
> > 
> > Then the query no longer works:
> > 
> > echo "select databasepropertyex(DB_NAME(), 'Collation')\ngo" | tsql -H server -p 5000 -U sa -P pass
> > locale is
> > "LC_CTYPE=en_US.utf8;LC_NUMERIC=en_US.UTF-8;LC_TIME=en_US.UTF-8;LC_COLLATE=en_US.UTF-8;LC_MONETARY=en_US.UTF-8;LC_MESSAGES=en_US.UTF-8;LC_PAPER=en_US.UTF-8;LC_NAME=en_US.UTF-8;LC_ADDRESS=en_US.UTF-8;LC_TELEPHONE=en_US.UTF-8;LC_MEASUREMENT=en_US.UTF-8;LC_IDENTIFICATION=en_US.UTF-8"
> > locale charset is "UTF-8"
> > 1> 2>
> > NULL
> > (1 row affected)
> > 1> %