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


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

The 'Measure expressions' feature is not included in the 'Standard Edition' SKU

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

I'm following the project in Analysis Services Step by Step and have this trouble when I'm trying to deploy My First Cube in Chap 03. I'm not using Standard Edition. I'm using Developer Edition. What do I have to do to be able to continue?

Regards,
Yvonne




View Complete Post


More Related Resource Links

In windows server 2008 standard edition feature Failover clustering is not looking

  
In windows server 2008 standard edition feature Failover clustering is not looking.Yet microsoft is telling that we give 2 node cluster support on 2008 server standard edition.Therefore I have suggested the company to buy it and now I am fixed due to this.  Please Help  "SQLSERVER DBA" "INDIA"

Indexed Views are supported by SqlServer Standard Edition - why do all feature lists state the oppos

  

Hi there,

years ago I had already wanted to apply indexed views for a certain query tuning problem, but read that they are only supported in SqlServer Enterprise Edition. I came back to that topic recently, and again all the official documentation I found confirms that assumption (e.g. http://msdn.microsoft.com/en-us/library/cc645993.aspx).

I gave it a try anyway, and could easily create indexed views on Standard Edition. I checked the execution plans, and the view's indizes were applied. The only small restriction I encountered was, that I had to supply a "with (noexpand)" query hint in the from clause. It even works on SqlServer 2000 Standard Edition.

This is such a valuable feature, probably seldomly applied, because articles and postings everywhere imply that Enterprise Edition is a requirement. I suppose it would be a good idea to correct Microsoft's documentation on that topic. Thank you!

Kind regards, Arno


Content migration from MOSS Enterprise edition to MOSS Standard edition

  
Hi,     I have developed a web application using MOSS 2007 enterprise edition. I have customized the site using custom ASPX pages, custom Webpart and custom features. Also I referred http://blog.brianfarnhill.com/2009/03/19/changing-list-forms-through-code/ for updating the contents of list forms. I have configured SQL-Form based Authentication for this site. Now I have a need to migrate this site to an environment which has MOSS 2007 standard edition and use a Active Directory Authentication instead of SQL-Form based Authentication. So can anyone guide me wether this scenario is possible or it will create any compatibility issue?      Which are the precautions I need to consider for performing this task? I would appreciate any help on this. Thanks, Patav

Please Advice SQL 2008 Standard Edition

  
·         I have a issue with subscriptions since we have SQL 2008 Standard edition and i found out that Data Driven Subscription are disabled. We have about 100 reports subscribed by our internal & external customers. I have a DB "Prices" In that we have 4 Tables, Analysts,Users,SalesReps & Sub Sales rep the subscriptions are by anyone and everyone from these 4 tables.... we have a Project thats in Build in sql server 2008, which is a repository for all our 100 reports....basically what we are trying to do is based on Relationship, security level and user hierarchy they can access the reports... Any ideas will help ???????????FM

Upgrade SQL 2005 standard Runtime edition to SQL 2005 standard edition full version

  
We have a MS SQL 2005 standard edition runtime license. The SQL Server Runtime license is a license that lets an independent software vendor (ISV) embed the complete SQL Server code into a solution for use only by the ISV application. The customers of the ISV cannot use this SQL Server product to run other applications or to develop new applications, databases, or tables. Now we want to add a new database to the SQL. We know that we have to buy a full version of SQL 2008 standard edition. But the question is: How can we add a new database to the existing SQL. Do we have to uninstall SQL runtime license and install the full version and migrate the existing databse or can we change the key and add new databases to the SQL server?

SQL Server Standard Edition and Servers with more than 4 CPUs:

  
Hi, We are planning configure a SQL Server 2008 R2 Standard Edition on a server with 8 CPUs - two quad core with hyper threading. The server also runs many SSIS packages and SSRS reports. We would like to assign the highest priority to SQL database engine. Considering the fact that SQL Standard does not leverage more than 4 CPUs, what would be the best way to dedicate most of CPU power to SQL Server database engine? I already found that I can’t dedicate SPUs to SQL Server through this post: http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/3b797fc8-3bea-422d-b172-7d1a93195c69 I am a bit concern that manipulating the default settings for Affinity and SQL Server priority might cause harm. That is why I am asking for a good practice for specific circumstance explained here. Any help would be appreciated, Max

MOSS 2007 Standard installation with SQL Server 2008 EXPRESS Edition server

  
Hello I have installed MOSS 2007 with SQL Server 2008 Express edition. Can anyone tell me what all features will be missing when compared this setup to MOSS 2007 Stanadard with SQL server 2008 lisenced editon? Specifically will I not be getting forms services with "MOSS 2007 with SQL Server 2008 EXPRESS edition"? Thanks in advance.

Upgrade Desktop Engine (MSDE 2000) to standard Edition 2000

  
Hi All,   I need to upgrade from MSDE to SQL server 2000 Standard Edition how can we proceed with this. I am new to this and any help will highly appreciated. What are the things i should take care before going to this version up gradation ?

Your upgrade is blocked.. when adding components to SQL 2005 Standard Edition SP1

  
Name: Microsoft SQL Server 2005 Tools Hello, I am having a problem when trying to add the Client Components to an existing installation of SQL 2005 Standard Edition SP1 running on Windows 2003 Standard. The server was originally built with SQL 2005 Standard Edition and had SP1 installed at a later date. I am using the CD that SQL was originally installed with which is not a service packed copy of SQL. The reason given when clicking the details button is as follows: Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online. Build version check: Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove. Any help would be greatly appreciated. Regards Steve

Is peer-2peer replication going to be part of Standard Edition?

  
We currently use merge replication and have had numerous issues with it.  Primarily that there is a single point of failure. We are looking at moving to peer-2-peer transactional replication but we are currently running standard edition and have no plans/budget to upgrade. Will peer-2-peer be available in standard edition in the near future?   Thanks, Paul

Replication option SQL 2005 Standard Edition

  
Hi, We are using SQL 2005 Standard Edition.  We would like to use Replication for one of our database. I would like to know answers for the questions. 1. Can we use Replication features with SQL 2005 Standard Edition 2. Can we use DR site with replication for the reporting purpose?  Is there any risks associated with option? 3. Do we still need to take transaction log backup on the production server if we use replication.   Thanks.      

MOSS 2007 Standard installation with SQL Server 2008 EXPRESS Edition server

  
Hello I have installed MOSS 2007 with SQL Server 2008 Express edition. Can anyone tell me what all features will be missing when compared this setup to MOSS 2007 Stanadard with SQL server 2008 lisenced editon? Specifically will I not be getting forms services with "MOSS 2007 with SQL Server 2008 EXPRESS edition"? Thanks in advance.

SQL Server 2005 standard Edition to SQL Server 2005 enterprise edition

  

Hi,

My current version of SQL server is Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)   Nov 24 2008 13:01:59   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

