Chumplybum's Q&A profile

• SQL Server Beginners

  I have just started learning SQL server. Where from I start. I have downloaded SQL Management Studio & SQL Express Edition. Now What should I do now hi, hard to say... at http://www.microsoft.com/downloads/details.aspx FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en you can find the downloadable version of Books OnLine, the on line help for SQL Server... it both contains "insides" about the engine and architecture, as SQL dialect tutorials as well.. it really is a valuable (the best) source of information about SQL Server.. but perhaps the understanding of what a DBMS is, is not included as these are "pre-requisites" to all the fun.. so here all depends on your actual skill a ...Show All

• Community Chat Converting to the C# and .net Environment tips

  Hello all, Currently our Company will be converting from a progress environment to a Microsoft C# environment and I figured I would start this thread for any questions that may arrise and also for all you seasoned vet programmers out there who would like to share some secrents and methods with the world, post them here .I thank all of you in advance. Feel free to contact me at rwalker@aimntls.com for any direct comments. Thanks again. Hello all, Currently our Company will be converting from a Progress environment to a Microsoft C# environment and I figured I would start this thread for any questions that may arrise and also for all you seasoned vet programmers out there who would like to share some secrents and methods with the world, ...Show All

• Gadgets OT: Suggestions about gallery.live.com

  Several things stand out about this site, now that people are starting to use it. So, here's some suggestions: Implement some sort of language filtering. Although I have nothing against the use of non-English and think it's actually commendable than MS allowing it, I would rather filter out Gadgets that are of no use to me. Alternatively allow multiple languages in the Gadget description, or some form of language translation. Improve Gadget images. It would be great if you could attach screenshots, as well as the 100x100 icon. Do something about Gadget spam. "Vamos Strip Player" springs to mind, I'd hate to think how many times it's posted. Remove the 1000 character limit on the description field, and allow it to be rich text ...Show All

