detzX's Q&A profile

• Visual Basic long arrays

  Hi I was wondering if it was possible to create a bitarray (or equivalent) with a length longer than an int 32. Thanks i dont want to create an array were each element has a long length. Instead i want to create an array with a large number (10,000,000,000) of elements. ...Show All

• Visual C++ MSDN Forum Problems

  Last week i had some problems in posting my replies to MSDN forums. Yesterday one of my post were automatically posted and even I could not edit or delete it :( What could be wrong I tried with both Firefox and internet explorer to post my answers. I believe this not the problem at my end. Even if error page displayed. some of my answers were already posted to the forums Is there any problem with Forum Servers ...Show All

• Software Development for Windows Vista Persisted Workflow Instance - Check Current State Name

  Dear all, By default, my "Claim Submission" host application sets to unload any idled workflows, and I double checked that the workflowruntime.getloadedworkflows.count = 0. Then I need to design another host for the manager to "Approve" or "Reject" the claim. I tried to use the PersistenceService.GetAllWorkflows function to retrieve all the persisted workflows instance (outstanding workflow) from the database so that the manager can choose from. According to my logic, only instances which are waiting for approval will be shown, so I tried to get the latest status (CurrenctStateName) of each of the workflows with the StateMachineWorkflowInstance: StateInstance = New StateMachineWorkflowInstance(Wor ...Show All

• SQL Server CSV FORMAT [Suppressing a Text Box]

  Hi all, in the Details section of my Report, i have a table and a text box. Can some one tell me as to how i can suppress the text box from being rendered along with the table into CSV format. Hi Brad thanks for the reply, i had actually referred to the same document and had tried making the changes! i was rather unsuccessfull thats why i had asked if any other documentation was available. I had actually put the following tag in the Code [XML] of my RDL <Textbox Name="textbox1"> <rd:DefaultName>textbox1</rd:DefaultName> < DataElementOutput > NoOutput </ DataElementOutput > .................................. .................................. & ...Show All

• Visual Studio Team System Work item field formula

  Hi all We have created a threat work item. In that we have fields for calculating DREAD ranks. We would like the work item to automatically calculate the DREAD value in a field and use it to sort in lists ect. In the Process Template Editor by Imaginet Ressources (a very cool tool) I've noticed a formula property on in the field editor. It is not enabled and I've not found a way to enable it. Do Work items contain a formula property and if what format does it use We need the calculated field to be an average of five other fields Regards Christian Christian, In TFS V1, work items do not support calculated fields. You'd have to do this manually in the work it ...Show All

• SQL Server inserts and updates issue using sp

  Hi, i have the following sp. im using vs.net2005, sqlserver2005. now how do i implement functions like - > okay using datasets, exception is thrown that the row has been modified and i get to inform the user, reload the modified row, . how do i get same functionality using sp is that possible how/ set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER Procedure [dbo] . [sp_Insert_Or_Update_Bill] @BillID_All uniqueidentifier , @BillID uniqueidentifier , @Pono nvarchar ( 25 ), @Date_ smalldatetime , @SupplierCode nvarchar ( 25 ), @Reference nvarchar ( 25 ), @AmountType nchar ( 10 ), @BillType nvarchar ( 25 ), @TypeCode nchar ( 10 ), @AmountFC decimal ( 18 , 2 ...Show All

• SQL Server Subscriptions invalid after SP applied

  Hello, I finished applying SP 1 to sql2k5. Under the replication monitor all of the subscriptions now look like [].databasename when they were originally [subscriber1].databasename. Under Mgmt Studio I see the subscriptions correctly. When I try and replicate I get the message "The subscription to publication 'pub_databasename has expired or does not exist." I have tried to reinitialize the subscriptions but it doesn't work. Is there a way to solve this without have to drop the subscriptions and add them again as I do not want to lose the changes that were made on the subscriptions. We are using merge replication. Thanks. John We encountered this after installing KB919611 values in ...Show All

• SQL Server how to pass strange looking Passwords to SQLCMD ?

  I have problems with passing strange looking passwords from my win.form application to sqlcmd. I tried to do this: sqlcmd -S myServer -U myUser -P 2pQ-""xELfG~fze<= -d "McSpalDB" -i "C:\myProcedure.sql" -o "C:\temp\myOutput.out" but it fails, so I tried to encapsolate the passwoard in "": sqlcmd -S myServer -U myUser -P "2pQ-""xELfG~fze<=" -d "McSpalDB" -i "C:\myProcedure.sql" -o "C:\temp\myOutput.out" but it fails too, because i have "" in my pass, since " isn't a forbiden symbol. How to pass strange looking passwoards to sqlcmd Still I have problems with passwords containing " symbol ...Show All

• Windows Forms save, new, open facilities for data entered in datagridview!

  Hi! I have a GUI with a datagrid viewwith different columns with data ( numbers, strings and/or combination of both). After all the data has been entered i want the user to be able to save it as a file and eventually give it a name, open this file and make a new file when it is needed.  How do i implement this in Visual studio express edition .NET VC++ What kind of a file should it be ( text file or someothertype ) and how do i implement this Assuming the user has saved it ( somehow..) as a file( sometype..), how do i load this data back to my datagridview All inputs are welcome..Example to implement  this will be a blessing! Cheers! ...Show All

• SQL Server how to link executionid of sysdtslog90

  I have enabled logging using database. When I try to query the sysdtslog90 table using System::ExecutionInstanceGUID to link executionid - it is not matching. Any resolution Thanks The variable System::ExecutionInstanceGUID always matches the sysdtslog90.executionid column when I try it. Are the times matching up Are you looking in the right table Try using a Script Task to fire an event with the ExecutionInstanceGUID in the description text, so that it is logged and you can compare the two values in the same row. ...Show All

• .NET Development Memory profiler recommendation

  Hi. I'm looking for a memory profiler which is capable of profiling unmanaged resources, i.e. resources that are allocated by managed instances, but live in native heap. So far, I've found only one program; .Net Memory Profiler v3.0 beta. Is anyone familiar with another solution Thanks in advance, Yaakov I believe the F1 profiler which ships with Visual Studio 2005 can do both managed and unmanaged memory profiling. Hope that helps -Chris ...Show All

• Visual Studio Express Editions Hotkey when specific HWND is active?

  Is it possible to assign a global hotkey to a hwnd and have it execute only if the hwnd is active Ok ive started to experment im using registerhotkey Lets say i register 2 keys RegisterHotKey( this.Handle,100, 0, (int)Keys.F4); RegisterHotKey( this.Handle,200, 0, (int)Keys.F3); How do i handle the events i tried the following protected override void WndProc(ref Message m) { base.WndProc (ref m); switch(int.Parse(m.WPARAM.Tostring())) { Case 100: { // Do stuff break; } Case 200: { //Do Stuff break; } } } } But i dont think my program picked up the events ...Show All

• SQL Server API Reference for SQLDMO?

  Ive been googling for a while now and i cant seem to find the API reference for SQLDMO.dll. Can any kind person paste an url :) The only thing I want to use it for is to know what kind of exceptions SQLServer.Connet() and SQLServer.attachDB() throws, but an url would be nice for futher use... There are a couple of places you can find it. If you installed SQL Server, then you can find it in Books Online. Otherwise, go here: http://msdn2.microsoft.com/en-us/library/ms133993.aspx ...Show All

• SQL Server Merge Join's poor performance

  Hello All, I'm experiencing performance problems with the merge join task. Every time I'm building a nice package using this task, I'm ending up deleting it and using SQL statement in the OLE DB source to accomplish the join since it takes forever to run and crushing my computer at the process. It makes me feel I don't use the abilities SSIS has to offer compared to DTS. Of course for the use of several thousands of records it works fine, but in a production surrounding with hundred of thousands of rows, it seems to be futile. Maybe someone had a little more luck with it Sure. When I'm using a Lookup component to make the join, The lookup table is been cached by default. When I want to joi ...Show All

• SQL Server SQL Express running slow on Small Business Server

  Hi We have SQL Express running very slowly on Small Business Server. Does anyone know if there is a conflict between the two Or any ideas on how to solve our problem ( Autoclose is set to false) Thanks There are a lot of ways to find out what is happening in your database system that is affecting performance. Start with this series of articles: http://www.informit.com/guides/content.asp g=sqlserver&seqNum=195&rl=1 Buck Woody ...Show All