Afzal Mazhar's Q&A profile

• SQL Server Running sp_blocker_pss80 under SQL2005 and SQL 2000 shows many spids have non zero waittype under 2005

  I was trying to test sp_blocker_pss80 (and SHERLOCK) on an SQL 2005 system and noticed that it gave much more output than on an SQL 2000 system . This was because the waittypes of many spids were not zero while under SQL 2000 the same ones were zero. Why is that For instance here is the subset of the query which is part of the sp_blocker_pss80 run on an sql2005 and sql2000 respectively select spid, status, blocked, open_tran, waittype, waittime, cmd, lastwaittype from master..sysprocesses SQL 2005 spid status blocked open_tran waittype waittime cmd lastwaittype ------ ------------------------------ ------- --------- -------- -------------------- ---------------- -------------------------------- 1 background ...Show All

• Windows Forms Application settings not kept at first update if application installed from disk

  When I installed ClickOnce application from disk and updated it, application settings were lost. This problem didn't occur after 2nd update. Also this didn't happen when I installed application from web. ClickOnce data folders looked like following: ---------------------------------------- Install from web C:\Documents and Settings\me\Local Settings\Apps └─2.0 ├─Data │ └─YNKB7DDJ.P5H │ └─T7V2501Y.AQ0 │ └─clic..tion_3db0dbb3166bfaae_0001.0000_475c829a1cebb17d │ └─Data │ └─1.0.0.0 First update C:\Documents and Settings\me\Local Settings\Apps └─2.0 ├─Data │ └─YNKB7DDJ.P5H │ └─T7V2501Y.AQ0 │ ├─clic..tion_3db0dbb3166bfaae_0001.0000_475c829a1cebb17d │ │ └─Data │ │ └─1.0.0.0 │ └─c ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. One Sound Bank and Multiple Wave Banks

  Just wondering if anyone knows if you need one Sound Bank for every Wave Bank in XACT or if you can use one Sound Bank to reference across multiple Wave Banks. Thanks. You can have one soundbank referencing multiple wavebanks, or even multiple soundbanks referencing a single wavebank if you want. There's a bug in the current beta that may give you problems building XACT projects that contain multiple wavebanks, though. This will be fixed for RTM. ...Show All

• Smart Device Development Cab project installation order.

  I have a solution with three project in which there are two native and one managed project. I have made a cab project and make a cab file to install all three project on the device. It worked fine. But Now I want's to assign the install order that is first project A should be installed then project C then project B How could I do that Try looking at these posts: http://forums.microsoft.com/MSDN/Search/Search.aspx words=NSIS&localechoice=9&SiteID=1&searchscope=forumgroupscope&ForumGroupID=11 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA framework for non C#

  One of the great advantages of the .NET framework is that developers can work on the same project in different programming languages. As I'm reading about XNA, it seems that this will not be possible with the XNA framework. Will the only programming language that has access to the XNA framework be C# The performance hit is from C++ to C# or C++ to VB. VB runs CRL just like C# so the performance is the same. I have a hard time seeing VB as a good beginner language because it syntax is so different than other languages. To move from C# to Java or C++ or many other languages is much easier than moving from VB just my two cents ...Show All

• SQL Server Preperation for exam 70-431

  Hi I'm not sure if this is the right forum to be posting this query as I am a newbie, but here goes. I will be taking the sql server 2005 exam in december and was wondering whether anybody could recommend any good books. The prepertion guide on the ms site has an overload of information which I am just getting lost in! I will also be purchasing these free e-courses on the ms site and wanted to know once I have purchased them how long will I have access to the courses. Also can I access them on the net from any machine. I have just recently passed exam 70-315 and found that the exam questions were very similar to the TestKing questions which I made use of prior to the exam. So I will definetley be buying TK Q's for this exam also. ...Show All

• SQL Server query logic

  Hi there Could you help me with rewritting below query in ANSI format-- for sql server 2005 SELECT VSL.VSLNM, VSL.UVN, VSL.UnqCoNo, Co.CoRootNm, Vsl.VslSt, VslTy.VslTyNm, VslSt, Vsl.FlagCd, Vsl.YrBld, Vsl.YrBld, Vsl.Grtge, Vsl.DdWtTge, Vsl.FmaDdWt FROM VSL, Co, VslCo, VslTy WHERE VSL.VSLNM = @VslNm and Vsl.VslTyCd = VslTy.VslTyCd and VSL.UVN *= VslCo.UVN and Co.CoNo =* (Select VslCo1.MainHdgOwrCoNo from VSL VSL1,VslCo VslCo1, VslTy VslTy1 where VSL1.UVN = VSL.UVN and Vsl1.VslTyCd = VslTy1.VslTyCd and VslCo1.UVN = VSL1.UVN) Regards Rahul The general form would be: SELECT t1 . Col1 , t2 . Col1 FROM Table1 ...Show All

