.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

No CacheMiss Event When Calling SP With No Owner - Applies to 2005?

Posted By:      Posted Date: September 12, 2010    Points: 0   Category :Sql Server
 
Hi, As outlined in knowledge base article 263889 (Description of SQL Server blocking caused by compile locks http://support.microsoft.com/kb/263889) it says you should specify the owner when calling a stored procedure to reduce compile locks.  I've tried this out in SQL Server 2000 by calling a stored procedure without an owner.  As expected in the profiler I can see a CacheMiss then a ExecContextHit. However, if I try exactly the same thing in SQL Server 2005 I never see a CacheMiss event (unless the execution plan needs to be created), I always see a CacheHit first.  Is this something that's been improved in SQL Server 2005?  The knowledge base article says it applies to 2005 at the foot of the page but I can't see it. Thanks for your help.  


View Complete Post


More Related Resource Links

SSRS 2005 - Share Schdeule Execution Event?

  
Hi, I have SSRS 2005 and 10 different "Shared Schedules". Those share schedule has subscribed reports in it (i.e 5 reports in each Share Schedule). I would like to know when share schedule start firing execution event, does it execute all reports ONE at a time OR one-by-one like in queue? When I checked SQL Server Agent Job than it has only ONE step in it. Any idea? Thank You...  

Calling a button's click event from another buttons click event

  
I have a button that checks the users serial number entry in a web form and a button that subits the page.  But if the user does not click the checkbutton  I want to  fire the check click event  from the pages submit click event.  Is this possible.  In my submit click event I call this Me.cmdCheck_Click(sender,e) though it does not seem to be firing the click event is there something that I am doing wrong?  

Viewstate issue when calling button click event from Javascript

  
I have a javascript that asks a confirmation on search click. If the user has made some changes to the data in grid (gridview) on click of Search, a confirmation is asked to Save or Continue Search. If Yes, Save the records by invoking Save click from javascript. If No, Search click is invoked. While Search click happens correctly, Save click results in an error which reads like this..  "Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster. " I know the Viewstate is what causing the problem, where the control is not loaded but script is trying to invoke it's click event. Any help is appreciated. At the end of the day, all i need is to invoke Save click from javascript.   -- Viswanth VG  

What event (if any) is fired on calling ShowDialog on hidden window

  
I initialize a window at the launch of my application and hide it, so that when the user needs to launch it I can quickly show it. I am using showDialog to show the window. I use this window at multiple places. So when the user is done using the window I again hide it. My question is how does the window know that it is visible. 'Loaded' event is no longer fired when I can ShowDialog to show the window. ('Loaded' event is fired the first time I create the window and hide it). Is there any other event that is fired on calling 'ShowDialog' on a hidden window? Thanks for your response.  

Calling Button,s onclick event in javascript code

  

 Hi Experts.

I have a Button control in webpage.

<asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" OnClientClick="test()"/>

When i click on button, i want to check some conditions

Calling a DropDownLIst's Selectedindexchange event on pageload

  

Good Morning,

 

I have an ASP.NET 2.0 that contains a dropdown list used to filter records based on a group number.  For example, if the dropdown list selectedvalue = 3, only records containing a 3 in the group number column of the table will display.  This is working perfectly.  However, when the page first displays the default value is 1, and the records from group 1 do NOT display unless I trigger the dropdown list event.  I am trying to get the records to display for group 1 when the page first opens to avoid having to use the dropdown when the page loads. 

 

The "drop down list control" filters records in a "data list" control.

Problem with calling asp button click event from Java script

  

Dear all ,

 

I m using these following lines of codes in my java script funtion Save()

 

btnSave.click();

parent.window.close();

var btnSave = document.getElementById('<%=btnSave.ClientID%>');

 

In ascx,

<asp:Button runat="server" style="display:

how to prevent an error event from propagating out to the agent job calling the package

  

I'm using an event handler to handle errors when certain control flow tasks fail.  If I can recover from the error, I set System::Propagate = false.  This appears to have the desired effect in that excution continues to the next task and the error was ignored.  The only problem is that when I launch my package through an SQL Server Agent Job, it reports that the job failed eventhough it really succeeded.  Is there anyway to prevent the error from progagating to the agent job? 

I've alternatively tried using failure precedence constraints and got the same results.

If the errors are handled, I want the job to finish execution with a success status.


How to get Workflow Runtime outside SharePoint Workflow class, while calling Handle External Event?

  

Hi,

I have a state based workflow. Now, i want to change its state based on the event raised by my form(Like on Submit). I created the workflow and started it on the item in a doc Library. But, now when i want to register an external event we need to add that local service to the workflow runtime of the current executing workflow.

I am not able to find any way to do that or a workaround to achieve the same.

Does anybody has any idea about this??


Calling a DropDownLIst's Selectedindexchange event on pageload

  

Good Morning,

 

I have an ASP.NET 2.0 that contains a dropdown list used to filter records based on a group number.  For example, if the dropdown list selectedvalue = 3, only records containing a 3 in the group number column of the table will display.  This is working perfectly.  However, when the page first displays the default value is 1, and the records from group 1 do NOT display unless I trigger the dropdown list event.  I am trying to get the records to display for group 1 when the page first opens to avoid having to use the dropdown when the page loads. 

 

The "drop down list con

Calling stored procedure from funciton in sql server 2005

  

Is there any way to call stored procedure from funciton in sql server 2005?

If it is possible, please give some examples.

Thanks.

 


RAHUL Dot Net Developer

How to Encrypt and Decrypt a Password using SQLSERVER 2005?(Video)

  
Encypt and Decrypt a Password using SQLSERVER 2005(Video)

SQL Server 2005 Try and Catch Exception Handling

  
I'm pretty excited to see that there is some real error handling for T-SQL code in SQL Server 2005. It's pretty painful to have your wonderfully architected .NET solution tainted by less-than-VBScript error handling for stored procedures in the database. The big difference being the addition of TRY..CATCH blocks. Let's take a look:

Radio Button Event

  
Here I have explained the events of radio button with javascript.
Let me explain the scenarion first,
We are having two radio button say radioobtn1 and radiobtn2. If I click on the button 1 then I need to show one DIVor FORM. same as when I click on radiobtn 2. I have given the code for the above scenarion.

how to impose javascript event processing?

  

If I have some form control like textbox and I want the event handler to be located in the html instead of at the server side, how to do that? Of course I can copy paste javascript code in the aspx file. But is it possible to do that using some object oriented approach (ie programmatically in the code behind)?

Thanks


Dropdown Event (Template Field)

  

Hi,

I have grid view control that includes a dropdown control in a template field.

I wish to execute some code when the value is changed in the dropdown list.  Can't figure out how to capture this event though?

Any suggestions?


Event ID 1011 - DefaultAppPool World Wid Web Pub. Serv. fatal communication error

  
We have a Windows 2003 server running IIS6 1.1 Framework. We have also installed a DNS and Active Directory in the same machine.

We're randomly getting the error you can see below. Sometimes it causes the recycling of process w3wp.exe (which on my understanding represents the application pool worker processd) and other times results on this process hanging and not responding to any request. To do iisrest temporarly solves the problem.

We were pointed to a possible permissions problem between the user we were runnig the DefaultAppPool with and registry entries used by the iis. We noticed the default predifined user we used, Network Service, wasn't found in the Active Directory, so we changed it by the default configurable user, IWAM_MACHINE_NAME, which is under the IIS_WPG Active Directory Grupo, which, in theory has the correct permissions to run the application pool.

Well, none of this worked and we are still getting this error.

This is driving us crazy and think the problem might have to do with having the Domain Controller/Active Directory and the IIS6 running on the same machine. We'll try now uninstalling this DC pointing to another one to see what happens.

Any help would be appreciated.

Thanks in advance,

Gabriel.


Event Type: Warning
Ev
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend