GusaMusa's Q&A profile

• 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

• Windows Live Developer Forums VEPushpin.OnMouseOverCallback is not very customizable please help.

  i have just started using virtual earth and i am having to face issues. can someone help. hte problem is specifying the description and title for a pushpin is an expensive operation for me and i dont want to do it for every pushpin. I infact i want to load the description for the pushpin when user hovers over it. There on the callback function i need to a reference to that pushpin object that i created so i can grap the pushpin id that i assigned and use that primary key to get the contents from the database and load a usercontrol dynamically on the server, get its rendered out and assig the description property this text. thanks zeeshan Hirani No there is nothing like this in VE currently bu ...Show All

• Commerce Server Error 8624

  We are experiencing a catalog search failure when trying to return the contents of an entire catalog catagory that contains more than 12,000 rows. This appears to be rooted in some dynamically generated SQL code. Here is part of what the Event Viewer is showing me when the error occurs: Exception information: Exception type: CatalogDatabaseException Exception message: Category search failed. Request information: Request URL: http://training.carpetone.com/CarpetOne/Templates/Misc/SearchResults.aspx NRMODE=Published&NRNODEGUID={1C4BBD4E-1A73-4A5F-AE39-32E7505C48F0}&NRORIGINALURL=/Search%2520Results searchType=ProductCatg&catg=Carpet&NRCACHEHINT=NoModifyGuest&catg=Carpet&searchType=ProductCatg I then turn ...Show All

• Visual C# Curious Control Losing Focus Problem

  I'm writing an application that takes text from a rich text box puts it in an html file and loads it up in a web browser control. When you type in the rich text box, a timer fires and waits to see if you are still typing. When you have finished typing it will update the browser. This system works fine and the controls keep their focus as expected. However, if i simply click in the browser and then click back into the rich text box and begin to type, once the timer fires to update the browser, the focus never goes back to the rich text box until i click it again and I will lose focus again after i type. I've tried to forcefully give the focus back after the browser refreshes, but i'm not having any luck(i might not be doing it late enough, ...Show All

• Visual C++ Visual C++ vs Visual C# performance?

  Hi! If I port my project from Visual C# to Visual C++, will I gain more performance ~Matt The C++ optimizations can be better for high speed calculations if you go from C# to C++/CLI (C++ for .NET), but we're not talking an order of magnitude. Going to native C++ can be a huge improvement depending on your algorithm, though I would not recommend it. My best advice is to add a C++/CLI dll for the speed sensitive stuff and call native code within that, or do hand optimized assembly. Porting the entire project is almost never a good idea. ...Show All

• Visual Studio Express Editions DataColumn.Expression to calc Date difference

  Hello, I have two DateTime columns in a table, and I want to calculate the day difference between the two, and display it in another column. I add a DataColumn in Dataset, and write an equation in Expression property as below: Convert(RequiredDate,'System.Double')-Convert(OrderDate,'System.Double') But it does not work, I have also searched help in MSDN: http://msdn2.microsoft.com/en-us/library/system.data.datacolumn.expression(VS.80).aspx However, I can't find anything helpful. Anyone give an advice thanks! It might be easier if you do the date difference in the backend database. If you are using SQL Server at the backend, you can use DATEDIFF function: SELECT   & ...Show All

• Windows Forms ToolTips on DataGridView Column/cells

  I have a DataGridView which is bind to a DataSet and the DataMember is set to a table. This all works fine. Now I want Tooltips for each cell of a column in the DataGridView. In design-mode, I've added all the necessary columns (right click DataGridView, edit columns...) and sets the property ToolTip to something. But this is only for the ColumnHeader of the column. I want a ToolTip for ach cell in a column. For example, my first column is an image to delete the row. If the user hovers the images, there must be a ToolTip saying 'Click here to delete the row' Anyone an idea to solve this I think it is solvable to add per row a datagridcellstyle, but it looks not that performant. Thx Handle the CellFormatti ...Show All

• Visual Basic CreateWindowEx

  Hi Everyone again, finally, i got how to replace the start button of xp. u need to call 2 api's: findwindowex and createwindowex. and i got a question on the 2nd one: visual basic code: First all, you are going to have to "Hook" the start button to receive messages intended for it. Make your form hidden until it receive the hooked message it the forms winproc. Then set the form to topmost=true and it should cover the button and system tray by setting the form location corrdinates. Upon receving the hook message, make the form visible. ...Show All

