.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

SP2 uninstalled successfully, but @@VERSION still shows SP2/ 10.0.4000

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :Sql Server

I uninstalled SP2, successfully according to the Setup GUI

But @@VERSION is still returns:

Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64)   Sep 16 2010 19:43:16   Copyright (c) 1988-2008 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)

In object explorer in SSMS the version is also shown as 10.0.4000

The Discovery Report from Setup shows version 10.1.2775

What could be the cause of this discrepancy?


View Complete Post

More Related Resource Links

2008 R2 Web Service URL - just shows empty page and SQL version number


In SQL Server 2008 R2 I installed reporting services.


When I go into the Reporting Services Configuration Manger and then Web Service URL and click the hyperlink it just goes to an empty looking page.


localhost/ReportServer - /


Microsoft SQL Server Reporting Services Version 10.50.1600.1 

The Report Manager URL works fine.

I have uninstalled and re-install Reporting Services two times now and changed the URL address several times too.  Still it's always stuck on this page.

Any ideas?


CA shows a different version and the Site Settings show a different one. Why


HI all

In the MOSS 2007 Server i got from the client

In the CA page (_admin/FarmServers.aspx) - the version is i.e the 2009 dec CU

but when i create a web application and then a site in it the site's site settings page shows version (SP2)

Is the Dec CU not applied successfully.  



ASP.NET 4.0: WebForm Routing (quick n dirty version)

One of the things we're adding in ASP.NET 4.0 is built-in support for using Routing together with WebForms. Now, I'm totally aware that this is possible to do already and that a number of people have posted ways of doing this with the Web Routing feature which shipped with ASP.NET 3.5 SP1. We're just adding some features to make it easier to do

how to know when a user finish his file download successfully ?


hi all

i am doing a page to sell files online

 the paying method is by a card or bank account and the customer is not registered to the site so i want to make sure that the customer has downloaded the file successfully after that the system completes the payment operation

so if there is any way to know do that tell me please

i use c# thanx all



Build succeeded but still shows as failed.


 I am able to run a build successfully on just the web site, but when i add the deployment project it shows failed (see below) but in the details it says build succeeded for the WDP build portion...so I am stumped as to by I am getting a failure. any ideas? I have set the build output to "Diagnostic" and dont see any failures or errors...so is there anything else i can do to find the problem?


Build succeeded.

Time Elapsed 00:00:21.71
------ Skipped Rebuild All: Project: AdminToolHelp, Configuration: Debug Any CPU ------
Project not selected to build for this solution configuration
========== Rebuild All: 1 succeeded, 1 failed, 1 skipped ==========

how to create a mobile version of a website?


 how to create a mobile version of a website?
Is there any server support needed?
How does the browser detect whether the url is accessed via mobile device or a PC?

Coding Tools: Improved Support For Parallelism In The Next Version Of Visual Studio


We take a look at planned support for parallel programming for both managed and native code in the next version of Visual Studio.

Stephen Toub and Hazim Shafi

MSDN Magazine October 2008

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

C++ at Work: Web Version Checking, Adding Sound to an App


This month: CWebVersion revisited using HTTP instead of FTP, and adding sounds to an MFC-based app.

Paul DiLascia

MSDN Magazine May 2006

XML in Yukon: New Version Showcases Native XML Type and Advanced Data Handling


The next version of Microsoft SQL Server, code-named "Yukon," represents quite a few steps forward in the evolution of XML integration. Yukon supports native storage of XML data using the XML data type, which makes it possible to run native queries on XML data using the emerging industry standard XQuery language. Data integrity of the XML data type can be enforced through schema validation and XML-based check constraints, and special indexes can be defined that help speed up queries. In addition, Yukon has the built-in ability to expose its data through Web services. This article discusses these and other XML features of Yukon.

Bob Beauchemin

MSDN Magazine February 2004

Windows CE.NET: New Version Offers Revamped Platform Builder, Improved Tools, Enhanced API, and Sour


Windows CE .NET, the newest member of the .NET family, includes a number of improvements over previous versions of Windows CE. For example, there are quite a few new APIs and enhancements to security and connectivity, the user interface, the kernel, and the emulator. In addition, DirectX support has been added and C++ in Windows CE .NET now supports C++ exceptions, STL, and runtime type information. In this article the author takes a tour of Windows CE .NET, starting with the New Platform Wizard that allows you to code for your choice of devices. A sample application is included that locates features on portable devices so the reader knows what's available before writing code.

Paul Yao

MSDN Magazine July 2002

Beyond Windows XP: Get Ready Now for the Upcoming 64-Bit Version of Windows


In this article the author modifies an industry standard middle-tier application server benchmark called Nile. The goal was to get it to build and run correctly on the 64-bit edition of the Microsoft .NET Advanced Server running on computers with Intel Itanium processors and still build as a 32-bit version to run on Pentium class x86 processors. While modifying Nile, the author discovered some of the tips he presents here. As the article explains, when modifying code for 64-bit Windows, data types are the key to success. The article discusses which types to use and when, along with new data types and the importance of memory alignment.

Stan Murawski

MSDN Magazine November 2001

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

ASP.net WCMS version of MojoMotor


Hi guys,

Before I start I will link you to the WCMS I am refering too: MojoMotor.

I'm new to ASP.net (Hence me not contributing a lot), I have read the following books on ASP.net

And I was generally wondering what more I would need to learn to be able to re-create the MojoMotor WCMS for use in my clients sites, as I use Elance to find jobs. MojoMotor is built in PHP and is based upon EllisLabs own web application framework called CodeIgniter, it may be good to not its an MVC framework.

Basically I would like to near enough replicate this in ASP.net C#, but dont know where to start and how to get its overlay type admin panel? Also how in ASP.net would I be able to have tags for my WCMS that I replace with content pulled from a database, for example:


Would be replaced with the main page content? I guess I would need to write its own jQuery library, which in itself would

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