Russ P's Q&A profile

• SQL Server Replication Tables page in BOL doesn't refer to MSMERGE_ARTICLEHISTORY

  Hi, Not sure if I should post this here or at connect but I noticed that ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/5696ee73-5d7c-4f26-b7ee-6831c9c3edf7.htm doesn't include MSMERGE_ARTICLEHISTORY but that this table is referenced here in BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rpldata9/html/7d4c67e4-d683-4ba5-81bd-e6ce4f7489bf.htm Also if anyone is looking at doing anything with the first link I think it would be great if they subdivided these tables into the types of replication and not just into the databases in which they can be found. I know it's a bit of a difficult one given tables can exist in more than one place but I think that would be helpful. Cheers, James ...Show All

• .NET Development XPath - Get node

  Hi I have this XML structure: <Doc> <Values> <value a="100" b="131" c="20" /> <value a="100" b="130" c="20" /> <value a="23" b="400" c="20" /> <value a="2" b="1" c="110" /> <value a="2" b="1" c="100" /> <value a="0" b="30" c="2" /> </Values> </Doc> As you see the nodes are sorted in descending order by first "a", then "b" and last "c". I now want to insert <value a="100" b="10" c="11" />. This new node should be inserted a ...Show All

• .NET Development using SqlTransaction, is Dispose called after exception?

  Using the following code: using (SqlConnection connection = GetConnection()) { using (SqlTransaction transaction = connection.BeginTransaction()) { Save(transaction, obj); transaction.Commit(); } } If the Save method throws an exception, is the transaction's .Dispose() method still called causing .Rollback() to occur I believe I have read that the connection's .Dispose() is called, thus ensuring .Close() but haven't seen a confirmation of this for SqlTransaction. I would assume that it works the same for both, but does anyone know for sure I found a discussion on CodeProject about this approach, but it is pretty much people arguing over what is simple vs. rig ...Show All

• Visual C# WIA v2.0 Capturing pictures from Webcam

  Hello everyone. I can successfully take pictures with my webcam using Windows Image Acquisition (WIA) v2.0 and C# 2005 Express by using Device.ExecuteCommand. However, the problem is that it takes several seconds to take a single picture. I need to somehow take atleast one to two snaps each second. How can I take pictures more quickly Thanks, Ashish Ashish, there might be some unnecessary initialization involved, or you might be pushing the limit of your connection. There is a similar project here , where the auhor claims to have a good frame rate. HTH --mc ...Show All

