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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Trigger explicitly fire

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
hi!   Is there any way I can fire trigger explicitly?If yes, then how can i do that??   Thanks,

View Complete Post

More Related Resource Links

how to fire trigger and save it to another table?


I want to create a trigger for insert and whenever i insert the data the trigger should fire and notify some value inserted i want to create log table to save this information,now i have created a trigger but i dont know how to map it to log table to notify the changes??i want some idea about this thanks.

Using a trigger or anything else to populate two tables


Hi! I'm creating an application that's supposed to first add a record to table1, and then get the ID from that record to use when adding a record to table2, to be able to associate these two records with eachother.

The user gets to type in some values that goes to table1, and some values that goes to table2, but before the insert statement for table2 is executed i need the ID from the recently added record in table1. Some dude told me to use a trigger for the autopopulate purpose, but does that really work when i also need to save some values that's user input, and when those values doesn't get saved in table1?

Are there any other way to do this or can i send values to a trigger? I'm new to triggers and stored procedures, i don't have any particular knowledge of this, any help is appreciated!


Regards, Monsterbadboll

how to get id value from the row inserted in a table with thr trigger.


I have a reports table with column report id and and report version. I created a trigger on this table to execute an application to do some processing each time a row is inserted in reports table. I need to pass the new report id execute this application from the trigger. How do I get the report id from the row that was inserted?


Ho to fire the Application Error in asax from the code?


 Hi All,

I have this code in Global.asax but it not firing once an error occured:


void Application_Error(object sender, EventArgs e)



        // Get the error details

        HttpException lastErrorWrapper = Server.GetLastError() as HttpException;

        Exception lastError = lastErrorWrapper;

        if (lastErrorWrapper.InnerException != null)

        lastError = lastErrorWrapper.InnerException;



        string lastErrorTypeName = lastError.GetType().ToString();

        string lastErrorMessage = lastError.Message;

        string lastErrorStackTrace = lastError.StackTrace;



Please help me so I can call this method from any page?

Thaxxxxxxxxxxxxx a lot,



Modal does not fire up


Hi I have following functional code that works on one machine but not the other.  Could some one provide me with the trouble shooting techniques for jQuery, I have used alert and it fires even a the last statment.

<link href="Content/Themes/cupertino/jquery-ui-1.8.1.custom.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="Scripts/athenajs/jquery-1.4.2.min.js"></script>
 <script type="text/javascript" src="Scripts/athenajs/jquery-ui-1.8.1.custom.min.js"></script>

