Answer Questions

• TA123 Error rsAccessDenied

  When I try to deploy one of my Reports I receive the following error : Deploying to http://localhost/ReportServer Error rsAccessDenied : The permissions granted to user 'BOGDAN\IUSR_BOGDAN' are insufficient for performing this operation.   That is because I configured IIS for those 2 folders ReportServer and Reports to accept anonymous . If I turn anonymous off and let windows authentification on he lets me to deploy the project , but I can see anymore http://localhost/Reports and http://localhost/ReportServer because he asks for password and I don't have any password set for the computer , nor for SQL Server . I just use Windows Authentification for all.  I searched through this forum but nothing is significant ...Show All

• MusicMan2006 Loosing database connection when device power-off (native oledb code)

  Hi, I experienced this problems on both Windows Mobile 2003 SE and Windows Mobile 5.0. Its native development (c++, oledb, atl and mfc). It's quite simple to reproduce... 1. open a database 2. open a rowset on table A (whatever, valid of course and with both IOpenRowset and ICommandText), read datas and close rowset 3. power off 4. power on 5. try step 2 with another table (failed on openrowset with error 0x80004005) or try table A (sometimes working because of cached memory, sometims failed on Read Datas). 6. being stuck ;-) Our work-around was, in case we loose our connection (identified by error 0x80004005 on openrowset), we close it and re-open database... ugly for sure, but working. What ...Show All

• Ovidiu Padurean replace out of range dates

  Hi, I'm migrating data from access 2003 to sql server 2005. An access table contains dates like 5/1/0999. This is a date that is out of the datetime range from sql server. Now my question is ... How do I replace these dates I don't find something like IsDate in the expressions Ok I did it with a Derived Column task. It replaces the date column values who have out of range dates. (It only checks for dates smaller then 1/1/1753) The expression is like this: [DateToCheck] < (DT_DATE)"1753-1-1" (DT_DATE)"1753-1-1" : [DateToCheck] ...Show All

• dragoncells What user is performing this code

  Hello, on one of the discussions i've foudn this code Private m_headerImage As Object Public Function GetHeaderImage() As object ' be sure to add appropriate error handling If m_headerImage = Nothing Then Dim adapter as new System.Data.SqlClient.SqlDataAdapter("Select ThumbnailPhoto From Production.Productphoto", "Data Source=localhost; Initial Catalog=AdventureWorks; Integrated Security=SSPI;" ) Dim ds as new System.Data.DataSet() adapter.Fill(ds) m_headerImage = ds.Tables(0).Rows(0)(0) End If Return m_headerImage End Function and then this code is called by a =Code.GetHeaderImage() at then image value property. In the Print preview from the devStudio it works, when publishing and running the repor ...Show All

• drdexter33 Comments on configuring partitions

  Hello, I'm currently building partitions into my cube. My scenario is thus: I have 74 measure groups (yeah I know - it sounds ridiculous but trust me, it IS valid) Each measure group is to be partitioned by year We are (currently) going to partition them over 12 years In other words I have to build 74*12 = 888 partitions Quite apart from the fact that its going to take most of my working week (and it'll be the most boring working week of my life) there is huge potential for human error here. As stated above I am applying the same partitioning strategy for each of my 74 measure groups so I am repeating the same basic steps 74 times. It occurs to me that there MUST be a better way and if there isn't - there should ...Show All

• prodonjs SQL Reports Not Showing the Proper Results

  Posted - 07/25/2006 : 12:54:35 Hi Thaks alot for response this probably can b the reason. Can you please tell me where can i check that wether we are using cache mode or not Thanks Nee123 ARe you using the cache mode for your reports It could be that in the meantime of executing the first row was already inserted while the second wasn’t. After taking the data to cache the second row was inserted and therefore the report was invalidated after the time that you mentioned. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de ---- Hi, navigate to the report > Properties > (SomeOtherOptions, something like execution) and there you wil ...Show All

