Nagu's Q&A profile

• Visual C++ CertAddCertificateContextToStore

  I have a question about CertAddCertificateContextToStore() function in CryptoAPI. As you can see from the function name, this function adds a certificate context, represented as CERT_CONTEXT structure, to the certificate store. A CERT_CONTEXT structure contains in its elements the encoded certificate and the CERT_INFO structure which contains each element of the certificate. Now, what will happen if the encoded certificate and the elements in the CERT_INFO structure are NOT consistent In other words, what will happen if the CERT_INFO structure contains incorrect data Your kind help will be appreciated. Hello Re: CertAddCertificateContextToStore Such questions are outsid ...Show All

• SQL Server SQL Server Configuration Manager to change run as account

  Hi, For the past few days i have been stumped on this problem. Our environment is the following: Windows 2003 R2 64 bit  SQL 2005 SP1 64 bit active/active cluster with several instances. Right now all instances use the same domain account to log on. For security reasons i wanted to assign a domain account for each instance to use. Now the problems start when i am using SQL Server Configuration Manager. I am usually successful in changing an instances SQL server account but once i try and do it for the SQL Server Agent i start to get errors and i am unable to get both running at the same time. Sometimes i will get wmi errors and sometimes the mmc just stops responding. The WMI error i get often is: The server ...Show All

• SQL Server notification service

  hi all, I need help from some one expert or have an idea about How i can send notification emails to my customers that i added in SQL 2005 table using notification service. notice: - my customers informations exists in table in my SQL DataBase. thanks alot You may want to start by going through the walk-through sample application that comes with Notification Services. It provides a pretty good introduction to the product and how it can be used. HTH... Joe ...Show All

• Visual Studio Express Editions Using the help centre

  hi guys , i m quite new in C# programming and finding it difficult to understand the help files providec with the SDK...i m not new to programming can someone tell me some good place to start of with.... Thanks in advance... Hi, hula This thread has what you can begin with: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1221320&SiteID=1 Thanks ...Show All

• SQL Server WMI Event Watcher - Pointing directly to a machine name

  Hi, I am using a WMI Event Watcher task to watch for files dropped into a directory over a network drive. It seems to work fine when it is pointed to a physical drive name, but not when I use a machine name. I.e. This works - SELECT * FROM __InstanceCreationEvent WITHIN 10 WHERE TargetInstance ISA "CIM_DirectoryContainsFile" and TargetInstance.GroupComponent= "Win32_Directory.Name=\"C:\\\\temp\\\\folder1\\\\folder2\\\folder3\"" This fails - SELECT * FROM __InstanceCreationEvent WITHIN 10 WHERE TargetInstance ISA "CIM_DirectoryContainsFile" and TargetInstance.GroupComponent= "Win32_Directory.Name=\ \\\\\\\\machineName \\\\folder1\\\\folder2\\\\folder3\ " The failing code do ...Show All

• SQL Server Identifying a table update / insert / delete

  How to find out that a table has changed. For example if a table has 50K rows, and if any update, insert, or delete was made it should be captured without using any trigger. Is it possible to get such information from any of the system table or DMVs What you are looking for is a way to read out the transaction log. Some third party software can do this, such like "Log Explor' of Lumigent. ...Show All

• .NET Development raising an event via reflection

  Using reflection is it possible to check if an event has a handler and more importantly raise that event. I have a string with a value of the event and the object instance which I need to fire. Have you tried this in your called assembly when you are rasing event; if(SomeEvent != null) { SomeEvent(this, EventArgs.Empty); } And yes Sorry I listened for the first time that there is an EventInfo class, I'll have a look on this. Man is always learning :$. Try this and tell me what happens. Best Regards, ...Show All