$(function () {

                title: "my title",
                modal: true,
                height: 500,
                width: 500,
                autoOpen: false,

execute update timedout expires , table with trigger due to recovery of database


I have table A in database A  , in table A i have trigger to insert record to database B table A, each update and insert of database A -table A, triiger fire and insert record in database B table A, when i try to update some times asp.net application gives error

"Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding."

and then error log says System.Data.SqlClient.SqlException: Database 'database B is being recovered. Waiting until recovery is finished.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean ret

Trying to set update panel trigger programmatically


 I have a recursive sub that finds a dropdown list and sets up an AsyncPostbackTrigger for an update panel. I have tried calling this sub both from page_init and page_load 

If the dropdownlist is within the update panel, eveything works fine. If the dropdown list is not in the updatepanel I get error

A control with ID 'ddlPersonFilter' could not be found for the trigger in UpdatePanel 'up1'. In both cases the sub does find the dropdown list and executes the code to set up the trigger. Thanks for your help.

    Private Sub SetUpdatePanelTrigger(ByVal oControl As Control)
        For Each ctrl As Control In oControl.Controls
            If TypeOf ctrl Is DropDownList Then
                If CType(ctrl, DropDownList).ID = "ddlPersonFilter" Then
                    Dim thisddl As New DropDownList
                    Dim thistrigger As New AsyncPostBackTrigger
                    thisddl = ctrl
                    thistrigger.EventName = "SelectedIndexChanged"
                    thistrigger.ControlID = thisddl.ID
                    Exit Sub
                End If
                If ctrl.HasControls Then
                End If
            End If

EventReceiver does not fire for other users than Administrator


Hi all

My code adds a EventReceiver to some SPLists. When I log into Sharepoint as Administrator, then the EventReciever is fired.

When i log in as an other user, it does nothing.


My current code is this:

string assm = "Minimizer, Version=" + FileVersionInfo.GetVersionInfo(Root.Res.DLL).FileVersion + ", Culture=neutral, PublicKeyToken=d2d19387a15c363f";
          string cls = "MinimizerPlugin.Minimizer";
          l.EventReceivers.Add(SPEventReceiverType.ItemUpdated, assm, cls);
          l.EventReceivers.Add(SPEventReceiverType.ItemAdded, assm, cls);

What can I do to register this EventReceiver to all users?

Thanks for your help!!

jquery click event doesn't fire after postback anymore

Hello there,I have a small website where I want to display a confirmation dialog after clicking on a button.When you click the confirmButton the dialog appears. Then you can choose between Yes or No to either continue with the PostBack or to return.Problem: The first time you get into the site all works fine. But after you click Yes to continue with the PostBack, no click event will be triggered anymore.Here is some code.<asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager> <script type="text/javascript"> function loadConfirmDialog() { //Dialog configurieren jQuery('#confirmDialog').dialog({ autoOpen: false, width: 400, modal: true, resizable: false }); //Dialog öffnen jQuery('#confirmButton').bind('click', function () { jQuery('#confirmDialog').dialog('open'); return false; }); //Postback ausführen jQuery('#continueButton').bind('click', function () { jQuery('#confrimDialog').dialog('destroy'); __doPostBack('confirmButton', ''); }); //Postback abbrechen jQuery('#cancel

Generic Audit Trigger CLR C#(Works when the trigger is attached to any Table)

This Audit Trigger is Generic (i.e. non-"Table Specific") attach it to any tabel and it should work.  Be sure and create the 'Audit' table first though. The following code write audit entries to a Table called'Audit' with columns 'ActionType'    //varchar'TableName'    //varchar'PK'    //varchar'FieldName'    //varchar'OldValue'    //varchar'NewValue'    //varchar'ChangeDateTime'    //datetime'ChangeBy'    //varchar using System;using System.Data;using System.Data.SqlClient;using Microsoft.SqlServer.Server; public partial class Triggers{//A Generic Trigger for Insert, Update and Delete Actions on any Table[Microsoft.SqlServer.Server.SqlTrigger(Name = "AuditTrigger", Event = "FOR INSERT, UPDATE, DELETE")] public static void AuditTrigger(){SqlTriggerContext tcontext = SqlContext.TriggerContext; //Trigger Contextstring TName; //Where we store the Altered Table's Namestring User; //Where we will store the Database UsernameDataRow iRow; //DataRow to hold the inserted valuesDataRow dRow; //DataRow to how the deleted/overwritten valuesDataRow aRow; //Audit DataRow to build our Audit entry withstring PKString; //Will temporarily store the Primary Key Column Names and Values hereusing (SqlConnection conn = new SqlConnection("context connection=true"))//Our Connection{conn.Open();//Open the Connection//Build the AuditAdapter an

How to avoid network problems while calling a webservice in a SQL CLR trigger?

Hi All, My Goal: DB synchronization between SQL server 2005 and Mysql database via web services. I have created a SQLCLR trigger, in which i'm calling a web service to sync/update remote (MYSQL) DB over a specific constraints. After getting the acknowledgment from web service i'm updating the sync flag to success (In SQL SERVER2005). If any network delay happens i am unable to know whether sync has done successfully or not. How to avoid network dependency here? Is there any reliable queuing mechanism available in sql server 2005 to eliminate dependency over network? I am looking any suitable service/approach in sql server 2005 that can take care of calling web services as asynchronously and update the status of sync flag irrespective of network. Thanks in advance if anyone provide the good approach as step by step in detail.

CLR Trigger with stored procedures - transaction error

Hi, I've developed sample CLR trigger which call stored procedure but if execution of stored procedure fail I got following exception The context transaction which was active before entering user defined routine, trigger or aggregate "CskTest" has been ended inside of it, which is not allowed. Change application logic to enforce strict transaction nesting. The statement has been terminated.  My trigger [SqlTrigger(Event = "FOR INSERT", Name = "CskTest", Target = "Requirement")] public static void HandleRequirement() { using ( SqlConnection conn = new SqlConnection("Context Connection=true") ) { SqlCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Test"; conn.Open(); try { cmd.ExecuteNonQuery(); } catch ( Exception ex ) { SqlContext.Pipe.Send(ex.Message); } } } I wanna handle this exception in my catch block. How can I do this?

Custom event does not fire

Hello,I have a base server control class for all my user controls. Inside this class I have the following declaration:#region Event Handling Management public event EventHandler ItemSaved; public event EventHandler ItemCancelled; protected virtual void OnItemSaved(EventArgs e) { if (this.ItemSaved != null) { this.ItemSaved(this, e); } } protected virtual void OnItemCancelled(EventArgs e) { if (this.ItemCancelled != null) { this.ItemCancelled(this, e); } } #endregion Concrete user controls used in the application are used always inside a ModalPopupExtender object and the popup it is always handled with server-side code. This means that there are no controls binded to the OkControlID and CancelControlID properties of the ModalPopupExtender.The responsibility to show the Modal Popup is then given to the aspx that has code like thisin the ASPX file...<gsl:PhoneNumberUC ID="ucPhoneDetail" runat="server" />in code behind...protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //Bind to the event handler ucPhoneDetail.ItemSaved += new EventHandler(ucPhoneDetail_ItemSaved); ucPhoneDetail.ItemCancelled += new EventHandler(ucPhoneDetail_ItemCancelled); } } protected void btnNewPhone_Click(object sender, EventArgs e) { //Show the Modal Popup this.mpePopupPhone.Show(

Trigger that deletes another table's row

Hi, I'm new to making triggers. I have the following trigger wich should delete a row in the Activity_Log table when I delete a row in the Poll_Comments table.... I have an error in my where clause - because it don't delete the specific row.... My trigger:ALTER TRIGGER [dbo].[deletePollCommentsTrigger] ON [dbo].[Poll_Comments] FOR DELETE AS BEGIN DECLARE @intRowCount int SELECT @intRowCount = @@RowCount IF @intRowCount > 0 BEGIN DELETE Activity_Log WHERE id IN (SELECT questionId FROM deleted) AND activityDateCreated IN (SELECT commentsCreateDate FROM deleted) AND activitySectionPId = 8 END END If I change the statement to: DELETE Activity_Log WHERE id IN (SELECT questionId FROM deleted) AND activitySectionPId = 8 It correctly deletes all rows with that specific questionId and where activitySectionPId = 8... But I want also to have a where clause on, that ask for commentsCreateDate = activityDateCreated - so I only delete one row and not all rows... How can I do that? Kind regards,simsen :-) 

Can't get target of BindingOperations.SetBinding to actually fire its bindings.

Let's say I have a user control named 'MyControl'. MyControl is used in a Window as follows: <MyControl SelectedName="{Binding Target, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}" > ... </MyControl> The SelectedName property in MyControl is a dependency property that's declared as follows: public static readonly DependencyProperty SelectedNameProperty = DependencyProperty.Register("SelectedName", typeof(string), typeof(MyControl), new PropertyMetadata(string.Empty)); public string SelectedName { get { return (string)GetValue(SelectedNameProperty); } set { SetValue(SelectedNameProperty, value); } } Within MyControl is a TreeView and I want to bind the TreeView's SelectedItem's Name property to MyControl's SelectedName (we can assume that a selected item will always have a name) . To do that, I've added the following in MyControl's constructor: public CubeAssetsTreeViewControl() { InitializeComponent(); var treeViewSelectedItemBinding = new Binding("SelectedItem"); treeViewSelectedItemBinding.ElementName = "myControlTreeView"; treeViewSelectedItemBinding.Mode = BindingMode.OneWay; var treeViewSelectedItemNameBinding = new Binding("SelectedItem.Name"); treeViewSelectedItemNameBinding.ElementName = &

get url from server and fire event

i want to open new window ,but i dont want to provide url link in script because i want to hide this link from user.so is there any method to get URL from server and fire event to open new window after cliking button which has some server logic on that basis serever return URL. 

Trigger can't work well

I find the system don't lanuch "Delete From DBInfo where ProjectID in (select ProjectID from deleted)", what error wih me ? Thanks!   ALTER TRIGGER TriggerDeleteFavoriteProjectAndInfo ON dbo.DBProject FOR INSERT AS  Delete From DBFavoriteProject where ProjectID in (select ProjectID from deleted)  Delete From DBInfo where ProjectID in (select ProjectID from deleted)
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