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

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

Named set stopped working in 2008 R2 / working in non-R2

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

this code was perfectly working in non-R2:

/* Proforma population */
 AS OpeningPeriod([Date].[Date Hierarchy].[Month], 
    Ancestor(Tail(EXISTS([Date].[Date Hierarchy].[Month].Members,[Dataset].[Dataset].[Actual] ,'Financial Account Measures')).Item(0), [Date].[Date Hierarchy].[Year])):
    Tail(EXISTS([Date].[Date Hierarchy].[Month].Members,[Dataset].[Dataset].[Actual] ,'Financial Account Measures')).Item(0);  

  [Relative Dates].[Relative Dates].[Proforma]
  SCOPE ([Date].[Month].[Month].Members, [Dataset].[Dataset].[Dataset].Members);     
    this = null;      -- zero out all months
  END SCOPE;     
  -- set actual from first month of current year to current period
    SCOPE ([Dataset].[Dataset].[Actual]);     
      this = ([Dataset].[Dataset].[Actual], [Relative Dates].[Rela

View Complete Post

More Related Resource Links

Suite Integration Toolkit executable has stopped working On Windows 2008 R2

I am not sure what else I can say about this except I seem to run into this error each time I attempt to install any .NET Related tool above 1.1. I have tried clean out all .NET installs to reinstall but I run up against this and at this point, I have a machine that is clean of .NET 2.0 through 4.0. I am unable to reinstall because I keep running up against this problem. I am not certain where to go from here Problem signature:   Problem Event Name: APPCRASH   Application Name: setup.exe_Microsoft® Visual Studio® 2008   Application Version: 9.0.30729.1   Application Timestamp: 488f1f5c   Fault Module Name: urlmon.dll   Fault Module Version: 8.0.7600.16385   Fault Module Timestamp: 4a5bdf64   Exception Code: 80000003   Exception Offset: 0008b5df   OS Version: 6.1.7600.   Locale ID: 1033   Additional Information 1: 3da0   Additional Information 2: 3da0da3513034f247aa571ff6433c6a8   Additional Information 3: efee   Additional Information 4: efee7faa0523fea9d1582687f878296e Read our privacy statement online:   http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409 If the online privacy statement is not available, please read our privacy statement offline:   C:\Windows\system32\en-US\erofflps.txtN

SQL Server 2008 R2 Setup has stopped working


Hi, I have a server with Windows Server 2008 R2 Standard Edition English and when I try to install SQL Server 2008 R2 Standard Spanish the installer give to me:

"SQL Server 2008 R2 Setup has stopped working
A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available."

Previously I changed the Current Format in Regional and Language Options to Spanish to solve a problem with OS Local. The mentioned error appears during the step of install the Setup Support Files, the step stop and show me the error with a "Close program" button, after press the button the installation finish. Thanks in advance.

DELL PowerEdge T710
2 Intel Xeon CPU E5502 1.87GHz

Windows Server 2008 R2 Standard 64bit ENU (english)
SQL Server 2008 R2 Standard 64bit ESN (spanish)

Not working on Windows Server 2008




I had the CSS friendly adapters working great on our old server (windows server 2003 - 32bit) and now we have moved to a 64 bit environment and now I can not get the CSS friendly adapters to work.

We are using SharePoint 2007.

Is there another work thru for 64bit environment.

I notice windows server 2008 has a directory  C:\Windows\Microsoft.NET\Framework64 would I be using the browser file in this directory???

Please help!

Indexing services on window server 2008 is not working with .net

Hi, I am useing Microsoft indexing services in windows 2008 64 bit .I am getting error like "Exception from HRESULT: 0xC0000005" while i am createing  new catlog from .net 2.0.I am using  "ciodm.dll" for adding new catlog. i am using this code for create new catelog.   Dim Admin As New CIODMLib.AdminIndexServer   Admin.AddCatalog(varContractNo, txtCatelog.Text + "\" + varContractNo) Admin.Stop() Admin.Start() AddScope(txtDocFolderPath.Text, txtSite.Text, txtCatelogname.Text)   Please help me anybody have fixed this issue on window server 2008 64 bit.  

FTP Task working in XP but not working in Windows 7/2008 machines

Hey , A FTP Task in IS pkg is working fine when executed through BIDS in my Win XP machine ..but the same package is not working in Win 7/2008 machine. FTP task fails with the error : [FTP Task] Error: Unable to connect to FTP server using "FTPFolder.TempData.com". Here are few facts about my troubleshooting : 1) From my XP machine... I am able to connect to the FTP Server using DOS Cmds but fails in 2008 machine saying "Unknown host" I did : Run>Cmd>FTP>Open FTPFolder.TempData.com 2) I can view the files on the FTP server through a browser ( URL was given )on both the machines with no issues. 3) I created Port exception for 20 & 21 Ports for 2008 machine ...still no luck. 4) When I PING the FTP server --Cmd>PING FTPFolder.TempData.com On XP Machine...though FTP Server Name is resolved to IP... I still receive "Request timed out." On 2008 Machine ...the IP is not even resolved and error is thrown "Ping request could not find host FTPFolder.TempData.com. Please check the name and try again." 5) I am connecting to FTP Server from my Office machines. I have searched all the threads on this FTP error topic and haven't found the apt thread..so I have opened a new one.

