.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL 2008 R2 ANSI/ISO Version Compliance

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :

Our enterprise architect wandered by yesterday and asked me what SQL 2008 R2 is compliant with from an ANSI standards standpoint.

Years ago I remember that SQL was ANSI-92 compliant.  I am finding it very difficult to find out whether or not it's compatible or follows any sort of ANSI standard.  Along the same lines, I believe it is ISO compliant but again can't find anything SQL 2008 R2 specific.

Any guidance or suggestions?  I thought this was a dumb question but my inability to find an easily accessible answer is frustrating.

View Complete Post

More Related Resource Links

Uninstall SQL Server 2008 trial version

I would like to know how to properly uninstall SQL Server 2008 trial version altogether.

Does MOSS 2007 Support SQL Server 2008 R2 RTM version?

Hi, We have MOSS 2007 SP1 databases in SQL Server 2005 EE x64 with SP3. Now, we want to upgrade the SQL Server 2005 to SQL server 2008 R2 EE x64 RTM version. Does MOSS 2007 Support SQL Server 2008 R2 RTM version? If yes, please take me to the MS link where I can find this information. Thanks

Newer version of UnDouble to assist wih quotes in 2008

I found references to the downloads below which assist in parsing data with double-double quotes in it. Are there SSIS2008 versions of these components? I can't fin them. http://www.microsoft.com/downloads/details.aspx?familyid=b51463e9-2907-4b82-a353-e15016486e1d http://www.microsoft.com/downloads/details.aspx?FamilyID=9c624eab-6893-4734-b5dd-f80d0d487aa1  http://www.microsoft.com/downloads/details.aspx?familyid=91e24d1d-acf0-45b1-a9a5-9ea1c7bd0463 DylanBack of the net...

getting MOF error trying to install either SQL 2005 Developer version or SQL 2008 R2 Developer versi

I have tried so many times but failed to install SQL 2005 Developer version on my XP machine. Got the 29513 error. I then switched to SQL 2008 R2 Developer version and got the MOF syntax error. I'm new SQL Server and need some help fixing this problem. I'm not sure what version of the SQL 2005 version it is. I downloaded it from MSDN Subcriber Download page. Any help to fix this problem would be appreciated. Got a project that needs to use Sql Server ASAP.

Install MVC/jQuery on MS VS 2008 trial version

Greetings, Please assist me in system requirements on installing MVC/jQuery in MS VS 2008 trail version. Do MVC/jQuery ships with VS 2008 Premium/Professional Trial Version? Or I have to download it separately. Thank you beforehand. Jagdish

sql server 2008 version upgrade failed access to path is denied

upgrading from 2008 r2 eval to 2008 r2 enterprise. Use the maintenance option from setup. Get pretty far along in the process.  But then the following error. ( an additional note. setup warns that I am running sql server on a domain controller server. ) The link the error message points to has nothing to say. Why would my sql server upgrade fail? If I have to reinstall, will I lose my database data? thanks,   TITLE: Microsoft SQL Server 2008 R2 Setup ------------------------------ The following error has occurred: Access to the path 'C:\Program Files\Microsoft SQL Server\100\License Terms\SQLServer2008R2_License_ENT_1033.rtf' is denied. Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup. For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.1600.1&EvtType=0x60797DC7%25400xBB814387  

SQL Server 2008 R2 deploying any version of sharepoint results in extremly slow DB creation

Hello, When installing any version of Sharepoint(2007,2010) during the "Creating Configuration Database" Step it takes over 10 hours to complete.  Then creating a web app takes just as long. and the sites are extreemply slow.  Environment: 1) DB Server - SQL Server 2008 R2 on Windows Server 2008 R2 2) Webserver - to host Sharepoint 2010 on Windows Server 2008 R2 The Servers are on the same network and running with lots of horsepower, disk and memory.  Are there any know issues with this and should we install Cummulative Update 3? Maybe that has a fix.  We exhausted all our options and need justification to apply the CU3 hotfix(s). Thanks for your help.

Could not load file or assembly 'Compliance, Version=, Culture=neutral, PublicKeyToken=null'

