KitGreen's Q&A profile

• SQL Server SSAS 2005. x86. Memory Allocation Errors during processing.

  I have an AS2005 on x86 Box with 4Gb RAM with 2 Xeons 2,2Ghz. On the same box runs SQL Server - the data source for AS. If the cube is processed, i can't reprocess indexes and aggregation after dimensions update. I get permanent memory allocation error. The cube size is funny - only 3Mio rows in 13 artitions. Only thing what runs is to make cube unprocessed and full reprocess it. But it brokes one of the businnes requirements, that users can always query the cube with simple queries, though with 10% of performance. Hi Irina. what is difference between " large attribute" and "attribute with a lot of members" Are things the same Yes I have some of them (ca. 3 dimensions with more the 1. ...Show All

• Visual C++ Using DateTime in a Console Application

  Sorry, I haven't seen that its not a .NET application. Right click on file in wich you want to use clr in native project. Select properties. Select C/C++ node. General: Debug information format: /Z i Compile with common languge runtime:/clr Code Generation: Enable minimal rebuild: No Basic Runtime Checks: Default. Prcompiled Headers: Create/Use precompiled Header: Not Using Precompiled Header. do not forget: using namespace System; Or you can, Press Add new Item, Then select Code>Component Class. Enter a name. clear .h file and .cpp file. and write new fill of class like this: c1.h #pragma once using namespace System; extern void Test ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Any books coming out ?

  First off, I thin XNA is an amazing idea, I love the idea of bringing back the bedroom coder mentality! However, I've got a fair amount of experience of using Visual Web Developer Express with vb.net and I have to admit I have no idea where to start with XNA express. Just tried messing with the space war demo a bit but really can't work out how everything fits together. So, I was wondering if anyone like Wrox or 'for dummies' are going to be producing a book on the subject for beginners I know it's early days but authore often work closely with developers of a new language and have one out pretty early. Several publishers are working on this, but I doubt you will see anything before final release. For very ...Show All

• Visual Studio Team System Postbuild and prebuild scripts

  I am using the newly released CTP 5 and have been trying to use the postbuild scripts and prebuild scripts to add certificates as well as permissions for a database. However, when I try to deploy the project I get an error saying that it can't find a procedure when trying to assign the permissions and it looks like the postbuild scripts and prebuild scripts are being combined and run together, both before any of the other database scripts (tables, procedures, functions, etc.) are deployed. My question is there a better way to deploy the permissions for the database other then putting them in the postbuild script or is there a way to fix it so that the postbuild scripts is run only after the main database scripts are run ...Show All

• SQL Server how to show columns with two decimal places

  HI , I've table whose output is some coumns. The colums show 6 digits after decimal point . My problem is i want to show only two digits after decimal point .. How to do using query.. Thanks This may help you http://www.netomatix.com/development/GridViewDataFormatting.aspx More reading regarding the "DataFormatString" http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.boundfield.dataformatstring.aspx http://devauthority.com/blogs/sskokku/archive/2006/08/17/1962.aspx Gurpreet S.Gill ...Show All