• SQL Server Licensing of SQL Server 2005

  what would be the most cost efficient way of acquiring sql server 2005 licenses for 10000 users that would access 1 web server which access the sql server 2005 . Hope youcan help me at this one... Thanks Find a MS supplier, and do the math. I would say that licensing the SQL Server per processor would make sense. The CAL model, User Cals would work out at 1,628,487 for 10K users. You could license 68 processors for that money. Those prices are "Example Prices" for Enterprise Edition from the link below, which is low volume discount. You can get much better discounts through the various purchasing schemes. Microsoft SQL Server: How to Buy Microsoft SQL Server ( http://www.microsoft ...Show All

• Gadgets Gadget for spaces only ?

  We're writing a gadget with setprefererce, the behaviour of the gadget on spaces is good,but on live.com it doesn't work. The gadget isn't even intended for live.com because it has no usefull function over there. I thought I saw once a gadget that gives a message 'not intended for live.com' when you press add to live.com does anybody know how to deal with this issue Ergo what kind of code should be added, I suppose in the *.js Thanks in advance. You can put specific code in to display a message that it's not intended for live.com using the p_args.onDashboard = true. What that is true.. then display the sorry page that it's not intended for live.com ...Show All

• .NET Development Problem with GetHostEntry

  Hi, my little program shall resolve a name or a ipaddress with method DNS.GetHostEntry, but it doesn't work fine. Dim a As System.Net.IPHostEntry a = Dns.GetHostEntry(" www.netzmix.com ") With www.netzmix.com it works fine, but with a ipadress it fires a exception. Dim a As System.Net.IPHostEntry a = Dns.GetHostEntry(" 192.166.200.220 ") Following exception comes: System.Net.Sockets.SocketException: the given host is unknown. There is a trace for different targets: System.Net.Sockets Verbose: 0 : [3460] Exiting DNS::GetHostByName() -> IPHostEntry#17059405 System.Net.Sockets Verbose: 0 : [3460] Exiting DNS::GetHostEntry() -> IPHostEntry#17059405 System.Net.Sockets Verbose: 0 : [3460] ...Show All

• Visual C++ VS .Net 2005, how to disable intellisense...

  Hi I am really frustrated with the performance of VS .Net 2005. This is because I always see at the bottom "updating intellisense..." and it uses 60% to 70% of CPU. How to disable this updating of intellisense... Please this is making Visual studio unusable. Thanks Chandra Hi Chandra, Could you describe the size of your solution Do you have many projects Do you find yourself changing the headers often Do you change configurations often (e.g. from debug to release and back) Does your code make heavy use of preprocessor macros Thanks, ...Show All

• Visual Studio Team System Training material for integrating into Team Builds

  Hi, I am currently using datadude in a Team Foundation Server (TFS) environment and we want to include the database builds as part of our continuous integration (CI) builds. Are there any guidelines on doing this I'd really appreciate some material (papers, videos, best practices etc...) on how we might do this and the pitfalls we should expect. I'd also like to see something around how we move objects and data from our build environment through our dev/test/QA/live environments because one thing is for sure- you can't just treat databases the same as you would normal code. Currently we are considering using schema/data compare features of Datadude to compare our build environment with our test environment and then the resulta ...Show All

• Visual C++ dll build successful, no dll created

  I'm new to VC8, and I tried to create simple unmanaged DLL using C++. At the end everything compiled and linked without errors, but when I looked into output directory, there were no dll or lib files. Then I tried to compile just code generated with Project wizard - Win32 - DLL. There were no errors but no DLL too. Then I turned back to VC++ 2003 and did the same - my library DLL was created and code from wizard worked too. After all I tried to convert projects from 2003 to 2005 and voila - they compiled in 2005 too. I have searched net for answer, but didn't found one. So I'm asking: What has to be done to make DLL appear after successful linking in VC++ 2005. I believe I'm just dumb and don't see some obvious thing that ha ...Show All

• Visual Studio Team System SQL error = 7202 on linked servers

  Hi, I have created 5 projects using the new database project wizard. Importing the scema from SQL Server 2005 with no problems but one. I keep getting this error message even though when I query sysservers there is a server named ANNEALING. The SQL code works great on the on-line server. "Error 166 TSD4001: Could not find server 'ANNEALING' in sysservers. Execute sp_addlinkedserver to add the server to sysservers. (SQL error = 7202) C:\Documents and Settings\donron\My Documents\Visual Studio 2005\Projects\CMC-iSQL-SERVER_RuntimeAnnex\CMC-iSQL-SERVER_RuntimeAnnex\Schema Objects\Stored Procedures\dbo.HBADailyStackCollector.proc.sql 6 1 CMC-iSQL-SERVER_RuntimeAnnex" I have the same type of SQL code in another databas ...Show All