rahulsk1947's Q&A profile

• SQL Server High CPU utilization

  Could anyone help me in finding out why the cpu utilization is very high I have two servers say, Server A , server B. There is a transactional replication going on from server A to B There is a table say Table A on server A, which is being replicated to server B. I created a trigger insert and update trigger on Table A on server B (i.e. on subscriber). Since then, the CPU utilization for server B is very high 80-90% when i used profiler, i could see .whenever replication stored proc for insert or update executes..cpu utilization goes up.. trigger just insert the updated/inserted rows into some other table. Could anyone tell me why the cpu utilization has gone up so much i am using sql server 2005 thanx ...Show All

• Visual Studio Tools for Office Excel cell data validation dropdown

  All, I am trying to programmatically add data validation to n number of cells in my spreadsheet. Ideally I would like to add a named range to a drop down list AND default the selected item to a value from my database. There isn't much information out there regarding doing this in c #. Based on my attempt at decoding the one visual basic example I found here is my code: for (int i=0; i<someVariableInteger; i++ { cellAddr = "D" + (i + 7); rng = this .Application.get_Range(cellAddr, missing); rng.Validation.Delete(); rng.Validation.Add(Excel. XlDVType .xlValidateList, missing, missing, "=ProjectCategory" , missing); rng.Validation.Modify (Excel. XlDVType .xlValidateList, missing, missing, ...Show All

• Windows Forms DataGridView - Displaying objects that have been added to the DataSource

  Hi, I've got a datagridview whos datasource is a List<MyObject>. An external program adds items to this list and at this time i want to refresh the datagridview to show the new items. I've tried many methods such as suspending and resuming the binding but i can'just can't get it to show the updated list. Anybody any ideas Thanks in Advance JK That will work. It will be easier, though, if m_countries was a BindingList<Country> instead of a List<Country>. That way you don't have to recreate a new BindingList object every time you want to add a country. ...Show All

• SQL Server shrink tempdb

  I have a sql2000 server that has a 24 /7 uptime. The tempdb size is increasing rapidly. it was 4 Gbs and i restarted the sql server to shrink the tempdb size which worked fine. but now after 1 week then tempdb size is almost 1.5gbs. Is there anyway that i can shrink the tempDb without restarting it. Asking the users to stop using for a certain timeframe after every month or so seems like a hassle for the users. Steven Trout wrote: I found the same result with a search engine, but is there any reason not use to SQL Enterprise Manager If you right-click on the tempdb, All Tasks, you get the option to shrink the database there. Is that a bad idea No. That's equivalent to 'dbcc shrinkdatabase'. ...Show All

• Smart Device Development GetSystemMenu()

  I am trying to add additional menu items to the Call State menu once a call has been made. I was trying to use GetSystemMenu(), but I receive a MissingMethodException. So, I guess it doesn't exist. Any ideas on what methods I should use to get a handle to a system menu and add menuitems to it Thanks Harry Windows Mobile provides a way to extend the menus of the built-in applications. Please check the MSDN documentation on Menu extensibility located at: http://msdn2.microsoft.com/en-us/library/ms879952.aspx . Hope this helps Michael ...Show All

• .NET Development 8 byte Guid’s with .NET

  Hello folks, is there a possibility in .NET to generate 8 byte Guid’s Or do i have to generate them on my own Thx for your replies. Kris It’s not 100% secure but an incrementing integer is easily predictable. How wide are the NEWID-GUID’s from SQL-Server I have a limit of 20-digits. ...Show All

• Audio and Video Development Getting a VC-1 file ready for advanced content authoring

  Hi all, I just started to author advanced hddvd content but i vailed in getting a valid video content to test my first project. is it possible to multiplex a VC-1 file with the Sonic authoring system for standard HD content in a way that i can use it for my first advanced content project I tried to import the vc-1 file into sonic, generated a simple autostart HDDVD, multiplexed it and used the HVDVD_TS folder for my advanced content project but it didn't work. The Nero Showtime softwareplayer diplayed the menu correctly but didn't play the video. I also tried to burn a dvd rom and inserted it into my Thosiba HD_DVD player but it just displayed the disc error 0x4095C501. Can anybody help me thx mikeret ...Show All