Executing a job from a stored procedure stopped working

I've got a stored procedure in database A that calls the sp_start_job stored procedure in msdb as follows:   CREATE PROCEDURE xxxxx WITH EXECUTE AS 'domain\username'   AS   EXEC msdb.dbo.sp_start_job B'jobname' ;   RETURN   The domain\username is the in the database sysadmin role and the owner of the job.  To make this work originally, I had to change the msdb database to be trusted.   This worked for the past several months.   Now it doesn't work (perhaps after a reboot but not sure).  The error I get is "The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'   I looked to make sure that the account had grant execute rights and it does.  I tried setting it via GRANT statement and it was granted successfully yet the error still occurs.  I've tried changing accounts and anything else I can think of to no avail.   Any ideas how to troubleshoot this issue.  I've tried all the tricks I can think of.   Thanks - SM

Data Collection in SQL 2008 not working

I am trying to use “Data Collection” feature in SQL 2008. I created it but I am not able to see any report. I am getting blank report. I saw all the jobs related to Data collection are failing and throwing following error:-     The step did not generate any output.  Process Exit Code 4.  The step failed. Any idea what needs to be done? This is SQL Server 2008 64 bits.   Thanks Saumen 

2005 proc not working in 2008

following proc works in 2005, and fails in 2008 returning "Msg 207, Level 16, State 1, Invalid column name 'xxx' " message.  Anyone have any ideas? The proc alters an existing proc in another db to return a different value: existing proc: /******************************************************* USE [tstDB] GO CREATE PROCEDURE [dbo].[sp_GetName] AS SELECT "aaa" AS strDescription GO /******************************************************* proc to alter return value: /******************************************************* USE [srcDB] GO Drop Procedure up_chg_name go Create Procedure up_chg_name (@chgName varchar(20),@db varchar(100)) AS Declare @ls_sql nvarchar(255) set @ls_sql='USE '+@db+' EXECUTE ('' ALTER PROCEDURE dbo.sp_GetName AS SELECT "'+@chgName+'" AS strName '')' exec(@ls_sql) GO /******************************************************* execute the altering proc: /******************************************************* USE [srcDB] GO exec up_chg_name @chgName=xxx',@db='tstDB' go /******************************************************* this fails with: "Msg 207, Level 16, State 1, Invalid column name 'xxx' message" - any ideas? Thanks  

WSDL not working for SQL Reporting Services 2008

I have seutp reporting services successfully, but now i want to generate a proxy to be able to interact progromatically with the reporting services 2008 like I did in 2000 and 2005.  I have tried viewing the WSDL from a command like this:   http://localhost/reportserver/reportservice.asmx?WSDL and I get an error like this:   The path of the item 'WSDL' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath) Get Online Help Any thoughts?  I also tried from WSDL.exe, no dice. Thanksl Ben

Breakpoints stopped working during debugging in vs.net 2005

I had the strangest bug yesterday while trying to debug in vs.net 2005.... I had an '05 web application.  I clicked the "Run" button to start debugging, and the webpage popped up fine.  I could run through the pages fine.  Everything seemed fine....UNTIL!   Until I tried to start inserting breakpoints into my code.  The application ignored them.  In addition, I noticed my little green visual studio "Start Debugging" arrow (which is normally greyed out while in debug mode) was green.  It was as if visual studio completely detached itself from my website I was trying to debug. After playing around with it for a while, I realized I also had a vs.net 2008 solution open as well.  My '08 solution wasn't in debug mode or anything, it was just sitting there open.  I just happened to close it, not thinking anything of it, and presto!  My 2005 debugger started working again! So basically, I can't debug an '05 solution (or at least a web solution, as that's all I tried) while I also have an '08 solution open.  Anyone know why?  Is there anything I can do to prevent this?   Thanks.  

how to make working WPF 2010 program make changes to SQL Server 2008 Express files

(1) I have a working WPF 2010 program that manipulates a table in SQL Server 2008 Express (2) the program does delete, update, select and insert correctly however in its own project file folder logbooklmk.mdf   logbooklmk_log.ldf (3) I want the actual SQL Server 2008 express files to be changed yes I know the issue is sharing and the copy option only applies to the local project files. I found this out by trying always copy, never copy and copy if newer. I probably have to change the .xsd folder to refer to the actual SQL Server 2008 Express file. Tried that once and it failed. Something about sharing not allowed.

webserver40.exe has stopped working

I've just upgraded a visual studio.net 2003 project (asp.net 1.1) to visual studio.net 2010 (asp.net 4.0). I'm encountering a problem with viewing Crystal reports. I'm using Visual Studio Development Server as a Web Server. When I try to create a new report (via code that worked fine previously) the line below causes the webserver40.exe to crash. Protected WithEvents MyRep As New CrystalDecisions.CrystalReports.Engine.ReportDocument I've got Crystal Reports 11 installed. Thanks in advance for your help with this matter. Lee    


Hi Folks, I downloaded SQL 2008 and installed recently.Everything perfectly works except one thing that I can't use VARCHAR AND CHAR data types anymore.I was using SQL 2005 and I had the same problem there as well. Please helpe to solve this problem

Katmai SSMS - Intellisense stopped working

HiI was wondering if anyone has had a similar problem. I have been happily using the Intellisense features of Katmai without any problems for a month now. However, a couple of days ago, it stopped working. I have tried numerous things to revive it including deleting everything under: -%appdata%\Microsoft\Microsoft SQL Server%userprofile%\Local Settings\Application Data\Microsoft\Microsoft SQL ServerHKCU\Software\Microsoft\Microsoft SQL Serverand restarting SMSS but I had no success. Tbh, I am not even sure where Intellisense cache is kept?Anyone have any suggestions?Thanks in advance.Blair

CLR stored procedures asssemblies working in sql server 2005 but giving issues over sql server 2008

Hi I developed CLR stored procedures assemblies using VS2005 and deployed in sql server 2005 are working fine. Currently we are migrating to sql server 2008. The same CLR assemblies are not working in 2008 version and raising following error. Here i created CLR assemblies in sql server 2008 using 'sa' user account which is having db_owner permission over 'mydatabase'. I am getting an error message like "A .NET Framework error occurred during execution of user-defined routine or aggregate". In sql logs showing messages like as -- Common language runtime (CLR) functionality initialized using CLR version v2.0.50727 from C:\Windows\Microsoft.NET\Framework\v2.0.50727\. -- AppDomain 2 (mydatabase.dbo[runtime].1) created.   Please let me know what may be the cause for this type of issues. Is there any specific backward compatibility settings has to be done over sql server 2008 or sql server 2008 R2 while using 2005 CLR routines?   Thanks in advance.  

query with locks not working in sql server 2008

I have a select query with join on some view and locks as (readpas,updlock) after executiong this query it executes the same query with little modification( no locks etc). This sequence of query executes fine in SQL server 2000/2005.   When I am executing same seq in sql server 2008 through application, I am getting timeout for second query. Can someone please suggest what can be the reason? I cannot post the query.Cheers!!! Vatsa

SSIS Debug Host has stopped working

The error code that's output with the SSIS Debug Host has stopped working popup is: Problem signature:   Problem Event Name:    APPCRASH   Application Name:    DtsDebugHost.exe   Application Version:    2007.100.1600.22   Application Timestamp:    48753d31   Fault Module Name:    StackHash_23cc   Fault Module Version:    6.1.7600.16559   Fault Module Timestamp:    4ba9b21e   Exception Code:    c0000374   Exception Offset:    000c2913   OS Version:    6.1.7600.   Locale ID:    1033   Additional Information 1:    23cc   Additional Information 2:    23cc9330c2de3c407e38eb60a3c201e4   Additional Information 3:    10bd   Additional Information 4:    10bdb3132e81c1ecfd041615b784b3fd In the output for the BIDS debugger: SSIS package "Package.dtsx" starting. Information: 0x4004300A at Sg Clients to NewCP stgClients, SSIS.Pipeline: Validation phase is beginning. Warning: 0x80049304 at Sg Clients to NewCP stgClients, SSIS.Pipeline: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available.  To
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