Pankaj11's Q&A profile

• SQL Server Momitoring when job has executed

  Is there a technique for determining when a job has been executed - using T-SQL I tried using 'sp_help_job' by inserting the output into a table (e.g. INSERT jobtable EXEC sp_help_job...) but I get the following error: Msg 8164, Level 16, State 1, Procedure sp_get_composite_job_info, Line 68 An INSERT EXEC statement cannot be nested. Any ideas anyone Rgds Bertrand You can all the info from msdb..sysjobs and msdb..sysjobsteps table. I suggest you take a look at the following article (thanks Gert) so you can handle the sqlagent datetime. http://sqldev.net/sqlagent/SQLAgentDateTime.htm ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Shader to Mimic BasicEffect Textures

  Just in case I am overlooking the obvious, is there an easy way of getting the textures that are linked to a mesh   BasicEffect somehow knows which textures are for which part of the mesh, is this behaviour easy to mimic in a user definded shader   I have per pixel lighting with specular/diffuse working great, I just need this last peice of the jigsaw. Any help is much appreciated. You can cast the effect that was loaded by the pipeline to BasicEffect, then look up its Texture property: Texture tex = ((BasicEffect)meshPart.Effect).Texture; ...Show All

• Visual C++ Has casting to int from double changed completely in VS2005?

  Has casting to int from double changed completely in VS2005 Numbers that are too big are always -1 now. Which has caused me much pain to track down and is not compatible with code we currently use. Here is an example, it used to be that if you cast a big number to an int, you would some value that was related to it in some way: (int)1.0957837e+011 => -2090779696 But now it is always -1 if the value is out of the range of the int: (int)1.0957837e+011 => 0x80000000 Is there anyway to make Visual Studio 2005 use the old style of casting Thanks John Petritis I get an exception when casting using the old-style (C) cast from a double to a long when the value is extreamly large. The code dies in ...Show All

• SQL Server Getting rid of #temp tables without restarting SQL Service

  If you create a #temp table on stored procedure  #1 and then call another stored procedure #2  from #1; if stored procedure #2 has an error in it, the #temp table will not release even though stored procedure #1 has a drop table statement in it. Jared, What I mean by release is; if Procedure #1 (this Procedure creates temporary table) calls Procedure #2 and Procedure #2 has an error in it, the temporary table will not be dropped, even with a drop statement. The only way to get rid of the temp table is to restart the SQL Service or reboot. ...Show All

• Visual Studio Express Editions combobox problem

  Hi. I want to assign values from one column in database to combobox. My database has two columns. That's the code that I'm using: ComboBox1.DataSource = MaintenanceDatabaseDataSet.MachineTable.Machine_nameColumn However it generates error: Complex DataBinding accepts as a data source either an IList or an IListSource. what should I do The datasource property should be a bindingsource control or a table within the dataset: ComboBox1.DataSource = MaintenanceDatabaseDataSet.MachineTable Combobox1.DisplayMember = MaintenanceDatabaseDataSet.MachineTable.Machine_nameColumn Combobox1.ValueMember = MaintenanceDatabaseDataSet.MachineTable.PrimaryKey_Column ...Show All

• Visual Basic Checking if drive exist

  I got a few questions, maybe you might be able to help. I am needing to design a program that will check for a problem with another pc in my local network. We are not running a server type enviroment, but just a simple peer to peer platform. Any how on to the problem, We use one pc to act as a server, and the hard drives use a raid controller using 1(mirror). We ran into a snaffou yesterday, because no one in that building monitors thier pc's, they just use them, anyhow the raid broke and created 2 independent drives with the same shared folders, and the drive windows decided was bad wasnt the right drive, it renamed the volume and took everyone back to fridays data that resided on the drive that windows thought was bad. Anyhow ...Show All

• Visual Studio Team System Team Explorer requires login

  Two of my support people have an issue with Team Explorer requiring them to login each time the app is opened.  They do not have VS, just Team explorer as they are software testers. Each time they open the app, they are prompted for their username and password.  Once they supply their domain credentials they are allowed to use Team, so I dont know how it could be a permissions issue. I have a couple of dozen support people using the exact same configuration, and only these two are effected for some reason. Any thoughts or ideas Thanks in advance. MikeH Which version of OS your support folks (that are having this issue) running You can try adding http://<yourservername> and/or h ...Show All

• SQL Server still struggling with flat file into multiple tables

  So here's the issue 16 flat files all fixed width. Some over 350 columns. Open flat file 1 extract id and go see if its in table 1, if true update table 1 with first 30 columns otherwise insert into table 1 first 30 columns. goto table 2, lookup id, insert/update next 30 columns...etc..etc..for 10 different tables So I've got my flat file source, I do a derived column to convert the dates, i've got a lookup for table 1, then 2 ole db commands, 1 for update if lookup successful, 1 for insert if lookup fails. How can I pass the id as a param into the update command so it updates where x = 'x' also I need a pointer on doing the next lookup, eg table 2, would I do this as some sort of loop . If you can help great, bu ...Show All

