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


Top 5 Contributors of the Month
Imran Ghani
Sohaib Khalid
Post New Web Links

Trigger not inserting from application

Posted By:      Posted Date: November 25, 2010    Points: 0   Category :Sql Server
 

Hi,

I have created a trigger as follows..

 

CREATE
 TRIGGER
 [CustomReport].[trig_ins_call_data] ON
 [CustomReport].[call_data] 
FOR
 INSERT
 
AS
 
 
INSERT
 INTO
 [CustomReportDB].[CustomReport].[call_data_temp] ([cd_dbid], [campaign_name] ) 
SELECT
 [cd_dbid], [campaign_name] FROM
 inserted 

 

There is an SP in the same schema which will insert records in call_data, and the trigger is successfully inserting a copy of the new inserted record to call_data_temp. Also there is an application (.net) which will insert record in to call_data table. But during this insertion, the trigger is not inserting the new record.

Can anyone help me on this? Is it a problem of schema? If possible, how can we confirm that?

Thanks,

Sree




View Complete Post


More Related Resource Links

Is it supported to trigger expiration formulas directly from a Web Application hosted on a different

  

On triggering a custom expiration formula directly accessed from our Front End Server Web Application we run into this error (see Event log error below):
Is it supported to trigger expiration formulas from a Web Application (that runs a Site Collection with a custom expiration policy) directly from a Front End server?

Event log:
Error loading and running event receiver Microsoft.Office.RecordsManagement.Internal.UpdateExpireDate in Microsoft.Office.Policy, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c. Additional information is below.
The Web application at
http://mynltestsp10fe could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application.
 
Additional comment: The Web Application was originally created on the Central Administration server but is also hosted on the Front End server.
(When accessed directly from the Central Administration server documents can be triggered successfully for expiration)

 


Inserting methods in Dynamic Data Application

  

I am trying to build aa hotel management application using Dynamic data. I need to create an event and add methods to calculate applicable room charges based on the duration of stay. For example;

TotalRoomCharge = DurationOfStay*RoomRate

TotalRoomCharge, DurationOfStay and RoomRate are all columns in my database table.

I have already generated the dynamic data site in my application.


trigger problem inserting null values??

  

I have created 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

