KIPREAL's Q&A profile

• SQL Server server timeout

  In SQL server management studio: When doing ex count(*) for a big table or create index or like, I get timeout error. The timeout setting = 0 Even timeout = 888888 gives timeout Does not the query execution timeout parameter work Or are there other parameters needed to be ajusted Hmmm... are you able to execute SELECT COUNT(*) from other applications with configurable timeouts i.e. SQLCMD or a custom .NET application Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ ...Show All

• .NET Development MS Access supports Cascade deletes but SQL 2000/2005 doesn't?

  This is progress If someone cares to show me how I can do a multi-table record delete with a single query or nested queries with one filter, please do so -- MS Access 97 to MS Access 2003 supports this, yet SQL 2000/2005 doesn't I've even tried creating a view (SELECT all the items I want to delete from 5 different tables) and the performed a DELETE FROM MyViewName and .NET 2.0 tells me I can't peform and update I'm using a sqlCommand.ExecuteNonQuery. Is this one of those cases where functionality was not included to protect the stupid from making mistakes Ugh! Rob. Rob, Here’s a link to SQL Server’s documentation: http://msdn2.microsoft.com/en-us/library/ms186712.aspx C ...Show All

• Visual Studio Team System To exclude or not to exclude!

  Hi, I have been using FxCop for a couple of weeks now and I often find myself with a dilemma whether to exclude a message or not. The reason being is that it seems that some messages are aimed at people who developer libraries/controls for public consumption. This is not my situation the product is stand alone and will never be used as a library. A couple of errors spring to mind: DoNotExposeGenericLists and CollectionPropertiesShouldBeReadOnly. I just feel that there are situation where the usage of the assembly effects the decision whether to exclude the message or not and maybe some comments in the docs to give guidance would help I would be interested in your thoughts on this matter as I a ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Game Math 101: Changing the magnitude of a vector?

  I find myself needing to change the magnitude of a vector quite often, and end up writing a lot of code that looks like: v1 = Vector2 .Multiply( Vector2 .Normalize(v2), 250.0F); Is there a better way That just seems awfully inefficient. It only gets worse when I want a particular magnitude vector in the opposite direction: v1 = Vector2 .Multiply( Vector2 .Normalize( Vector2 .Negate(v2)), 250.0F); Or inverting the Y-axis of the thumbsticks: acceleration = Vector2 .Multiply( Vector2 .Normalize( Vector2 .Multiply(gpt.Left, new Vector2 (1, -1))), 800.0F); Please, help a noob out... Matt exal is correct, it dawned on me later: Keep your direction and speed seperate, then multiply the ...Show All

• Software Development for Windows Vista Can't connect custom RAM source filter to AVI splitter

  Hi I'm trying to do something in DirectShow that is, obviously, not very conventional, so I'm currently experiencing some problems... I made a source filter, the output pin of which inherits CStreamSource. I want to connect it to an AVI Splitter. To do so, I made its output pin implement IAsyncReader too, and I overloaded the necessary functions, according to the AsyncFilter sample. My problem is when I try two connect those two filters, I receive an error. Particularly, the ReceiveConnection function of the AVI Splitter return an error code "Invalid file format". This is a big problem to me since my source filter doesn't work with a file as a source, but with a RAM buffer, and IAsyncReader seems to be made to be used with a fi ...Show All

• Windows Live Developer Forums Adding over 100 pushpins from a database

  I am working with a CRM web app that creates lists. I want to pass this list to a page that has the map. My problem is getting the server side data to the client side code of VE I have tried to use a session array but must be doing something wrong. The code is writen is javascript and I could really use some help. How do people push large amounts of data to VE Thanks all! RedCoat999 wrote: What would the GeoRSS file look like for that example Microsoft's example GeoRSS feed is located at http://dev.live.com/virtualearth/sdk/GeoRSSTest.xml . Using GeoRSS may or may not be viable for you in the current version of the map control since adding a layer will automatically zoom to a best-fit ...Show All