• .NET Development Interop Thread Leak?

  Hi, I'm hoping for a few pointers for tracking down a resource leak. I developed a VB 2.0 indexing application which is using FileNet's Capture COM objects and we're occasionally seeing a fairly serious leak. It doesn't appear to happen consistently (one user has never had one and I can't seem to reproduce it in my test environment), but it does occur regularly in production. I've been using various tools to poke around in a mini-dump (w/ full memory) and I've seen a few potential problem areas, but I can't seem narrow it down any further. Using PerfMon I found that the leak appears to be in private unmanaged memory. When I open the dump in WinDbg, I get this message: This dump file has an exception of interest stored in it ...Show All

• SQL Server Determining data type of cell in cellset

  I need to determine the data type of individual cells, specifically if they are currencies or percentages. The Cell.Value property contains a Double and the Cell.FormattedValue may have a currency formatted string if it's defined correctly in AS; however, due to internationalization issues I obviously should not be looking at the FormattedValue property to determine the cell's data type. This seems like it would be easy, but so far I can not see how to do this using the available metadata brought back from a cellset. Any suggestions Thanks, Terry ...Show All

• Visual C# Generate random location

  Hi, I've encountered a weird problem. I'm working on a small game, using C# and VS2005. You're supposed to move a character (the "hero", its basically just an image drawn on the form) around the form to pick up an item; another image drawn on the form. When the item has been picked up it moves to another location (you move up a level). When the item's location is hardcoded or moved using int x = 50; int y = 50; ... x += 10; //when item's found, move it y += 10; item.Location = new Point(x, y); everything works fine, when the character image "touches" the item, it is found. The problem is when I try to set a new location to the item using Random Random rand = new Random(); int x, y ...Show All

• .NET Development xsd.exe fails to create common data types out of nested schemas

  Hi, with the contract first approach we have some xsd schemas as the core interface definitions. We outsourced common data types (enumerations and some length limited string types) in a shared common.xsd file which in turn is <import> ed into the top level xsd schemas. We tried to generate .cs code files with xsd.exe in this scenario. But all the generated code files repeatingly contain the common data type definitions. This leads into several compiler errors. Using different namespace delcarations for each generated class does not solve the problem: The shared character of our common data types is completely lost after code generation with xsd.exe ! It seems to be a popular problem, because shared data types is a commonly u ...Show All

• SQL Server API for creating user or group

  What's the SOAP API call to create a user or group It seems that when someone successfully logs into Report Server, a new user is created for that user. However, is it possible to create a list of users on demand RS only adds the users to it's database when it needs to reference the user. If a user creates an item in the catalog or subscribes to a report, the user will be added to our database. As you said, Report Manager uses the Soap API so it doesn't create any users, it only makes soap calls which may result in a new user row in the RS database. Is there a reason you feel that the RS database needs to have the user table populated As long as your security extension knows the users, what RS st ...Show All

• Software Development for Windows Vista blocked flag in instanceState table

  Hi, is there any possibility to influence the entry value (0 or 1) of the column "blocked" in the "instanceState" table, without using a customPersistenceService Thanks and Regards, Christoph Sonali, does that mean that if your workflow is in a idle state in a delay activity (with PersistOnIdle=true) and a crash occurs, your Blocked flag is still set to 1; if you reload the workflow, nothing will happen unless you change Blocked to 0; ==>the restarting host must set it to 0 to move the next workitem (even if the delay expired) Serge ...Show All

• Software Development for Windows Vista some question about workflow status in state machine

  Hello , I am trying to create a Form approve process (state machine workflow exposed as webservice). It has the following states. Create, open, update. close.My question is below: 1.Lets we now are in the "create" state, then user do some action , the form state goes to the open state , now then user close the form , 2.Next time when the user reopen the same form , the form state should be in the "open "state, but when user reopen the form , the form state is still in the create state . my question is there any method , when user reopen the form , the form process can contine the process from last time but not re-do the form process.that means how can i transfer the form current state to workflow so the form ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Heightmap Terrain Component

  I thought the whole component concept was pretty cool. So I threw together a quick heightmap terrain component. http://i9.photobucket.com/albums/a59/craigory666/heightMapTerrain.jpg http://i9.photobucket.com/albums/a59/craigory666/heightMapTerrain2.jpg http://i9.photobucket.com/albums/a59/craigory666/heightmapprop.jpg It should work with square .raw files, and for the effectPath I'm just using the default texture shader found in the help file. The view and projection matrices of the terrain are exposed, so you should be able to hook up whatever camera you have going and just update the terrains view, and projection matrices during your games update. using System; using System.Collections.Generic; using System.IO; using Microsoft.Xna.Fr ...Show All

• Windows Forms BindingSource multiple DataGridViews...

  I have three different tables in my database, and they all have a relation. I want to show each table in a seperate DataGridView object. My understanding is, you need a seperate BindingSource object for each DataGridView. Example: DataRelation relation = new DataRelation("CustomersOrders", data.Tables["Customers"].Columns["CustomerID"], data.Tables["Orders"].Columns["CustomerID"]); data.Relations.Add(relation); masterBindingSource.DataSource = data; masterBindingSource.DataMember = "Customers"; detailsBindingSource.DataSource = masterBindingSource; detailsBindingSource.DataMember = "CustomersOrders"; === Then you set one DataGridView.ataSour ...Show All

• Visual C++ Using CTS in RS232 Comm

  Trying to send data using a COM port to a device that uses CTS to control data flow. Using OpenFile and WriteFile. Setting the dcb.fOutxCtsFlow seems to have no effect on the output stream, the system sends out characters when CTS is not asserted. Thanks for any help, Bob Thank you for your reply! I did not call WaitCommState(), and when i first time call the GetModemSatus(), it returns ok, but call it next time it will return error. ...Show All

• SQL Server Monitoring SQL Server activies from an outside environment

  Hi, I don't know if this is the right place to post this kind of question (moderators, please move it to the right place if it's not here). I want to know how can I monitor some operations that are executed on a SQL Server database. Operations like: INSERT, DELETE, UPDATE, transactions, and so on (I know that I can do this using triggers, but doing this way I'll have to fill a table with the information from the triggers and stay loading the table data all the time. I want a way to monitor using other resources, in realtime). My idea is to build a program to monitor these activities (C# to be more exactly). How can I do this Thanks SMO is a set of object libraries that allow you to manage SQL Server. What I think you're l ...Show All

• SQL Server How to join 2 datasets without sorting

  Hi, In one of my packages, I have join data from 2 data sets. The problem is 'Join' requires both dataset to be sorted and I can't sort one dataset without 'sort' transformation. The real problem is since I have to sort 65million records, the sort operation sucks always. The other option is using 'Lookup', but since I have to do 'Range Lookup', it is taking hours and hours to process less # of records. My question is, is there any other way, I can do join of 2 datasets without sorting Timothy Tim wrote: Just curious as to why we need to sort it when I don't really need it to be I don't necessarily care for Merge Join I could be happy with Nested or Hash. Any join operation requires a sort. This is no ...Show All