We recently upgraded from .NET 1.1 to .NET 3.5. The project was running fine until yesterday when I tried to create a set up project. When I add a new Websetup project and rebuild solution I get error :  Error 79 Could not load file or assembly 'Compliance, Version=, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417) Y:\Development_Sites\Development_Server_RW\QMComet\SGEN Compliance Now when I run the project  , I get : Server Error in '/QMComet' Application. Parser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. Parser Error Message: Could not load type 'Jennison.Compliance.Global'.Source Error: Line 1: <%@ Application Codebehind="Global.asax.cs" Inherits="Jennison.Compliance.Global" %> Source File: /QMComet/global.asax    Line: 1     Please help. I wwas able to run the project before I tried to create a set up.   Thanks,Rohit

what is the latest version for SQL Server 2008 R2

We are using Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2).    LISA86

Your version of SQL Server 2008 isn't compatible with this version of Windows

Fresh Win7 Ultimate install. Fresh VS2010 Ultimate install. Now trying to install Microsoft® SQL Server® 2008 Management Studio Express. I get a dialog that says, "Your version of SQL Server 2008 isn't compatible with this version of Windows." There is a link provided Click to download the update from the Microsoft Corporation website. That link leads me to the download for SQL Server 2008 Express Edition Service Pack 2 – CTP. And THAT link leads to a VERY scary installer. Is this REALLY what I'm supposed to do? Thanks Eric

accessing package level variables in a Script Component in 2008 version


how to access the package level variables within a script component in SSIS 2008

Cumulative Update 5 - wrong SQL 2008 version number


Hi all,

I installed Service Pack 1 for SQL 2008 on one of my servers. This server has multiple instances. In this case, it is the instance "SHAREPOINT2010" that is giving me difficulties.

For Sharepoint 2010, we need to install cumulative update 5. This update fails due to the fact I do not have the correct SQL version. It is expecting version 10.0.2531 (SP1), but it says I have the 10.0.1600 (RTM). When I check in my management studio and via the @@version, I do see the confirmation I have version 10.0.2531. (also see attached screenshot).

Does anyone know why the cumulative update fails to see the correct server version ? If I try to install it on another SQL 2008 SP1, it works fine..;

Thank you !



screenshot sql version

trying to use custom assembly with script task in SSIS 2008 - can't find correct version of GACUtil


I am trying to use a custom assembly (compiled with VS 2005 framework 2.0) with SSIS 2008.  I understand that I need to put this Assembly in the GAC.  I initially attempted to do this using the GACUtil, but I apparently only have version 1.1 of GACUtil intalled on my development PC.  Shouldn't version 2.0 have been installed as part of VS 2005? 

So I then tried simply copying the dll into the GAC folder using windows explorer.  Well, the dll is now visibly in the GAC folder, but I cannot see it from either VS 2005 or BIDS 2008.  Does that mean I do need to use GACUtil 2.0 or higher to install the DLL into the GAC?  If so, is there any place on the Web that I can download it?

sql 2008 installation question, windows installer version check?


sql 2008 installed, but didn't get pop up for windows installer 4.5, though intallation complete, but still wants to confirm the windows installer version, however, the windows 2008 seems not like w2k3 to show all windows components you installed, I only see .net 3.5sp1 on the appwiz.cpl

Encryption and FIPS Compliance of Analysis Services 2008


We have SQL Server succesfully set up for FIPS Compliance, But require to setup the same Compliance for the Encryption of Data in Analysis services 2008 enterprise on the same Win 2008 server.

If we browse to the SAS Data Folder for our Project on the Fips Compliant  Instance We can view the Data Files and the Data is Visible in Plain Text. Depite the security setting being set to DataProtectMode 1 (Encryption).

So my Questions:

1. Is Analysis Services 2008 enterprise Fips Compliant ?

2. if it is How do we set it up

3. how do we prove to security Auditors that it is Set up and Working in Compliant Mode.

We have done Exaustive Searches of msdn Google blogs, sql-cat etc and found no relevent articles to Answer these specific Questions and are reluctant to Go to Chargeable support until we have exausted other available avenues.

changing your asp version in visual studio 2008


Dear All, 

How do you go about changing your asp.net version from asp 2.0 to asp 3.5 ? Thank you. 

I cannot seem to be able to fully install Mircosoft Server 2008 32 Bit Trail version


Hi have been trying without any success to install Mircosoft Server 2008 32 Bit Trail version on my Windows Vista 32 Bit Desktop at home.  Below are the error messages that I received both times.

Feature Name


Database Engine Services


SQL Server Replication


Can anyone out there please tell me what I am doing or not doing correctly? Any suggesti

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend