Re: SQL 2005 SP
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Sat, 28 Apr 2007 21:17:39 +0000 (UTC)
Dan Guzman (guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I don't have a case-sensitive server handy to test this on, but perhaps
the property names are case-sensitive in a case-sensitive instance. You
might try specifying the proper case names documented in the Books
Online:
SELECT
SERVERPROPERTY('ProductVersion'),
SERVERPROPERTY ('ProductLevel'),
SERVERPROPERTY (Edition')
Property names are never case-sensitive. "R"'s query ran just fine on
my server, which has Finnish_Swedish_CS_AS as its server collation.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: SQL 2005 SP
- From: Dan Guzman
- Re: SQL 2005 SP
- References:
- Re: SQL 2005 SP
- From: Dan Guzman
- Re: SQL 2005 SP
- Prev by Date: Re: Limit Connection Type?
- Next by Date: Re: SQL 2005 SP
- Previous by thread: Re: SQL 2005 SP
- Next by thread: Re: SQL 2005 SP
- Index(es):
Relevant Pages
|
|
