Marcos B's Q&A profile
SQL Server excel 2007 and measuregroup names
Hi, we want to use excel 2007 as front end - is there a way to hide the measure group names from the excel pivot table (because this is something technically and does not help business users - its more confusing) I want to only have the values with all measures and the regular display folders The only way I can think of is hiding the measures and create calculated once referncing the original physical measure. If we do this it works fine, but the measuregroup name is still displayed in the "is related to list" but does not appear in the pivot table. (so its less important) Is there a more comfortable way (SQL 2005 CTP SP2 3033) HANNES ...Show All
Software Development for Windows Vista How to assign task to user via rules and rulesets
Hello, I have a sequential workflow that uses custom activities and a custom tracking service to generate task lists. End users will monitor for and work their assigned tasks. Question - how to initially set the "Assigned To" on the task or custom activity at runtime based on workflow parameters or other app domain data, and the current task. Requirements Prefer to use rule sets / policies to stick with declarative model and allow on the fly changes to work flow instances. Possible Solutions Place a Policy Activity just before each custom "TaskGenerator" activity in the workflow...add rule(s) to determine initial assignee on the corresponding custom "TaskGenerator" activity. This seems aw ...Show All
SQL Server Applying SQL 2005 SP1 to a local copy of Workstation Components
I have installed the Workstation components on my local PC, which also contains VS 2005 and SQL Express. I installed the WS components so that I could run the full blown version of SQL Management Studio from my PC, to remove SQL 2005 servers. I tried to update the Workstation components to SP1, but the SP1 package stops at the Setup Support Files, step and terminates claiming the package does not support SQL Express. I realize the package is not intended for Express, I simply need to update Management studio. I tried running the Post SP1 Tools hotfix and it complains that it will not update SP0 of the tools. I have successfully updated Express to SP1 and applied the Post hotfixes as well. Is there any way to patch just Management studio on ...Show All
SQL Server The 'CEO' source attribute ID of the 'CEO' level does not correspond to an existing attribute in the dimension.
i am getting following error while executing the MDX query shown at the end: Errors in the metadata manager. The 'CEO' source attribute ID of the 'CEO' level does not correspond to an existing attribute in the dimension. Any pointers to what could be the reason for this errors, and the solution to this problem Thanks, Santosh. CREATE GLOBAL CUBE ...Show All
SQL Server question mark sent instead of parameter value
When I add a parameter to a query against view that points to a linked server table, the query fails. The Where clause IN THE ERROR MESSAGE looks like this: WHERE "Tbl1001"."F0000">= " The actual SQL is: WHERE (F00000 >= @Year) The question mark should be 2005, but the replacement dosen't occur. The actual SQL is constructed that way: SELECT F03401 AS [Billing Atty Name], F00501 AS [Client Name], F00500 AS [Client Number], F00000 AS YEAR, F05001 AS [Working Atty Name], F05003 AS WALastName, SUM(F15000) AS [MONTHLY BILLABLE HOURS], SUM(F15040) AS [MONTHLY BILLABLE VALUE], SUM(F15010) AS [MONTHLY NON-BILLABLE HOURS], SUM(F15050) AS [MONTHLY NON-BILLABLE VALUE] FROM ZCL ...Show All
SQL Server ASCMD executing multiple MDX commands in one batch file
Has anyone got an example of ASCMD executing multiple MDX commands in one batch file Or are we restricted to one MDX command only We haven't been able to use multiple commands. The doc at http://msdn2.microsoft.com/en-us/library/ms186692.aspx states that you can have multiple xmla commands. < Command > < Batch Transaction="Boolean" ProcessAffectedObjects="Boolean" > < Bindings > ... </ Bindings > < DataSource > ... </ DataSource > < DataSourceView > ... </ DataSourceView > < ErrorConfiguration > ... </ ErrorConfiguration > < Parallel > ... </ Parallel > <!-- One or more XMLA commands --> ...Show All
Game Technologies: DirectX, XNA, XACT, etc. How do I load a 3d mesh (.x file)?
How do I load a .x mesh into my scene The space game seems to use its own format (which it names .swm), and there's nothing in the help. I've been scanning through through the classes in the Framework namespace, but I can't see anything obvious! Is .x the recommended format for objects like this (If not, I change my question to be about the recommended format :D) If anyone knows anywhere that has some nice .x meshes I can play with, that'd be cool too. The only one I have lying around is a chair, and that's going to look a bit funny running around my game :D Zumwalt wrote: So basically what you are telling everyone is don't bother with the SDK at the moment because it is pre-alpha still an ...Show All
SQL Server RS 2005 Prompting for Credentials
For the life of me, I can not get integrated windows authentication to work with an installation of Reporting Services 2005. I get prompted when connecting to the /Reports IIS virtual directory when not on the IIS machine. If I'm logged onto the machine I don't get prompted. Or if i use the IIS servers IP address in the URL I don't get prompted. The only way I can avoid windows prompting (when not logged onto the IIS machine) is to set the /Reports virtual directroy to "Enable Anonymous Access" I know Windows Integrated authentication works because we have other web applications where Anonymous access is turned off, and everything works as expected. Meaning going to another server for database access thos ...Show All
Windows Forms CGI Error
Good Afternoon; I developed an application in VS 2005 (VB.Net ) - After publishing, when the user tries to install the application from the install page, receives: 'CGI Error' 'The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are' My users recently had their PCs upgraded, and I'll hazard a guess that the .Net 2.0 Framework is not installed on their machines. Anyone else have the same error message Thanks. Mike All, The .Net 2.0 Framework needed installed on their PCs. Which has been completed. But, I have another issue. All new PCs in my organization will be distributed with Proventia software install ...Show All
SQL Server Reports exported as Excel cannot be read by Mac version of Excel
I searched the list but did not see anything related. I cannot open a file directly exported from RS in the Excel format. If I open the file in the Windows version and then close it, no need to even save it, I can then open it with the Mac version of Excel. The file size after closing is about 2K less so the RS program is adding something onto the file that the Mac version does not like. It will crash Excel when trying to open. I cannot export the report as CSV as it will not correctly import into Excel on the Mac. Is there a work around for this Thanks. --sean I am also having this problem with users trying to open the xlm file created from RS and using a MAC. Please let us know what is causing this pro ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Calculating Matrix.CreateTranslation(x,y,z) manually?
This is more of a universal HLSL-related question, but, given a set of coordinates, how is Matrix.CreateTranslation (or Matrix.Translation for DirectX) calculated, in general terms I need this to see if I can get some simple shadow effects working in 3ds Max, which doesn't allow me to send a WorldViewProjection for a spot light unless it's the active viewport (to my knowledge, if you happen to know how I can get the WorldViewProjection [I can already get the View and Projection with frustrum]. then let me know and it'll solve my problem a lot faster) A translation matrix is very simple. It starts off with the identity matrix: (1, 0, 0, 0) (0, 1, 0, 0) (0, 0, 1, 0) (0, 0, 0, 1) But t ...Show All
.NET Development Using System.Transactions and Enterprise Library 2.0 (EntLib)
Hello, I'm trying to use System.Transactions combined w/ Entlib 2.0 and get a strange behaviour. My code looks something like this: void Foo(){ ... using ( TransactionScope scope = new TransactionScope ( TransactionScopeOption .Required )) { // Create DB sngDatabase = DatabaseFactory .CreateDatabase(); using ( SqlConnection connection = sngDatabase.CreateConnection() as SqlConnection ) { //Open the connection connection.Open(); using ( new Tracer ( LoggingCategory .Trace)) { // Call the DAL, to save the changes to the database SaveDataSet(runDefinitionDS); } } ... The problem is, that when I get to the using ( new Tracer ( LoggingCategory .Trace)) lin ...Show All
SQL Server Migration without backup-files *.dts
Hello All, I have to migrate SQL 2000 DTS-Packages to SQL 2005. My Problem is that I didn't saved my DTS-Packages as files and the SQL 2000 Server exist no longer. Actually I have only the old hard disk with the SQL 2000 databases. Do you have any ideas what can I do Thanks Jonas If using local server packages you can do this. Get the old msdb online, does not have to be called msdb though, just need to mount the DB somehow. Then rip the contents of the sysdtspackages table into a real msdb DB's sysdtspackages table. You can even use DTS or SSIS to do the data transfer or even just a INSERT ... SELECT if both DBs are on the same server. ...Show All
Software Development for Windows Vista Digital Identity Applet window cannot be opened
i have just installed the .net 3.0 June CTP.I used to have a ball with .net run time components with beta 2 esp with CardSpace now with June CTP i am getting the following error when Event Type: Error Event Source: Microsoft.InfoCards.Diagnostics 3.0.0.0 Event Category: System Event Event ID: 102 Date: 13/07/2006 Time: 04:55:29 User: NT AUTHORITY\SYSTEM Computer: xxxxxxxxx Description: Invoked FailFast Message: The InfoCard Service cannot be started on this file system. Stack Trace: at System.ServiceModel.Diagnostics.ExceptionUtility.TraceFailFast(String message, EventLogger logger) at System.ServiceModel.Diagnostics.ExceptionUtility.TraceFailFast(String message) at Microsoft.InfoCards.Diagnostics.DiagnosticUtility.FailF ...Show All
Visual Studio Express Editions An error about an error
Hi all, Sorry to bother you all yet again (I'll bet you're getting sick of me by now), but I have yet another odd question for you. When I run my program in debug mode (Press F5 in VB 2005), it comes up with an error message and highlights that exact piece of code. Here is the full block of code it picks up on, and the highlighted bit is both the error message it gives me, and the bit the debugger highlights. <System.Diagnostics.DebuggerNonUserCodeAttribute()> _ Public Property Signature_File() As Byte () Get Try Return CType ( Me ( Me .tableTime_In_Table.Signature_FileColumn), Byte ()) Catch e As System.InvalidCastException Throw New System.Data.StrongTypingException( "The value ...Show All