• SQL Server How to store OR get Time value in a column

  How can i store the time value in a column. DateTime stores dd/mm/yyy hh:mm:ss , i want only hh:mm:ss , and i also may compare the the values. And also how can i get current time to a column value, something like getdate() MasterG wrote: How can i store the time value in a column. DateTime stores dd/mm/yyy hh:mm:ss , i want only hh:mm:ss , and i also may compare the the values. And also how can i get current time to a column value, something like getdate() Hi MasterG, You can use the following T-SQL to get hh:mm:ss from a datetime value; CONVERT(CHAR(8), GETDATE(), 108) To insert the time into a column, you could use; INSERT MyTable (TheTime) VALUES CONVERT(CHAR(8), GETDATE() ...Show All

• SQL Server SS2K5 - Jet OLEDB Error and a Linked Server to a text file

  Evening, I am trying to execute a stored procedure that dynamically builds a call using a linked server that attaches to a text file. Here is the error I receive: Msg 7357, Level 16, State 2, Line 2 Cannot process the object "select * from noise.enu". The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" indicates that either the object has no columns or the current user does not have permissions on that object. Thanks for any and all help! ...Show All

• Software Development for Windows Vista Having a problem of Vista XPSDrv filter to call an entry in other DLL

  I built a pass through filter(stream in and stream out) and it worked fine.  Then I tried calling an entry to one DLL built by VC8 or WDK.  But the filter failed to load.  The linker linked correctly.  I think it might be caused by incorrect building process of the DLL.  Can anyone give me some simple sample(codes, build file, environment) which works   Thanks. ...Show All

• Microsoft ISV Community Center Forums How to copy pivot table RESULT from Access to Excel

  I need to produce a highly formated pivot table report in Access and can only achieve so much. However, if I could programatically select the pivot table (equivalent of keys [Ctrl]+ ) then copy and paste into Excel, I can use VBA to format the report in Excel. My problem is that I cannot find a way to programatically select the pivot table in Access. I have tried Sendkeys "^A" as a last resort but this doesn't work. Exporting to Excel doesn't work either as it exports the pivot table, not the result . Try this. "str_spreadsheet_name" holds the name of a file that has already been exported and Excel is open and running. "obj_xls" then picks up the open spreadsheet. ...Show All

• Windows Forms TableAdapter Select Command

  Hi, I have a form  that shows room availabilty for a number of hotels. I'm using a tableadapter called AvailabilityTableAdapter to fill a datagrid view. Is it possible to change the select command of the tableadapter programaticly to a string that I create dynamically Thanks Mark I got really tired of people giving the wrong answers, or answers that do not work or are unclear, so here is the the step by step method using VB.NET 1) Right click on the dataset in Solution Explorer and select View Code. 2) Place the following code: Namespace myDataSetTableAdapters Partial Class myTableAdapter Public ReadOnly Property selectcommand() As System.Data.SqlClient.SqlCommand Get ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Anitaliasing when rendering to sprite

  I'm hoping someone can help me get antialising working in my game. I figured out that when rendering directly to the screen I can set antialiasing using these fields at the top of my render function. myDevice.RenderState.MultiSampleAntiAlias = true ; myDevice.PresentationParameters.MultiSampleType = MultiSample.SixteenSamples; myDevice.PresentationParameters.MultiSampleQuality = 8; I've been building a library though, where every asset has it's own render function, and the screen is rendered to a RenderTarget2D and displayed on a sprite, and I cannot for the life of me antialias the 3D objects in my screen. I tried setting these fields in the game render function, on the render functions of all the individual objects, on th ...Show All

• Software Development for Windows Vista Error in STS communication over HTTPS

  Hi, I'm trying to setup the Fabrikam example on Win2003 EE. I followed the instructions, run the setup and set the SSL cert with httpcfg. The site is OK and the STS compiled and running. When I try to run the sample and get the token from the STS using a managed card I get an error message in the CardSpace client saying that this error message: "Your data could not be retrieved from the managed card provider...." And the event viewer provides this info There was a failure making a WS-Trust exchange with an external application. The Identity provider end point was not found. Inner Exception: Metadata contains a reference that cannot be resolved: 'https://www.fabrikam.com:7001/sample/trust/selfissuedsaml/mex ...Show All

• .NET Development Need to merge 2 tables in Dataset and only get the matching accounts in one table?

  I have a dataset with a account table and another table that contains transactions for accounts in the account table. I create a crystal report based off an inner join query of the two tables but takes way too long to generate. I was told if I can get them into one table that would fix my speed issue. I'm thinking if there is some way to maybe create a merged table of the two together and only getting data from both tables where the Account# field matchup Any help or ideas would be great! Hi, What do you want exactly A SQL query to obtain the data in a single table or to merge 2 DataTables in C# or VB From your description it sounds like the Accounts and Transactions have a one-to-many relationship. I guess your report is as follow ...Show All

• Visual Studio Express Editions Update

  Hi everyone I have built an application that is published via vb 2005 x and I connected the .mdf file to sql express 2005 but the infoemation in my application will not show in sql 2005x. I try to check the check box in the edit datasource with designer but the check box will not retain the check in the check box. Anyone have any ideas Thank you in advance. David (newb) Public Class Form1 Private Sub SYSIDBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Me.Validate() Me.SYSIDBindingSource.EndEdit() Me.SYSIDTableAdapter.Update(Me.PcDataSet1.SYSID) End Sub Sub CreateDataSet() Dim ds As New DataSet AddTable(ds) ' ' The message box displ ...Show All

• SQL Server SQL Mobile Sync problems

  I have just upgraded from a working app for Pocket PC 2003 developed on MS SQL 2000 and VS 2003 to Mobile 5, MS SQL 2005 and VS 2005 and have been nable to get anything working. I decided to go back to basics and just try to sync a SQL2005 and SQL mobile database by following the MS doc "Creating a mobile application with SQL Server mobile" and "Step by Step: Developing a SQL Mobile App with Visual Studio 2005 and SQL Server 2005". Unfortunately I have n't been able to get either of these 2 examlpes working either. The Database, publications, subscriptions etc are all created OK yet when I come to sync I get the following error: "A request to send data to the computer running iis has failed" I'd great ...Show All