Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Tue, 15 May 2007 10:02:44 -0400
Pete d'Oronzio [pdmagic] wrote:
For SQL 2000 and up, rthis will work:Any chance you know how to test the SP level from code?Just do a "select @@version" and compare the result to this chart:
Thanks!
http://www.aspfaq.com/sql2000Builds.asp
Hmm.. That select @@version is handy to look at, but not much for
coding against. I don't imagine the format is defined and will be
consistant.
SELECT 'SQL Server '
+ CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - '
+ CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' ('
+ CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- References:
- ADO OpenSchema( adSchemaPrimaryKeys , ...)
- From: Pete d'Oronzio [pdmagic]
- Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
- From: Bob Barrows [MVP]
- Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
- From: Pete d'Oronzio [pdmagic]
- Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
- From: Bob Barrows [MVP]
- Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
- From: Pete d'Oronzio [pdmagic]
- Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
- From: Bob Barrows [MVP]
- Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
- From: Pete d'Oronzio [pdmagic]
- Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
- From: Bob Barrows [MVP]
- Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
- From: Pete d'Oronzio [pdmagic]
- ADO OpenSchema( adSchemaPrimaryKeys , ...)
- Prev by Date: Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
- Next by Date: Assinging Database Tables at Runtime using Data Environment
- Previous by thread: Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
- Next by thread: Re: ADO recordset doesn't see DB changes
- Index(es):
Relevant Pages
|
|
