igor1960's Q&A profile

• SQL Server Query Notification stops working after 10 minutes

  Hi All We built a Cache component that take advantage of the SQL Server 2005 query notification mechanism, all went well , we tested the component in a console application , and notifications kept coming for as long time as the console application ran. When we initiate our Cache Component in our web service global.asx application start event , the query notification works for a few minutes , but if we came after 10 minutes or so , we stoped getting notifications from sql, the SQL Server queue is empty , and all is showing that there is nothing wrong on the DB side... Our Cache component is a Singleton class , that perform all registrations ,catch the notification events and resubscribe for notifications. What can ...Show All

• SQL Server Performance problem

  Hi, MyTable : RowNum INT (IDENTITY) PageTitle NVARCHAR(MAX) DomainName VARCHAR(1000) Indexes : Primary key, clustered on RowNum Full Text index on PageTitle , Index on DomainName Data patterns : hundreds or thousands rows per each DomainName value When user performs search, the task is to present 1 entry per DomainName (despite the fact that hundreds of pages on the same site can contain the word). 10 entries per page are presented. Now it is implemented in the following way (using application): 1-st result : SELECT top 1 * FROM MyTable WHERE CONTAINS (PageTitle, '"word"') Let's say, 1st Domain was www.cnn.com 2-nd result : SELECT top 1 * FROM MyTable WHERE CONTAINS (PageTitle, '"word"') AND DamainName NOT IN ('www ...Show All

• SQL Server How to Email to Microsoft?

  I find a bug in Reporting Services ,How to Email to Microsoft http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=604575&SiteID=1&mode=1 To submit bugs, you can contact Microsoft Connect, at https://connect.microsoft.com/SQLServer . ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Alphablending 3D

  I know when doing alphablending you have to draw objects in order. I believe you must draw more distant objects first. I assume this distance from the camera. Can anyone point me in the right direction as far as implementing this Doing perfect depth sorting is near impossible for 3D games. You'll have to draw your mesh by subsets at any rate and it may well be that a subset (or even a triangle) is both in front and behind another subset. This doesn't mean alpha blending is bad, but just that there's no perfect solution that will make alpha blending 'just work'. Because depth sorting may be hard and inefficient to implement, a typical alternative is to use alpha testing instead if you only need opague/t ...Show All

• Visual Studio Branch project from batch command line or vbscript ole automation

  Is there anyway that I could branch project using batch command line or vbscript ole automation I search command line reference, but I can't not find parameter for branch source and branch target. Please help. Thanks I could create share and branch from VSS explore; however I would like to do it from command line. I've tried command line below but it not work. Like I said I did not get any error and nothing happen. ss cp $/projects/01 ss branch $/trunk/project01 ...Show All

• Visual C++ Simulating Left Mouse Button Click

  Hi, At the moment, I am running into a problem which is this: Every time I right-click on a TreeView item in my application, the selected item remains the item prior to right-clicking rather than changing to the right-clicked item. While this isn't exactly a BUG, it is quite an inconvenience. The most obvious solution to the problem, to me, is to simulate a left-button click in the right-click NM_RCLICK event that will in turn select the item prior to any further actions. Is there a better way to accomplish this If not, how can the left-click simulation be accomplished Thanks in advanced. ---Dan To simulate mouse clicks, you can use mouse_event and SendInput. However, I think it will be better to use ...Show All

• .NET Development XML Reading Problem

  Hi, I'm loving what you all can do with C# but i'm currently new at C# with the use of XML. I'm making a project and i'm saving info in a XML file since for me its the best choice for storage because i don't wanne use access databases or SQL or MYSQL. So i'm trying a bit but i'm stuck now. I got a bit code to read a xml file well its rather a long and simple way but it does. But my error is that i get this error, System.Xml.XmlException: 'Element' is an invalid XmlNodeType. Line 8, position 4. at System.Xml.XmlReader.ReadEndElement() at PlayGround.Form1.button1_Click(Object sender, EventArgs e) in C:\Coding\C#\PlayGround\PlayGround\Form1.cs:line 36 at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button ...Show All

