Answer Questions

• Lenny Garza scope and attribute relationships..

  I'm getting some results using a Scope command with some attributes that have attribute relationships, and i'm having problems understanding them. Here is the scope command i am using: SCOPE ( [Geographies].[ALIGN].&[ALT PC], [Measures].[SA - Cost], [Products].[Market Definition].&[Antibiotics Market]); this =0; back_color (this) = 12632256; END SCOPE; This works fine at the [Products].[Market Definition] level, but the scope does not work below this level.. This is the [Products].[Market Definition] level. SA - Cost Column Labels Row Labels Antibiotics Market Grand Total ALT PC 0 0 Grand Total 0 0 This is a level below [Products].[Market Definition] ...Show All

• CinoV 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

• Jim Altrichter Recursive Hierarchy

  I have the following agent’s structure on the agent table. 16 ---17 -----18 ---------19 --------------20 Where Agent 20 sold the product and he is under 19 and 19 is under 18 and 18 is under 17 and 17 is under 16. I need a function that allows me to enter agent 20 and it return agent 18 since 17 and 16 are not longer valid agents but they are still on the table. In the agent structure could be more than 5 levels. Thank you You could do something like: with AgentsCTE as ( select @AgentID as AgentID, cast(0 as bit) as Active union all select a.ParentAgentID, a.Active from Agents a join AgentsCTE c on a.AgentID = c.AgentID ) select * from AgentsCTE where Active = cast(1 as bit) So here we're popu ...Show All

• dnf999 Nesting stored procedure, how to ?

  Hello, I'm trying to use nested stored procedure but can't get it to work. I've created a stored procedure named 'sousmenu1_parents' which does a simple select, no parameter. here's what I'm trying to achieve now : CREATE PROCEDURE SelectAllDroitSpe -- Add the parameters for the stored procedure here @UserId int AS EXEC sousmenu1_parents ; BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON ; -- Insert statements for procedure here SELECT sousmenu1_parents . menu_id1 AS sousmenu1_id FROM authorisations_speciales LEFT JOIN sousmenu1_parents ON authorisations_speciales . page_id = sousmenu1_parent ...Show All

• Aadi1 More SSIS via the web

  Thanks to Michael Entin's help last week, I was able to execute a package via a .NET web application.  I have now moved my solution to the client's development server.  I can execute the packages via DTExecUI and DTExec, but my web application is failing.  The only difference between the two servers is the database server is installed on another box.  Will this be a problem Also, am I correct that the "Network Service" needs execute access to the DTSX package in IIS 6.0 Will package logging work via the web application Thanks. Clay An update on this... The packages are contining to run through DTExec and DTExecUI.  I have added a login to the remote database as Domain Name\ASP ...Show All

• dgolds Parent Package Variable issue?

  I have noticed an issue with parent package variables. I have a package with multiple parent package variables defined, call them X, Y, and Z. I also have a parent package that calls this other package. The parent package has variable definitions for X and Z. It seems that the value for X will be passed along, and Y will give a warning since there is no variable of that name in the parent. The issue is that Z will not be passed along. It seems like the parent package configuration process stops after it encounters one missing variable. Is this a know issue Is it by design Yep, I see the same thing. Look for a fix in SP3, perhaps. There is already a bug filed for this issue. https://connect.mic ...Show All

• Todd Virlee Use a custom "report is being generated" image?

  Is it possible to replace the spinning green loading circle with a custom image on the "Report is being generated" screen If so, how would I go about it Not in the current versions. In future versions, this may become an option. ...Show All

• GeertG Association Scenario

  Hi, I have a product basket scenario in where I have to recommend contracts to a customer based on the product and the quantity he/she buys. Product Quantity is an important factor which administers the user in the purchase of a particular contract I have the following tables with me. Customer product transaction table, Customer Contract transaction table but there is no direct relationship between contract and product in the database. The only way the two can be linked is through the customer. If I create a mining structure with Customer-Product information as the nested table and Customer-Contract information as the nested table with customer being the link between the two, the model is showing some irreverent contrac ...Show All

