dustinto's Q&A profile

• SQL Server Is it possible to read data from a table with exclusive lock ?

  Hello, We currently use SQL Serv 2000 with an ERP application and VB applications. Both system work with the same database & tables but the ERP application seems to put exclusive lock on all tables it needs during processes. So our VB applications are not able to read these data and we receive TIMEOUT error. What can I do thank you Nico Hello, Just to confirm you it's seems to work and this a great new for our users :) Thank you very much for you help regards Nico ...Show All

• .NET Development Setting up trust

  How do i go into the framework and setup trust for new users to run apllications Check out the SecurityManager class in the System.Security namespace. This is explained in one of shawns blog posts http://blogs.msdn.com/shawnfa/archive/2004/09/09/227534.aspx hope this helps tribal ...Show All

• Software Development for Windows Vista CardSpace shipping with Vista?

  Can someone confirm that CardSpace will be released and enabled with the Vista launch on January 30 I have heard that it might not, but can't find an explicit official statement one way or the other. ...Show All

• SQL Server How to send a report on data change?

  I have this report that uses one table. At some random times during the night this table will be updated. Is there a way to trigger the email report whenever the table changes its data well, then this http://www.sqlservercentral.com/columnists/jselburg/datadrivensubscriptions.asp is all you need! create the report create subscription upload from Excel trigger stored procedure have fun... ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. TorqueX question

  Just curious, is there any equivalent in TorqueX for Texture2D.SetData() and Texture2D.GetData() methods I frequently use them in XNA to change some parts of the texture. For example, I've added a sprite to TorqueX engine and assigned a texture to it. Then, how do I get a per-byte access to this texture Thanks in advance. Thanks, I already did this...Just thought that there have to be some people here who are already familiar with TorqueX. Anyway, I think I've found the answer myself...although you'll still have to use SetData and GetData for low level work. Here's the method: public void ForceBaseTexture( Texture2D tex ) Namespace: GarageGames.Torque.Materials.DXEffects Description: Used ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Vector maths methods...

  Following a long day of writing and debugging some nasty rigid body physics code, and feeling the pain of the maths library I have to use for this C++ work, I thought I'd take another look at the XNA maths code to see if the results would be more readable (as you might hope ;). ... But my quick look at the framework docs seems to show more deficiencies than in the code I have been using all day... 1/ There is no Point3 class. This is a real pain as libraries that don't distinguish points and vectors are a right pain - transforming a point by a 4x4 matrix will result in a different result to transforming a vector. (And I don't want to resort to coding every point/vector as a homogeneous coordinate either!). There appears to be a ...Show All

• Visual Basic With User Control changing other user control's properties

  Hi, I'm making a User Control for an application (GIStock). But within that control other instances of UC's of mine (GIStockItem) are added using controlarrays. Now when the user leftclicks on such a GIStockItem, the selected property of that control is changed to true. But the rest of the controls in the controlarray should also been changed to false. How can I achieve this Here's a piece of code of the GIStock load event: Dim items(3) As GIStockItem items(0) = New GIStockItem ("item1", 5, 5) items(1) = New GIStockItem ("item2", 5, 25) items(2) = New GIStockItem ("item3", 5, 45) For i As Integer = 0 To items.Length - 1 Me .Controls.Add(items(i)) Next i ...Show All

• SQL Server Message Type and Message Body..............

  Hello, I am having trouble specifying a message body that is valid. I mean for the client to send. If I leave it as null then everything is ok but if I create a memorystream and add a line of text it reports back it did not pass validation. I do not understand this and am not sure what to do. I need to send a message based on a code and text but do not know the format of the body that is allowed. The code I am refering to comes out of HelloWord_CLR because that is what I am formating my sample after. I call it the same way it calls the return message done in ServiceProc. I need to know the message format including body since this does not seem to work. A sample of the call is bellow. // Create an empty request message string Msg ...Show All

• SQL Server Having 2 CALCULATE statements no longer works after installing SP2!!!

  I received the following email from a collegue of mine:   I think we may have found an issue with SQL SERVER 2005 SP2   1. Some of the Analysis Services Properties when you click the advanced tab are missing!   2. The MDX scrip behaviour is not the same. In our cubes we had two CALCULATE statements - first to aggregate the data as normal, then some code to calculate MTD and YTD figures and then another CALCULATE statement. This enabled us to calculate percentages later on in the script without having to sum up all the data at leaf levels first.   With SP2, this no longer works!!! All our percentages are now being added up (like all other measures) which is clearly ...Show All

• Visual C++ Paint' : cannot convert parameter 1 from 'struct HDC__ *' to 'long'

  Paint function in microsoft visio viewer 2003 is like this: [id(0x60020035), hidden, helpstring("hidden method Paint")] HRESULT Paint( [in] long HDC, [in] long X, [in] long Y, [in] long Width, [in] long Height, [in] long SrcX, [in] long SrcY); but when I use the following codes to call funcitons: IViewerPtr m_Viewer( _T("VisioViewer.Viewer") ); CString strFunction("D:\\Program Files\\Microsoft Office\\Visio Viewer\\1033\\SAMP_VDX.VDX"); BSTR b = strFunction.AllocSysString(); _bstr_t b1 = b; m_Viewer->Load(b1); SysFreeString(b); m_Viewer->Paint(pDC->m_hDC ,10,10,200,200,20,20); there is the following error, please tell me how to solve ...Show All

• SQL Server Jobs lose ownership/permissions when server reboots

  This is sort of a DR issue since it involves reboots and power failures. We have MSSQL 2005 SP1 and unpatched systems, but in particular we have this problem still with the SP1 server (in addition to the unpatched systems). Running on Win 2k3. It seems that upon reboot, our stored SSIS jobs lose their pemissions and/or ownership for execution. It doesn't happen at every reboot or power failure, but seemingly more than half the time. Here is the error reported: The job failed. The owner () of job Job_1 does not have server access. But checking the properties of the job and it shows an valid owner in the Owner field. I believe we are using Active Directory for authentication and the user listed is valid in that respect. We have "fixed" thi ...Show All

• Visual Studio Team System programmatically merge branches in source control

  how do i programmatically merge branches in source control. Regards, Guru Start here: http://blogs.msdn.com/buckh/archive/2006/08/12/tfs_api_links.aspx The parameters for the Merge method are documented in the SDK. They're almost identical to the command-line 'tf merge' syntax, if that helps. ...Show All

• SQL Server Constructing a View into time dependant data

  1. I have a table with data like this: PersonID DateTime Temperature Pressure 2. I want to build a view into this table so that it shows up as follows: PersonID DateTime1 DateTime2 DateTime3 ..... 1 Pressure1 Pressure2 Pressure3 ...... 1 Temperature1 Temperature2 Tempearture3 ..... 2 : : how would I do this Hello, Have a look at http://dotnetjunkies.com/WebLog/thomasswilliams/archive/2005/10/23/133383.aspx for starters. The actual solution will depend upon your data. Cheers, Rob ...Show All

• SQL Server How to put different update on the same table in one query ?

  I have a table in which there are 100 of thousand of record.In on e of the stored procedure I am updating different columns in different go. Now I want's to update them in a one go. How can I do it queries in my stored procedures are UPDATE Job SET CompanyName=c.Name FROM Job j JOIN Company c ON j.CompanyID=c.CompanyID WHERE CompanyName IS NULL AND NOT ((c.Name IS NULL) OR (c.Name='.')) UPDATE Job SET CompanyDescription=left(c.Description,1000) FROM Job j JOIN Company c ON j.CompanyID=c.CompanyID WHERE ((CompanyDescription IS NULL) OR (CompanyDescription=' ')) AND NOT ((c.Description IS NULL) OR (c.Description='.' OR (c.Description=' '))) UPDATE Job SET HomePageURL=c.URL FROM Job j JOIN Company c ON j.CompanyID=c.Comp ...Show All

• .NET Development Internal Server Error When ASP.NET Starting

  When I want to start ASP.NET Web Application get the following error. HTTP/1.1 500 Internal Server Error Please help me. Thanks Turn off custom errors to get detailed error. Also disable 'Show friendly HTTP error messages' in IE. Check application event log and security log for errors. Ensure that the correct AppPool is set in virtual directory properties and the correct identity is configured. Give us a shout if you need more help with any specific errors. Nikhil ...Show All