• .NET Development WebException: The underlying connection was closed

  Hi After upgrading our win client app to run on version 2.0 of the .net framework (prev. v1.1) on of our customers reports the following error when calling a web service on our server: System.Net.WebException: The underlying connection was closed: A connection that was expected to be kept alive was closed by the server. The customer is using a proxy-server, but it worked fine before the upgrade, and other customers who are behind proxy-servers has no problems. The error does not occur when the customer accesses the web service using Internet Explorer. The customer is behind a firewall. /Daniel This is not an answer, but similar problem. Having the same problem using .net ...Show All

• Visual C# How to use IME (Input Method Editor) in C# (for Asian Language)?

  Hello friends, I want to develop a web application in ASP.Net using C#, in which, we provide a facility to the user to choose any one Indian Language from a drop down list and after that able to enter language specific character. So, plz, help me how to develop such kind of application Can you provide source code for IME (Input Method Editor) that I can integrate it Jitendra Kumar Mehta http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1060060&SiteID=1 ...Show All

• Visual C# Change ReadBufferSize...

  Hi there. I want to change the ReadBufferSize value of a Serial Port object. The ReadBufferSize property has the following form: public int ReadBufferSize { get ; set ; } When I am writting to my code port.ReadBufferSize = 300000, where port is the serial port object, nothing seems to happen. What might be the problem and what am I doing wrong I would really appreciate any help of you. Thank you in advance.. Hi, the property ReadBufferSize needs to be declared as follows: ---------------------------------------------------- 1)You need to have an int variable and then  define property.    private   int nReadBufSize;     public int ReadBufferSize  ...Show All

• Visual Studio 2008 (Pre-release) apply Aero style upon custom class button

  when i create a new custom button control like the following public class MyButton : Button { } and i am using the Aero theme like the following public partial class App : System.Windows. Application { public App() { Uri uri = new Uri ( "PresentationFramework.Aero;V3.0.0.0;31bf3856ad364e35;component\\themes/aero.normalcolor.xaml" , UriKind .Relative); this .Resources.MergedDictionaries.Add( Application .LoadComponent(uri) as ResourceDictionary ); } } and when i used my custom control , the Aero style dosn't applied on the control < Window x:Class = " WindowsApplication1.Window1 " xmlns = " http://schemas.microsoft.com/winfx/2006/xaml/p ...Show All

• SQL Server cant get any event from FormsAuthentication Sample in the report server ?

  Hi i have used http://msdn2.microsoft.com/en-gb/library/ms160724.aspx to enable custom security in the report server,now custom security sample is working fine with my report server, So bigger problem is my Software manager ask me to redesighn UILogon.aspx page  Now the bigger problem is when redesign the UILogon.aspx page  I am having lot of problems in the sample ,thing is i cant get any button event from the code behind it self  Error is saying that  "cannot handle Event 'Public Event Click(sender As Object, e As System.Web.UI.ImageClickEventArgs)' because they do not have the same signature." Whats is the wrong with this     regards sujithf   ...Show All

• SQL Server send user

  Hi everyone!! I have a system that will be accessed on internet/extranet. And they will grant the access to this system from an AD. I thought I could grant the users by its login in the AD. But I noticed that the reporting services grants to the user that logon on the pc. A way to resolve my problem would be sending as parameter a default user that have access to these reports. Anyone have an idea of how I could do it Or another solution to my problem. Best regards! Pedro Hi Jordi! thanks for reply. They won’t be windows users because the AD will check the login and password to grant access to this extranet system. And the users will access it from internet. I though ...Show All

• .NET Development Why there is a blank line when a row is set to style:display=none?

  Hello, I have a table with three rows, the rows need to be set to visible or invisible. The current problem is: when I set row 1 and 2 to invisible, there are still two blank rows above the third visible row, why how to remove it Thanks. Code is as below: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <body> <form name="Form1" method="post" id="Form1"> <table id="DataList1" cellspacing="0" border="0" style="width:100%;border-collapse:collapse;"> <tr> <td> <TABLE id="Table5" cellSpacing="1" cellPadding="1" width="70%" border="0&qu ...Show All

• SQL Server Looking for sqlrun_tools.msi

  Today my computer started doing something strange when trying to compile a setup&deployment project. This project doesn't contain anything related to sql server whatsoever. When i compile, it pops up a windows installer dialog that starts doing something. Eventually it asks me for my Sql Server 2005 Tools disc, specifically looking for sqlrun_tools.msi. I tried putting in the disc that i'm pretty sure it was installed from (my MSDN disc) but it told me that the sqlrun_tools.msi on that disc wasn't the right one. I have no idea why its asking me for this at this time, nor do i know to do to get it to stop. Thanks in advance for any help. I am having the same problem. Whenever I try and b ...Show All