• SQL Server performance: memory usage: any way to flush memory?

  Hello, we are using SQL Server 2000 on Win2k3 machine we are having different sproc's that have a structure like: create table #tmp1 @query = 'insert into #tmp select from ......' if condition1 append where clause1 if condition2 append where clause2 exec(@query) while loop @query = 'update #tmp set col1 = (complex select stmt.....)' exec(@query) select * from #tmp drop table #tmp this proc is using multiple tables, some of them having records around 50k. when this sproc is getting executed, memory usage of sqlservr increases but when the execution completes, it doesn't reduce the memory usage though we are dropping the temp table explicitly. we even tried deleting all the records of temp table, before dropping it. s ...Show All

• SQL Server How do I update a field only if update value is not null?

  Hi. I'm not  such an expert in sql and I wanted to update a table's fields only if the value that im going to update it with is not null. How do I do that What I mean is something like: --------------------------------------------------- Update database.dbo.table set if(@newvalue !=null)      afield = @newvalue; -------------------------------------------------   Really need your help on this. Thanks. Wow, that's really amazing... Really lots of thanks. I just tried it out and it's exactly what I was looking for. ...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

• SQL Server using Dts.LOG within event handler

  Hi, I am trying to Log my activities when OnError event handler fires I have defined few tasks in OnError event handler section so when there is a failer on the main package my OnError task runs ( which it work fine) now I am trying to add Dts.LOG from inside OnError evend handler task, and it seems like SSIS doens't give that function. I can use dts.log outside on the main package but not inside OnError section! any ideas Thanks Kolf wrote: Thanks for getting back to me I have created a log file and I'm using DTS.LOG("logging content",0,nothing) command in script task to write to the specified long now the problem is if an error happens in the package I have defined an onError event handle ...Show All

• Visual C++ compiling the "selected" project in dev studio 2005 - behavior change

  Hi, We are currently in the process of moving from VC6 to VC8. We have several projects with houndreds of cpp and h files. One of the biggest complaints we get from the developers is the issue of "build selection" button and F7: Our solution is built from several projects, most are static libraries for the main project (the main project having dependencies to these lib projects). When working on the code, developers generally changes a few cpp's without needing to know which one is related to which lib project and in the end they would always compile the main project by pressing F7 or pressing the build - these would automatically build the 'active' project which was always the main project. all relevant libs related cpp's that had changed ...Show All

• Windows Forms Advanced data binding (two way)

  I'm wondering if anyone out there has seen a good assembly that implements two way databinding with ASP.net controls. I'm thinking that it's sorta silly that I have to type: drPerson.FirstName = (( TextBox )item.FindControl( "tbFirstName" )).Text; It seems like I could just type: drPerson.UpdateData(repeaterItem); I'm looking for a more intelligent web control. What's out there Hi, I think you are looking for 2 things: First Typed Datasets and then 2-way databinding for the first thing, take a look at this article , which will help you with the typed dataset. For the second one, there is no way to have a 2 way databinding - if you mean to notify the client if something ...Show All

• Visual Studio VS 2005 Addins to right-click menu

  Hello guys, I try to create VS2005 addin to Team Explorer right-click menu. The idea is: When you open Source Control Explorer, choose the project and right-click on it you'll get the menu. You can choose: <Get Latest Version> and etc from this menu. My purpose to add my own command (Ex: Custom Get) to this menu. Most of the topics I've found in Google are describe how to add command to main command bar - like Tools-><Your command>, but I haven't found anything about right click menu. Please help.... Thanks Then you have to use FileMonitor from www.sysinternals.com to trace disk activity and discover why your add-in does not appear in the Add-In Manager ...Show All

• Visual Studio 2008 (Pre-release) Overlapping elements over a FlowDocument

  Hi, I have a FlowDocument with sections, paragraphs, lines, etc. My target is (for example) to draw two lines in order to create a cross over the page (from angle to angle) so that the lines overlaps the entire page content. Another example is to overlap a big text like "Confidential" over (or behind) the content page. I tired using floaters but they need to be inside an inline, so they take space and modify the flow of the page. I want to overlap those elements without changing the normal flow instead. Thanks, Raffaele You're right Annotations are not INSERTED into a flowdocument/section/paragraph, that are ATTACHED to them. They are not part of the document they are more or less metadata about a document. Agai ...Show All