• .NET Development mem usage keeps growing :(

  Hi, Its a very simple app. When you click a button it will scan a specified directory for *.mp3 files: DirectoryInfo di = new DirectoryInfo(directoryTxt.Text); FileInfo[] fi = di.GetFiles("*.mp3", SearchOption.AllDirectories); and for each file, is gonna create an object of structure type Mp3File (simple struct with just 4 string fields for name, title, artist and album): for (int i = 0; i < fi.Length; i++) { Mp3File m = ID3Reader.ReadID3Tags(fi[ ].FullName); this.progressBar.PerformStep(); } the Mp3File object is given by the ReadID3Tags method which goes like: public static Mp3File ReadID3Tags(string path) { Mp3File mp3File = new Mp3File(); string fileName = path.Substring(path.LastIndexOf("\\") + 1); string fileP ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Why is Game not a singleton?

  I'm a bit puzzled by this  - why is the game class not a singleton, i.e. there is and can be only ever one instance of it. I can't quite see any sensible reason to have more than one of them, but as it doesn't seem to be a singleton, I have to hold a reference to it anywhere I want to access game services from. Otherwise I could have just written Game.Instance.Services when I wanted access to them. Or perhaps I have missed something obvious (I know I can make my class that is derived from Game use this pattern, I'm just curious as to why it wasn't done like this in the framework in case I shouldn't be doing it either). I dont see why you cant add some static members to game to do just t ...Show All

• SQL Server Custom Data Flow Task throwing error when run from command prompt

  Hi, I developed a custom data flow task in .net 2.0 using Visual Studio 2005. I installed it into GAC using GACUTIL and also copied it into the pipeline directory. This task runs absolutely fine when I run it on my local machine both in BIDS and using the script in windows 2000 environment. However, when I deployed this package into a windows 2003 server, the package fails at the custom task level. I checked the GAC in windows\assembly directory and it is present. Also I copied the file into the PipeLine directory and verified that I copied it into the correct pipeline directory by checking the registry. The version of the assembly is still Debug. I looked up documentation in MSDN but there is very little information about the error ...Show All

• Visual C++ Capturing API Calls

  What would the easiest way of capturing an API call in C++ For example i run IE, my application counts how many times IE calls GetActiveWindow(). <<only an example. cheers, metz-. Yeah, thanks for the reply, id prefer to do this programmatically, ill take a look at Detours. cheers, cory. ...Show All

• Visual Studio A problem with SetDataSource

  Please, help! I have a report, created based on a SQL command. I pass it a datasource filtered for a specific name but crystal still shows me data for all names instead of my datasource contents. Here is my code: ..... create dataset .... Dim rptDocument As New CrystalDecisions.CrystalReports.Engine.ReportDocument rptDocument.Load(ReportName) rptDocument.SetDataSource(ds.Tables(0)) rptDocument.Refresh() crw.ReportSource = rptDocument same result. Report just ignores my dataset: rptDocument.Database.Tables(0).SetDataSource(ds.Tables(0)) crw.ReportSource = rptDocument grd.DataSource = dt ...Show All

• Visual C# What's the point of RegisterForEventValidation and ValidateEvent?

  I don't get it!!!! This is with reference to this arcticle on Client Callback with Validation -> http://msdn2.microsoft.com/en-us/library/ms366515.aspx I don't see what the additional RegisterForEventValidation and ValidateEvent calls gives you. It seems to be an attempt to tie the call to a particular control but all the control references are hard-coded on the server-side. In the example given you could just as easily use any word you liked for the unique reference in these two calls (as long as they match). They don't seem to need to bear any relation to the controls on the web page. Hopefully I'm completely missing the point. Is so, can someone please explain it to me. Thanks. Ev ...Show All

• .NET Development Retrieve output inserted multiple columns

  Hi everybody I execute the following sql statement in order to retrieve 2 consecutive identities: delete from empaward where EawSystemID = '64SZGE000080' INSERT INTO EmpAward ( EawAwardID, EawProvider, EawEEID, EawSystemID ) output inserted.EawID AS [EAWID_e596fb61_2df9_422f_8173_d7038536d74c] VALUES ( 'EM', 'Z', '3EZ9C605L080', '64SZGE000080' ) delete from empaward where EawSystemID = '64SZGE000080' INSERT INTO EmpAward ( EawAwardID, EawProvider, EawEEID, EawSystemID ) output inserted.EawID AS [EAWID_e596fb61_2df9_422f_8173_d7038536d74d] VALUES ( 'EM', 'Z', '3EZ9C605L080', '64SZGE000080' ) When I run that in the SQL Query analyzer I get 2 different consecutive values. Then I try to retrieve the results from an ADO.NET applica ...Show All

• Visual Studio Tools for Office CommandBarButton not getting deleted in MS Word

  I am developing an Add-In for Word/Excel/PowerPoint applications. I am using Office 2003. In the OnBeginShutDown method, I am trying to delete the existing button. The button gets deleted for Excel and PowerPoint. But for Word, it is throwing " Exception from HRESULT: 0x800A01A8 " exception. Please suggest me a fix for this or atleast an alternative to prevent this exception. Hi Sandesh, This is quite a common issue with Word and you can find solution to this in http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=356963&SiteID=1&mode=1&PageID=0  thread.   ...Show All

• Software Development for Windows Vista Why does Windows Defender block my startup program? How to resolve this problem?

  Hello everyone! I have a problem that other people may have as well. I added my program into Windows Startup, the registry entry is locate at CURRENT_USER/.../Run. Everytime Vista starts up, Windows Defender blocks my program. I found that my program hadn't got the signature certification. So as Google Talk, but it hasn't got signature certification too. So, how can I resolve this problem and let me program run at Windows Startup Please note that this forum is geared toward software developers creating their own products. That said, see the following knowledge base article for help on your issue: http://support.microsoft.com/default.aspx/kb/930367 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Xbox Live Arcade

  Do any of you reckon that it's possible to make a game using the XNA express framework, and then get it published (by MS or otherwise). I think, looking at the standard of games on Xbox Live Arcade, that I can make a much better game than anything there. What's to stop "underground" gaming or is it "indie" gaming from having some really great titles and distribute them themselves Is that against the EULA ...Show All

• SQL Server difference among them

  Hi everyone, What is the real difference among them CREATE PROCEDURE sp_devamsizlik @ADI CHAR(20) AS SELECT * FROM OGRENCI WHERE ADI=@ADI GO -------------------------------------------------------------------------------------- CREATE FUNCTION sp_devamsizlik ( @ADI CHAR(20) ) RETURN TABLE BEGIN RETURN( SELECT * FROM OGRENCI WHERE ADI=@ADI ) END Hi Sorry there is an error in the posted syntex: actually In Stored Procedure you can cal ...Show All