• Visual Studio 2008 (Pre-release) Creating a WCF client to talk to an existing application using a custom binary protocol

  I have been looking around at some code samples for creating custom channels and bindings, but the messages are usually converted to XML or SOAP, or they are just wrapping a WCF service around some socket code and having the client communicate with the wrapper. I have a server application using a proprietary protocol, and I would like to use WCF to communicate with it. Is there a way to accomplish this without writing a wrapper service Thanks. I guess you need to write a custom WCF Transport adapter and the adapter takes WCF messages from the client and converts it into your proprietary protocol and talks to your existing non- WCF service. Check the following link http://wcf.netfx3.com/content/Bu ...Show All

• SQL Server Stored procedure issue. a bridge too far for me

  i have a query that i need to extend but just dont have the knowledge to do so, so hoping someone here could help me this is my current query:- SELECT ES.PatientID, DATEDIFF(day, EP.DateofBirth, GetDate())/365 AS Age, CASE EP.SexCode WHEN 'M' THEN 'MALE' ELSE 'FEMALE'END AS Gender, COUNT(H.HRDID)AS HRD, ES.FourRegularDrugs, isnull(ES.FourRegularDrugsNo,0) as NoOfDrugs, ES.ReadmissSixMonths, PCE.[Primary diagnosis] FROM tblStudyServices ES INNER JOIN tblPatient EP ON EP.PatientID = ES.PatientID INNER JOIN PAS.dbo.[PAS Patient Details] PP ON PP.[PAS key] = EP.PatientInternalNumber INNER JOIN PAS.dbo.[PAS Admission Details] [PAD] ON [PAD].[PAS key 1] = PP.[PAS key] INNER JOIN PAS.dbo.[PAS Consultant Episode] PCE ON PCE.[PAS key 1] = PA ...Show All

• Visual Basic Configuring short cut keys on VB .net application forms

  Noticed that short cut keys configured for buttons on a VB.net windows application form (VS 2005), The short cut keys become responsive on all buttons on the form when the focus is on a button, without requiring the alt + key combination. This happens without the user ever pressing the alt key. Is there a way to enforce that buttons are only responsive to the ALT + key combination defined The Short cuts keys in the scenarios mentioned were configured using the '&' in front of the letter in the name which was expected to be responsive to the ALT + key comibination. If you really wanted to, you could preview the keypress in the form and suppress it based on the selected control. The question is ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Not Using Vector2 in my 2D Game Engine

  I just recently changed, oh, about a 1000 lines of code in my game engine. Instead of using Vector2 for things like position and size, I decided to use floats instead. Does anyone else use Vector2's as their main position and size data types in their 2D game Right now, I have the code for both versions, and I'm trying to make entirely sure floats are the way to go before throwing one of them away. Any comments Since Vector2 is just a pair of floats it will use up the same space as two separate float variables. This is no different in .NET than in C++. So, I cannot see why it would be less efficient to use the struct vs float vars. ...Show All

• Visual Basic Writing a pixel.

  Hello All, In the days of VB6 one could use Pset to write a pixel onto the screen. It appears that VB2005 has considered this uneccessary and ignored it instead. The help suggests drawing an ellipse of size 1 pixel (isn't this like using a jackhammer to crack a nut ) so I did with this sample code: Dim myStyle As New Pen ( MyColour , 1) gr . DrawEllipse ( myStyle , Xpos , Ypos , 1 , 1 ) Sometimes I get my single pixel, sometimes I get a vertical line of 1x2 pixels - depending on the values of Xpos and Ypos. Is there a reliable way to paint one pixel As an aside - does anyone know why MS abandoned the Pset type construct - are Pixels not worthy in VB2005 All the best. ...Show All

• Smart Device Development Compact Framework 2.0 making Call using Calling card

  The WM5.0 phone I have has bugs. Let me say I want to make call using calling card. These are all the steps. 1. Call 1-800 number of the calling card using speed dial. 2. Now enter 10 Digit Pin. 3. Enetr 10 digit destination number. After step 1, when I use speed dial or dial from contact for step 2 or 3, it makes as new phone call rather than giving response for step 1. I want to develop my own phone application to make such calls. What should I do in Compact Framework 2.0 VS2005 WM5.0 to continue all the 3 steps as one instead of making new calls at step 2 & 3 Thanks, Vijay You should use TAPI. OpenNetcf.org has managed wrapper if you don't want to P/Invoke it yourself. ...Show All

• Windows Forms Removing the selection column in DataGrid

  This should be easy, but I could not, for the life of me, found out how to remove the selection column. This is the left-most column of the grid where user normally click to select the entire row. Any quick way to do this Cheers, Victor I misunderstood what you were wanting at first.  but that column is very easy to remove, dataGridView1.RowHeadersVisible=false; ...Show All