Null for "SELECT SERVERPROPERTY('productversion')"
hai wu <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CAJ1=nZf+Njet5j-PbtWBwaC4rsD=7Py4n0=cobhnRDyTW_W6MA@mail.gmail.com> |
Freetds 0.64 is used here. When I used it to connect to a MS SQL 2008
named instance, I could retrieve value using:
SELECT @@SERVERNAME
SELECT @@VERSION
But when using:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY
('productlevel'), SERVERPROPERTY ('edition')
It returns 'NULL' for all of them.
Any explanations?