I want to upgrade this to Enterprise edition. I would like to know the below information please

  • step by step instructions on how to perform this upgrade
  • I have databases & replications setup on this server. Will the upgrade have any adverse effects on the current replication setup?

Any help and guidance is truly appericiated. Thanks.


SQL Server 2005 Standard edition install fails; An instance with the same name.../

  

Good Morning

I am trying to install SQL Server 2005 onto Windows Server 2003 Small Business Edition. Previously SQL Server 2000 from the SBE disk was installed, automatic updates are enabled.

I have selected the default instance and everything I try results in the error:

An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.

Log file says;

--------------------------------------------------------------------------------
Machine         : ISAINTERNET
Product         : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install         : Failed
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_ISAINTERNET_SQL.log
Last Action     : DetectInstanceClash
Error String    : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
Error Number    : 28086
--------------------------------------------------------------------------------

Ian Smith


Sharepoint 2010 Standard Edition Custom List Reporting Using Report Builder 3.0

  

hi, i'm making this report from a sharepoint list. i want to add some of the fields as the parameters for the report. (e.g : Category, Department)

i tried to run the report, the parameters were shown as expected

but the problem is when i create a query in the dataset.

i'm using caml query builder for the query expression. it goes like this :

<RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ListName>IT Helpdesk</ListName>
  <ViewFields>
    <FieldRef Name="Employee_x0020_Number" />
    <FieldRef Name="Title" />
    <FieldRef Name="Department" />
    <FieldRef Name="Category" />
    <FieldRef Name="Time_x0020_Spent" />
    <FieldRef Name="INT_x0020_Time_x0020_Spent" />
    <FieldRef Name="Severity_x0020_Level" />
    <FieldRef Name="Ticket_x0020_Source" />

is it possible datacenter (kilimanjaro) to standard edition downgrade

  

Hi 

presently my database on sqlserver r2 datacenter (kilimanjaro) edition.

can i down grade to standard edition. presently data center working fine with replication.

 


SharePoint 2010 Standard Edition - scalability

  

Hello SharePoint people!

We are currently considering whether or not to go with SharePoint 2010 Standard or Enterprise Edition.

We are leaning toward standard edition but wanted to confirm whether or not there are any scalability issues associated with this version.

I have found various articles online that make reference to scalability limitations, but nothing concrete. Examples as follows:

"Enterprise Edition -- Similar to standard edition, presumably with more scalability and management functions."

" Standard Edition ... will be artificially throttled around content size."

I have already viewed various version comparisons such as this one without any luck.

Could anyone shed some light on whether there are any scalability limitations imposed on SharePoint 2010 Standard, in comparison to Enterprise?

Many thanks in advance.


Benjamin Athawes
Twitter

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