• SQL Server AMO - measure numeric Value

  I'm building a cube dynamically and i want to list just the columns in the fact table that are numeric in order to make Sum's, AVG's and so on. How can i do this using AMO , i'm wondering if i can do this from the FactTable's (Data Table) DataColumns, but there is no metadata that tells me if the values there are or not valid numeric measures. Regards Lisber. Hi Chris !, exactly i was thinking in the solution you described before , but i was having some troubles, here is the code that i use to figure out if a data column is or not a measure ( ie, if its numeric ). // 1o I make a loop through all the columns of my fact table ("FactResellerSales"), here is the ...Show All

• Visual C++ problem in playing m2p files

  hi guys, I designed the MCI player for playing file formats like mpeg 1, mpeg 2(m2p extension),vob.....In that I am able to play all the file formats BUT i am unable to get the total time duration for the mpeg 2 files(m2p extension) alone, using LONG MCIWndGetLength(HWND) function (for other formats the time duration is complete and i dont have problem ). The length obtained from this function doesnt match with the total duration of the mpeg 2 file alone(extension m2p). Some part of the m2p file at the end are missing(around 5 seconds in a 12 seconds m2p file). Can anyone help me to solve this problem Thank you. With regards Raja Bose A better place for such issues is the newsgroups at http://msdn.microsoft.com/newsgroup ...Show All

• Smart Device Development Need to instantly detect socket disconnect.

  I am developing a Pocket PC app which allows the user to take the PDA around a parking lot while entering information on a form and saving. When the Save button is clicked I want to not only save it to the PDA but send the information to a laptop sitting in the user's vehicle. This laptop listens for a connection request. I know how to transmit and receive files using sockets but I need to be able to instantly detect when the PDA has lost the connection with the laptop (losing the signal by putting a building in between the PDA and the laptop, for instance). I want the PDA to inform the user that the signal has been interrupted and keep trying to connect to the laptop before sending the file. As soon as the connection has been re-establish ...Show All

• Visual C# Return / finally -- which one will execute Last in a method?

  Hi I've a doubt regarding Finally block in exception handling, I'm trying the falllowing code public Dataset funct() { Dataset ds = new Dataset(); //Other declarations here try { adapter.fill(ds); } catch { } finally { ds.dispose(); } return ds; } In the above code I'm desposing the dataset before return, but it is comming in the method which is calling this method. when I'm debugging this application the control goes to finally block and executing return later. whats going on in this code. can anybody tell me please Thanks in advance Hi, boban is right in his answer. For you, how you can dispose the dataset before you use it yo ...Show All

• Windows Search Technologies Problem crawling with a hierarchical custom protocol handler

  I have developed a hierarchical custom protocol handler that I'm integrating with Windows Search on Vista. The handler has a IUrlAccessor and IFilter implementation that enumerates the contents of a directory by returning the search URL of each "file" in the directory as a text chunk with the STAT_CHUNK structure specifying the GathererPropset and PID_GTHR_DIRLINK propid. My understanding is that the indexer should take these URLs and queue them for indexing, in which case I should see subsequent calls to CreateAccessor with those URLs. However, instead I'm seeing the indexer call CreateAccessor once to get the directory accessor, then it reads the dirlink text chunks, but it never make the expected additional calls to Create ...Show All

• .NET Development diskCache unavailable?

  Hi, I'm working with visual studio 2005 (version 8.0.50727.42 [RTM.050727-4200]) and the .net framework 2.0 (version 2.0.50727), and i would like to use the "diskCache" section for cache configuration. For some reason, this section is unavailable. Is it some version problem Regards... ...Show All

• Visual Basic Enabling user control mouse events

  I have created a user control and placed it onto a form and it all generally works OK. I have put code into the form to react to Mouse up, down and move events for the user control but the form code is never entered when I click on the user control. I am guessing that I need to put code into the user control to generate these events. If so can anyone suggest what is required poiuytrewq wrote: I think I have found the problem through experimentation - it appears that your statement that the mousedown event in both the UserControl and Form code should be triggered is incorrect. It seems that MouseDown etc events are suppressed in both the form and the UserControl if there is any control under ...Show All

• Visual Studio Team System Unassociate mpp with a team project

  Once an mpp is associated with a team project how is it unassociated with a team project Yes that is what I mean. I want to disconnect the Project file from a TFS Server and a Team Project. It does not need to be associated with the given Team Server or Team Project. ...Show All