• progames25 Wrong totals in named sets

  Hi In BI Development Studio I create a name set with this sintax: [CATALOGO].[CATALOGONIVEL3].[Tiempo Mantencion] [CATALOGO].[CATALOGONIVEL3] has another two members instead of [Tiempo Mantencion] After that I create a calculated member with this SUM ([SET Tiempo Mantencion] , [Measures].[HORAS JUSTIFICADAS]) It works fine in almost all cells in the cube, but when I ask for the others two members of [CATALOGO].[CATALOGONIVEL3] it does NOT returns NULL it returns the same total of [CATALOGO].[CATALOGONIVEL3].[Tiempo Mantencion]. When I open one this members (it exists a sub level named [CATALOGO].[CATALOGONIVEL4]) the cube show a null cell in the subitems (thats right) and the [CATALOGO].[CATALOGONIVEL3].[Tiempo Mante ...Show All

• Kryor How SQL 2005 Execute a sp in master db when called from other db?

  In previous SQL server version, if I create stored procedure sp_XXXXX in master database, then call it from other database (session context is other than master) with master..sp_XXXXX. SQL server will execute the sp with the environment from where it was called. However, in SQL 2005, if I call it with "master..sp_XXXXX", SQL 2005 will switch the context to master database and execute the sp in master database environment. I wonder if I did something wrong or that is the way SQL 2005 execute the sp. If this is the way SQL 2005 does business, then, how to exec a sp in master database with local environment Thank you for any help.   It was "likely" to go away in 2005, bu ...Show All

• Naolin New Diagnostic Logging Entries in SP2 CTP?

  Hello all- I installed SP2 CTP yesterday, and in the course of my testing ran one of my SSIS ETL jobs. I routinely log to database, and have a report designed so that I can easliy monitor the job performance, errors, etc. However, when running on SP2, there seems to be new Diagnostic entries that are logged, so much so that my 6 page report of events has now exploded into 337 pages. I have included a sample of the entries: 19838 2:13 AM ExternalRequest_post: 'ITransactionJoin::JoinTransaction succeeded'. The external request has completed. Data Mart Execution Logs User:Diagnostic Is anyone else experiencing this Did I miss a kb article I have looked around, and I find nothing. ...Show All

• hitparader Infinitive recursion for my AS2000 calculated member

  Hi, Can someone please help me on this. I get following error when I browse my virtual AS2000 cube: <Infinite recursion detected during execution of calculated member Sum({Descendants....> I have implemented a 'dummy' utility dimension with one calculated member: (I have used a parentchild dimension because that's only way I know how to get the formula a from source view): -- view [dbo].[vdimUtilityCalculation] as select 'CalculationID' = 1, 'ParentID' = 1, 'CalculationName' = 'Currency', 'Formula' = 'Sum({Descendants([Period].[Quarter].CurrentMember, [Month])},IIF([Currency].CurrentMember.Properties("Fixed") = "1", [Amount Fixr], [Amount Flor]) * ValidMeasure([Rate]))', 'MemberOption' = 'SOLVE ...Show All

• corblet Can I have multiple tables to gather event data

  Hi Guys, Wondering if I could have two tables with parent child relationship to gather event data. Does NS support such scenario while defining schema in ADF.xml. Please advice. Thanks, Shamir Ahhh...gotcha. A couple of options come to mind. First you can flatten out the rows into multiple events. In this scenario, you'd have one event row per transaction detail and that row would include information from table 1 and table 2. You'd want to then use the digest delivery to pull it all together into one notification. However, under certain circumstances, I could see how this may lead to an occassional mishap where a user would receive more than one notification, each being somewhat incomplete ...Show All

• Jamie Thomson OpenRowSet and OpenDataSource Fail on Production to open Excel data

  The following statement fails when using SQL Analyzer under sa but works on all of our development and staging server. All are SQL Server 2005 SP1. We upgraded production over the weekend from SQL Server 2000, creating a new instance machinename\SQL2005. SELECT * FROM OPENROWSET ( 'Microsoft.Jet.OLEDB.4.0' , 'Excel 8.0;Database=d:\data\test.xls' , 'SELECT * FROM [Sheet1$]' ) The error we are getting only in prodcution is: OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server &q ...Show All

• Damian Otway Error creating new SSIS project

  When I start a new project the BI environment cannot open the DTSX package and I get only one tab with the message: "microsoft visual studio is unable to load this document. Object reference not set to an instance of an object". I tried uninstall and install of BI Development Studio as well as a repair install of Visual Studio 2005. None of which helped. Please help me to get this fixed. Kind regards, Neeva Just to let you know, this problem seemed to have disappeared when I had to install SQL Server Express for a completely unrelated reason. I still don't understand it, but oh well.. ...Show All

• Paul Gerald Snapshot is not available

  Dear friends I am a new fellow to replication.What is the problem I am getting is I am not able to create snapShot.Whenever I start Snapshot Agent it is going for half an hour and it will stuck in the case of one view saying like that 'failed to process bulk copy of data from dbo.syncobj_03x666*'.If I am publishing tables only then also I am getting same error.This view created by system.In my case publiher only working as a distributor.I created a SQL username which have access in subscriber & Publisher.Preferably I will be happy if someone suggest what and all are the primary criterias we have to keep in mind while doing Replication Thanks in Advance ...Show All

• Flame Sword8 For-Loop and Failed Items

  All, I am currently in the middle of writing a package that needs to loop round a record set and extract data from various source DB's in a common format. The inner package is a simple data pump that relies on a dynamic OLEDB connection being set at run time via a variable in the outer package. This works wonderfully, providing the value in the outer package points to a verifiable data source. However, If I make the data source invalid the execution status stops, In DTS 2000 this was simple to overcome with an Active X script, as you would set the package status to waiting and loop back to the next record. Waht i need to know is the object and property/method that will do this in SSIS, I've looked through BOL and theres ...Show All