USE [mine]
GO
/****** Object: Trigger [dbo].[insert2]  Script Date: 10/03/2010 15:00:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER trigger [dbo].[insert2] 
  on [dbo].[emp] 
  after insert 
  as 
  declare @sno int,@result varchar(50),@empid int,@name varchar(50) 
select @empid=empid,@name=@name from emp  
 insert into triglog values(@empid,@name)  
  
  
but when

Stop Application Pool does not trigger PersistenceIOParticipant.BeginOnSave

  

Hi All,

When i stop the IIS application pool, the persistence will not trigger PersistenceIOParticipant.BeginOnSave to save the customize data into database, however it does save the persistence record into [System.Activities.DurableInstancing].[InstancesTable].

Kindly advise!

 

 


Weird application behavior -- Action required to trigger service response otherwise the application

  

Hi,

I am a WCF beginner and is trying out with a basic host service with callbacks to the client.

My code works wonders if my client app is a console.exe but when I transferred the code to a Windows Form app, the application will freeze.  But if I right click on the form window task bar, the code suddenly goes through and it would work...

Is there anything wrong with this?

The service is hosted on IIS

Here is my Service code:

 

[ServiceContract(CallbackContract = typeof
(IChatCallBack))]
 public
 interface
 IChat
 {
  [OperationContract]
  void
 Talk(string
 msg);
  }

[ServiceContract]
 public
 interface
 IChatCallBack
 {
  [OperationContract]
  void
 OnCallBack(string
 msg);
  }

 

Implementation:

 

[ServiceBehavior(
  ConcurrencyMode = ConcurrencyMode.Reentrant)]
 public
 class
 Chat : IChat
 {

  

Microsoft's Collaborative Application Markup Language (CAML) Loop

  
discovered an interesting error recently while working with Microsoft's Collaborative Application Markup Language (CAML) that, surprisingly, had received no ink. Partly what surprises me about this is that the error may require you to rewrite large sections of your code if you haven't previously considered this SharePoint limitation. I'll start with some context, but first of all the error is:

Integrating a Legacy Web Application in SharePoint

  
This month we will continue with the theme of deploying Microsoft's SharePoint as a company intranet by describing a method for integrating a legacy Web application inside a SharePoint site.

In many companies the intranet site is not just a home page with announcements. It houses Web applications used by many different departments. In last month's article, I built a page to search the employee table in Northwind (the sample database included in Microsoft's SQL Server). This month, I will move the Web pages used to add/remove records from the table into the SharePoint intranet.

Inserting new row in GridView in ASP.NET 2.0

  
The GridView was not designed to insert new rows, but there is a way to accomplish this with very little code. This article shows how to do that. The GridView was not designed to insert new rows, but there is a way to accomplish this with very little code.

MVC architecture in ASP.Net using C# and Microsoft Data Access Application block

  
The Model-View-Controller (MVC) pattern separates the modeling of the domain, the presentation, and the actions based on user input into three separate classes [Burbeck92]:

Model. The model manages the behavior and data of the application domain, responds to requests for information about its state (usually from the view), and responds to instructions to change state (usually from the controller).

View. The view manages the display of information.

Controller. The controller interprets the mouse and keyboard inputs from the user, informing the model and/or the view to change as appropriate.

High-Performance .NET Application Development & Architecture

  
It has always been a goal of project architects to plan an effective strategy from the ground up in regards to an new application. All relevant factors are taken into consideration with respect to the application, from its design and layout to a functional website infrastructure. Pre-.NET strategies and design guidelines still effective now were developed with Microsoft's DNA (Distributed interNet Application) platform. This model successfully served the purpose of architecting N(any number of)-Tier (levels) applications. In its basic sense, as in most robust, distributed applications, you'll architect 3 main layers or Tiers: presentation, business rules and data access.

Application architecture in asp .net

  
Application Architecture is the most important process of developing a good application. Some people tends to jump into coding without any architecture laid. Later we see those people changing the architecture and finally the application had to be developed from the scratch with the correct architecture.

In this article I will describe some details about how you can improve the architecture of you application. This article is targeted to the beginner's audience.

Improving Application Performance in .Net

  
Application performance has always been a concern for Web Application developers. This article contains guidelines and tips for maximizing application performance in ASP.NET.

Logic behind N -Tier Application Development

  
In the arena of application development, developers all over the world use various programming languages, technical processes, and technical tools. While using number of technical & non technical elements the processes or methods become complex, for simplification of the application development process, developers use various techniques such as dividing the application architecture into layers or parts. In the professional & technical language this separation or division process is called N-Tier Application Development process, where "N" stands for number and "tire" stands for layers or parts.

How to create 3 tier application using LINQ

  
As you know that in 3 tier architecture there are three layers

User interface layer. (Is our Form in Windows application and .aspx page in Web application)
Data Access layer. (Which provides interface between Business logic layer and Database)
Business Logic layer.(Which stores your application logic)

Using Lightbox in an ASP.NET Application

  
The article describes Lightbox as, "... a simple, unobtrusive script used to overlay images on the current page." It delivers a nice, professional looking method for displaying images as overlays through the use of hyperlinks.

Application Architecture: An N-Tier Approach - Part 1

  
Introduction

Free Trial: SQL Backup Pro
Sponsored by Red Gate
Exceptional DBAs make the most of their office hours. That's why they love Red Gate SQL Backup Pro. Its faster, smaller, secure SQL Server backups mean more time spare to accomplish more tasks and professional training. Make time to be an Exceptional DBA. Download it now! »


Free Trial: SQL Toolbelt
Sponsored by Red Gate
The SQL Toolbelt is a set of twelve powerful and intuitive tools that will help you burn through SQL Server chores with astonishing speed and accuracy. Download it now! »


Download: SQL Backup Evaluation Center
Sponsored by Red Gate
Download the T-SQL scripts in the SQL Backup Evaluation Center to compare Red Gate SQL Backup Pro's compressed backups with the size of backups created using native SQL Server. Download it now! »



MARKETPLACE
Autodesk Inventor®
Go Beyond 3D To Digital Prototyping With Autodesk Inventor. Learn How.
Autodesk.com/Beyond-3d
Virtualization Solutions
Optimize, Simplify, & Save Today. Learn About Microsoft Solutions.
www.microsoft.com
Microsoft SQL Server® 2008 - Free Trial
Download the Free 180-day Trial of SQL Server® 2008 Enterprise Edition!
www.Microsoft.com/SQLServer
Hot Careers in Internet Marketing
Get prepared for your new career with online degrees from Full Sail University!
www.FullSail.edu
Microsoft Te

Solidify Your C# Application Architecture with Design Patterns

  
design pattern can solve many problems by providing a framework for building an application. Design patterns, which make the design process cleaner and more efficient, are especially well-suited for use in C# development because it is an object-oriented language. Existing design patterns make good templates for your objects, allowing you to build software faster. This article describes several popular design patterns you can use in your own applications, including the singleton, the decorator, the composite, and the state classes, which can improve the extensibility of your applications and the reuse of your objects.
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