Solved

What is the difference between sqlmgmproviderxpsp2up.mof and sqlmgmprovider.mof ?

Posted on 2008-06-20
3
1,467 Views
Last Modified: 2008-09-14
We recently installed  SQL 2005 Express onto a VPS system using Windows 2003 Enterprise ed. 64 bit. We ran into an error and found the fix at the following link:

http://blogs.msdn.com/echarran/archive/2006/01/03/509061.aspx

However, this raised a new question. Our system had the sqlmgmproviderxpsp2up.mof file as opposed to the sqlmgmprovider.mof which is supposed to be present for our version. Is this difference due to the fact that it we are using SQL Express? Is there a difference in the two files other than the name? Is it safe to run SQL Express with the sqlmgmproviderxpsp2up.mof file?
0
Comment
Question by:easycgi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 16

Accepted Solution

by:
SQL_SERVER_DBA earned 500 total points
ID: 21849164
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Help needed in sql query 4 28
sql server cross db update 2 20
SQL Distinct Question 3 14
T-SQL: Please describe what a page split is 5 28
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question