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


Post New Web Links

What is the next version of SQL Server ?

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server
 

What will be the next planned version of SQL Server after SQL Server 2008 / SQL Server 2008 R2.

 




View Complete Post


More Related Resource Links

Team System: Team Foundation Server Version Control

  

In this new column, Brian Randell begins his long look at how to extend and enhance Visual Studio Team System.

Brian A. Randell

MSDN Magazine January 2007


SQL Server CE: New Version Lets You Store and Update Data on Handheld Devices

  

Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS. The architecture of SQL Server CE, along with data manipulation, synchronization, and connectivity issues, are discussed in this article. Topics such as making your data public, choosing the right type of replication, and handling errors are also covered.

Paul Yao and David Durant

MSDN Magazine June 2001


Uninstall SQL Server 2008 trial version

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

SQL Server 2005: Install reporting services - which version?

  
Hello - I installed SQL Server 2005 as part of an SBS2008 install. I need to install reporting services, but now I'm having trouble identifying which version (X64 or X86) I'm running. Is there an easy way of figuring out which installation disk I need to insert for SQL Server 2005? Thanks, Nick.

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

sql server doesn't support version

  
The database DATABASE.MDF cannot be opened because it is version 655. This server supports version 611 and earlier.  A downgrade path is not supported.Could not open new database 'DATABASE.MDF'. CREATE DATABASE is aborted. 

Cannot retrieve trace definition for SQL Server version

  
I am getting this error when I try to start  "New Trace" from Sql server Profiler. Cannot retrieve trace definition for SQL Server version 10.50.1600. Installation details Sql Server version : Sql 2008 R2 Developer edition Sql Management Studio, Profiler version : 10.50.1600.1   I referred this post http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/e61b4800-bd69-4819-955a-e1c53594e1ef/ My registry looks fine. Any sugestions? Thanks.Thanks and Regards, Senthil | Stop Genocide in Sri Lanka | www.tamilsagainstgenocide.org

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.

Error - The evaluation period for this version of SharePoint Portal Server has Expired

  
I am using SharePoint Portal Server 2003 and in the app log I'm seeing this error "The evaluation period for this version of SharePoint Portal Server has Expired" which I believe is causing the search service to not work and I can no longer sign in to the SP central admin console. While I did not perform the install myself it has been running for over a year and according to MS the SP PS 2003 eval was only 120 days so I assume the full version was installed.  Any idea's? There are a couple more errors in the event log but I assume they are symptoms and not causes. Event Type:    Error Event Source:    SharePoint Portal Administration Service Event Category:    None Event ID:    502 Date:        9/13/2010 Time:        9:05:03 AM User:        N/A Computer:    SP1 Description: An exception occurred in the search synchronizer. Event Type:    Error Event Source:    Service Control Manager Event Category:    None Event ID:    7023 Date:        9/13/2010 Time:        9:11:34 AM User:        N/A Computer:    SP1 Description: The Microsoft Shar

Cannot Restore Backup from Sharepoint Server 2007 to Sharepoint Server 2010 Trial Version

  
After installing the trial version of Sharepointn 2010 I wanted to restore my Sharepoint 2007 sites to it but received the following error:  "The site collection could not be restored. If this problem persists, please make sure the content databases are available and have sufficient free space." I went on to create a new content database in sharepoint 2010 but it still did not work. The old database i.e the one used by the sharepoint 2007 server is SQL 2005. During the installation of the sharepoint 2010 version I selected SQl Server Express for the database. Is there any specifics for migrating from MOSS 2007 to sharepoint 2010? Thanks for helping

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

Forum FAQ: How can I degrade a SQL Server database from a higher version to a lower one?

  
Symptom Many times we are asked if it is possible to degrade a SQL Server database from a higher version to a lower one due to the business needs of data migration.  However, it looks that Microsoft SQL Server doesn’t support degrading a SQL Server database from a higher version to a lower version by using the Copy Database Wizard or the detach and attach methods.    Solution Yes, degrading a SQL Server database is not supported, but you can use a flexible workaround to resolve this issue. You can use SQL Server Management Studio to first generate scripts for a lower version and then use Data Import/Export Wizard to transfer data. For example, if you want to degrade a SQL Server 2008 database to SQL Server 2005, you can follow the steps below: 1.  Open the SQL Server 2008 database in SQL Server Management Studio 2008. 2.  Right click the database name in the Object Explorer and select "Tasks Generate Scripts…" 3.  In the Script Wizard dialog box, select the database name and check "Script all objects in the select database". Then click "Next". 4.  Set the "Script for server version" option as SQL Server 2005. 5.  Run the script in SQL Server 2005. 6.  Import data from SQL Server 2008 to SQL Server 2005 by using the SQL Server Import and Export Wizard.   Similarly, you can do

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

Database server version requirements

  

Hi,

I have a very simple question but I am not sure in answer. I have to install Sharepoint server 2010 enterprise edition and I put it in farm with sql server 2008 enterprise edition.

My question is which edition of SQL server 2008 are compatibile for Sharepoint 2010 enteprise edition. If I choose SQL server 2008 Standard edition is there any limitation about services and features in Sharepoint. (currently we use performance point services for reporting).

Thanks in advance.

 


Data Transfer in C# slow when targeting SQL Server 2005 using SQL Server SMO version 10 (distributed

  

 

Hello everyone,

I have a strange issue regarding SQL Server SMO Transfer. I am using the Transfer class to create a copy of a database. I will explain the different cases I have tried so far and maybe someone can help me figure out what's going on.

First case

I run my C# code from an assembly that references version 9.0.242.0 of SMO assemblies that are in my GAC

  • Microsoft.SqlServer.ConnectionInfo
  • Microsoft.SqlServer.Smo
  • Microsoft.SqlServer.SqlEnum

If I target a database hosted on a Sql Server 2005 database engine, it works perfectly and fast.

But of course, as soon as I try to target a Sql Server 2008 database engine, it complains that it is not compatible. No surprise there.

 

Second case

I run the exact same C# code from an assembly that references version 10.0.0.0 of SMO assemblies that are also present in my GAC

  • Microsoft.SqlServer.ConnectionInfo
  • Microsoft.SqlServer.Management.Sdk.Sfc
  • Microsoft.SqlServer.Smo
  • Microsoft.SqlServer.Smo.Extended
  • Microsoft.SqlServer.SqlEnum

If I target a database hosted on a Sql Server 2008 database engine, it works perfectly and fast.

However, if I try to target the sam

Recommend the best JDBC driver and version to connect to SQL server 2005 sp2

  

SQL version details:Microsoft SQL Server 2005 - 9.00.3050.00 (Intel X86) Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) on a clustered server.

Are there any issues using:

JDBC driver: Microsoft SQL Server JDBC Driver 3.0.
JBOSS: JBoss 4.2.3 with JDK 6 ?


Categories: 
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