• Michael Hecht SQL Agent Error: unable to connect to sql server '(local)'. the step failed

  RE: Windows 2000 Enterprise Edition (SP4), SQL Server 2000 Enterprise Edition (SP3), default instance, stand alone server (not clustered or replicated) I have a SQLAgent job that runs weekly to purge data and rebuild the indexes. This job has been failing recently with the following error message: "unable to connect to sql server '(local)'. the step failed". This job is owned by sa and SQL Server is in Mixed mode. Has anyone else received this error If so, what is the cause/solution Any insight you may have with this issue will be greatly appreciated. Thanks. Thanks for your responses. I have found the problem and corrected it. Cause: A few weeks ago the database was renamed and the job wa ...Show All

• Gidon Sela VS pro install, SQL error

  Hi I signed up for the Empower program and have finally installed VS 2005 pro. I am first testing it out on a spare laptop, it has a fresh copy of xp sp2 and during install, I selected everything, however it says failed to install SQL express. I have tried several times to redo this through add/remove components however I get the same problem. In start > all programs, I have Microsoft SQL server group, so I really do not know what has happened. Also, from looking at the VS website, I was under the impression that sql server developers edition came with VS pro, and not the free express edition, so I am a little confused, unless this means that you just use the cd that came with the MSDN sub Also, I was under the impressio ...Show All

• DEEPAK GARG Weird conflicts - Merge Replication 2005 -> 2000

  Publisher is 2005 x64, subscribers SS2000 (SP3) and SS2005 x64. Pull agents, no filters on subscriptions. We are seeing many seemingly random conflicts on between SS2000 subscriber and publisher. It happens on several different tables. One table is never editted, only inserts happening everywhere and deletes happening on the SS2000 subscriber. Deletes will sometimes generate conflict. Reason is '"he row was deleted at 'CTS11.CTS' but could not be deleted at 'cts4a.cts'. Unable to synchronize the row because the row was updated by a different process outside of replication." CTS11 is SS2000 subscriber, CTS4A is publisher. Probably unrelated bug but when looking at conflicts on this same table in SS2005 conflict viewer, get e ...Show All

• Anna Vanyukova SP2 Integration mode kills Sharepoint Central Administration

  Hi I had the following setup: Farm Server 1 * Sharepoint 2007 full install Farm Server 2 * SQL Server 2005 I installed the following: * SP2 for SQL Server 2005 on Server 2 * Web-front end install of Sharepoint 2007 on Server 2 - to install the object model * SSRS2005 reporting services add-in for Sharepoint technologies on Server 2 Since doing that, I can no longer get to central administration on Server 1 - I now get the following error when navigating to central admin: Server Error in '/' Application. I noticed I installed the add-in on the wrong server. After installing it on the Sharepoint server, the Sharepoint central admin works, but the "Set Server Defaults" link under Reporting Services errors out as per this thre ...Show All

• David S. Anderson DTExec and Pasword Prompting

  A colleague of mine is having problems when trying to schedule package execution via a .bat file that executes a .dtsx on a sql server (not file system). The scheduling system that is employed by the company requires a .bat file to execute the package. The packages themselves move data from AS400 servers to SQL Servers. Occasionally (very randomly) when the scheduling system runs the statement in the bat files, the package prompts for password information (for connectivity). We've tried a number of solutions to this, mostly on the "ProtectionLevel" property of the package itself. We did some research and it seems as though there are a few options.What is the best solution to eliminate this from happening We certainly don't wa ...Show All

• anderskj1 Unary Operator Column in Accounts Dimension Behavior

  I set up a cube with 4 dimensions: Time Account Department Project and 1 measure Amount Without adding the unary operator to the Accounts Dimension, I am able to drag Project to be rows and Amount to be column to break up the amount by project. Once I added the unary operator column to the heirarchy in the Accounts Dimension, I have to drag the Accounts Dimension first, followed by Project to see any breakdown at all. I couldn't do Project, then Accounts. Is this the expected behavior Using + unary operator did not resolve the error I am getting. The results appear correctly when I have a custom member aggregation formula defined. Otherwise it does not return the correct res ...Show All

• DC Ross sql server express loses ability to write to database

  After a period of use (typically 1-2 hours), an application using SQL Server Express stops writing to the database, whilst still continuing to read from it. As far as I can tell, no error message is generated by any operation. The application is written in VB Express and is executed on several machines, with SQL Server Express on a central machine. Re-starting the application on the affected machine restores normal operation. The problem on one machine does not cause a similar problem elsewhere at the same time (hence it appears to be an issue with the relationship between the application and SQL Server) This does not appear to relate to the response to Q asked by sgcook on 9 may as we are not using user instances, but only a ...Show All