• Visual Basic Math Questions

  This is my code I'm working with. I'm trying to use the sum from the lhGal to show in lhGal2.Text. Dim FirstNum, SecondNum, ThirdNum, FourthNum As Double 'Intial Fuel Add FirstNum = lhPounds.Text SecondNum = lhDensity.Text ThirdNum = lhGal.Text FourthNum = lhPounds2.Text lhGal.Text = FirstNum / SecondNum - 0.4 'Additional Fuel Added to bring to 1200 lhGal2.Text= FourthNum / SecondNum - lhGal lh = Left Hand because there will eventually be a right hand once I learn the code for the left.  Actually Pounds is a known number, this is what I have now. lhGal.Text = 80 / lhDensity.Text - 0.4 lhGal2.Text = 1200 / lhDensity.Text - lhGal.Text lhAddLip ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Questions

  Hello, I have been trying to learn game programming for about a month now. I need some help. I have not found a lot of free sources on the internet to learn directx 9.0c in C#. I find plenty in C++. Is C++ a better language for game programming. Someone told me C++ gives the game a little more speed but I don't mind it being a little bit slower. Also, I just saw on a website that when DirectX 10 comes out DirectX 9 will be nothing.... They said they rebuilded it from ground up..... Does this mean I should wait a couple months for DirectX 10 to come out before I learn to program games Or should I learn OpenGL. I heard it is easyier to learn but I also run into the same problem, I can not find any tutorials that will show me how to do it ...Show All

• Windows Forms Very Dangerous message

  Dear all After I finished my Financial project by using VB2005.net and SQL SERVER 2005 and made publish for this project ,After that I Installed this project on my computer and when I open some reports from this project appeared this message below "Financial Project has encountered a problem and needs to close. we are sorry for the inconvenience If you were in the middle of smothing, the information you were working on might be lost " This message appeared alone in reports viewer and in this case I need to close the program How I can solve this problem I'm sorry, I'm a bit stuck now. Does it look like the exception is coming from your application, or something else, outside your app.. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Rest method (make the computer chill)

  I'm trying to put together a method that makes the computer rest or delay itself from going too fast or from looping through the game again. Here's the code I put together, but it doesn't seem to be working. void Rest( int milliseconds) { for ( int i = 0; i < milliseconds; ) i += ElapsedRealTime.Milliseconds; } Has anyone put together something similar that works Nice, that seems to work. I have a for loop where it adds points and plays a sound for every missile that is left over at the end of the level, but it is doing everything way too fast. This just slows things down to a reasonable level ...Show All

• Visual Studio Team System Build Server Drop-Down

  When you submit a build the build server control is a combo, however, it doesn't seem to remember build servers you've used previously. It would also be useful if you could specify more than one build server in TfsBuild.proj and have these servers appear in the combo-box (until we get some kind of build queuing). I believe that for now the build machines that show up in this list are those which are present in any of the build types for the current team project. You are correct that it does not remember any others that you manually type into the combo box, etc. Thanks for the feedback, and we'll try to get this addressed in a future release! -Aaron ...Show All

• Windows Forms New Publish causes full download

  Every time I publish, it seems to cause a full download for the user. Am I misunderstanding how ClickOnce is supposed to allow the client to only download what has been changed in the application. I see it maintains a completely separate copy of the app by revision number. How can I configure ClickOnce to only require the user to download what has changed rather than the whole app again everytime when I publish a new version Thanks, John Elizabeth, Thank you so much for your reply. I appreciate your expertise. When publishing with ClickOnce, that status indicates it rebuilds the project you are publishing. However, files that are simply referenced, and not built in the project, also get r ...Show All

• Visual Studio Tools for Office Excel 2007, XlPattern.xlPatternLinearGradient question

  Hi, I'm trying to color some cells of an excel sheet using managed code. More specific I want to apply a custom style to a certain cell. This style has the pattern property of the interior set to Excel.Pattern.xlPatternLinearGradient (which is new for Excel 2007) The problem that I have is that I cannot set the gradient color at all. If I do not specify any coloringI will get a gradient from white to light blue (default values). If I set the color property of the interior to red, it will reset the gradient and I will get a red cell. How can I have a gradient from white to red The same issue I have when using XLPattern.xlPatternRectangularGradient. Observation: I'm developing an addin for Excel 2007 using C# and VSTO 2005 SE, I' ...Show All

• Software Development for Windows Vista application compatibility with vista

  i want to port an application on vista. but the application supports SQL server 2000 only and vista supports 2005 only. bow can i make that application compatible to vista ...Show All

• Visual Studio Team System Project/TFS Integration issue - please help

  Ok, this is my last effort before opening a ticket with Microsoft and spending the rest of my life on the phone with them. I have Project Server setup, and I have it receiving its data from TFS. The data is replicating between the 2, etc. Here is the problem. When I click "Refresh" on the Team plugin for project a couple times, the data will change. Here is an example: I have a work item with Actual (Completed) Work set to 8 hours. This shows in TFS. Refreshing it in project shows the 8 hours fine. However, if I refresh again it changes it bakc to 0. Clicking refresh 2 more times sets it back to 8, hitting it again makes it go back. This happens with most of the work items, and I cant for the life of me figure out what it is. ...Show All