• Smart Device Development Emulator mouse driver problem

  Hi All, I have been able to develop an OS image using Plaform Builder and I am able to deploy the application on the ARMV4i emulator. However, when then application loads I cannot seem to use the mouse on the emulator. The mouse pointer remains at a fixed location and cannot be used, however I can use the keyboard to navigate through the application. I have included the S32410 Matrix Keyboard/Mouse English device driver when the OS image that was built. From my understanding, it is the device driver that the Microsoft ARMV4I Device Emulator supports. Just to clarify what is installed, I have the following; Virtual Machine Network Driver for Microsoft Device Emulator ARMV4I BSP for Windows CE 5.0 Microsoft Windows CE 5.0 Emulato ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Anti-Piracy Security

  I have this scary feeling that people are going to eventually figure out how to use XNA Game Studio Express to right code that will take advantage of the 360 hardware and allow booting of pirated(non-stamped and signed) games. What steps has MS taken to avoid this And if or when this happens will the "rights" and options open to the amauter devs be limited(Limited library uses or such) I really am looking foward to developing for my beloved 360 but I don't want anyone to ruin the fun. Yes so far (3 months and counting) you can boot burned copies and go on live. Hopefully there will be a patch soon and these fools will at least be kicked of the live network to make it less tempting for the masses. ...Show All

• Visual C# Mnemonics unpainted with themes

  With the .net 2.0 the underlines for mnemonic characters are not painted. I am not sure if this bug goes back to .net 1.0. Does someone have a workaround Johan, Thanks for your reply. Sorry I had not looked at all of the other posts earlier. Somehow, I missed them - probably because this was the first time I used this service. Have everything squared away now. Dave Glandorf ...Show All

• .NET Development AxInterop.SHDocVw.dll and Interop.SHDocVw.dll

  Hi, I am coding a system to fill out some informations about taxes and somethink similar. So the program reads the data out of a file, fills out a web page with the data and submits the data. Now my question: is it possible, that I don't need to include the two dll-files ( AxInterop.SHDocVw.dll and Interop.SHDocVw.dll ) or do I have to give the two dll-files with my program My boss wants me to reduces the count of files of the program to the minimum and he doesn't want to send dlls with the programm. Or are the two files in a sub-directory in the windows-directory (or in a .cab) Thanks a lot! Lukas Hi, If you working on .NET Framework v2.0, then you do not need to use the older COM based ActiveX Control. There is a new WebBrowser ...Show All

• Visual C++ C# or C++/CLI ??

  GRRRRRRRRRRRRRRRRR!!!!!!!!!!!! Im so double minded on whether to go with C++/CLI or C#. I dont know what to do.. :( Any advice guys Im looking to develop Windows Forms App's with Power and ease. I have C++ Knowledge but seeing that there arent many resources for C++/CLI, im thinking about going with C# like the many C++ Programmers out there who are...Not that i dont like C++/CLI or C++, its just that C# is a "pure" .NET Language and will always be supported by Microsoft.I also feel as if im being left out of the crowd by continueing with C++/CLI seeing that C# is what many C++ Programmers are moving to. IntMain, unless dependencies and performance concerns become a concern, I'd go with C#. But k ...Show All

• .NET Development after publish the program, if i wanna change the data from Access database, where i can edit it?

  hi i have a program with MS access database after i publish and install the program at the other PC where i can edit the database without re-publishing the program thx for your attention hunb actually i just wanna change some data from database normally from VB6, i can just open the access database under program files but now, i don't know where i can open the access database (after i publish the program) thx for your attention many thx hunb ...Show All

• .NET Development Update statement

  Hi all. I am trying to create a update method. This method will update all changed rows in a datagrid. Since this datagrid is used by many tables i can not use tablenames/columns. How can i do a update statemet without Where clause. I don't know the primarykey since the grid is to be used by many tables. //find the changes DataTable dtChanges = new DataTable ( "change" ); dtChanges = this .dtSource.GetChanges( DataRowState .Modified); //Create the update statement string updSql = "UPDATE " + this .dtSource.TableName.ToString() + " " ; for ( int j = 0; j< dtChanges.Rows.Count;j++) { //set clause for ( int i = 0; i< dtChanges.Columns.Count;i++) { if (i == 0) updSql = &qu ...Show All

• .NET Development Reading data from networkstream

  I normally read data like this, in a new thread on a while true condition while ( true ) {    byte [] someData = new byte [Int16.MaxValue]; //ok so thats overkill!    int theDataRead = 0;    theDataRead = this.theNetworkStream.Read(someData, 0, someData.Length);    while (this.theNetworkStream.DataAvailable)    {       theDataRead += this.theNetworkStream.Read(someData, theDataRead, someData.Length - theDataRead);    }    if (theDataRead > 0)    {       this.theDataManager.DoHandleData(someData, theDataRead);    } }     question is, am I doing it correctly or is there no n ...Show All