USE [DEV]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TRIGGER [dbo].[update_trigger]ON [dbo].[Transaction_Tracking]

AFTER UPDATE

AS

BEGIN

INSERT

INTO [dbo].[eRPT_Transaction_Audit]

( Package_ID, Received_Date, Start_Date,Operation, TriggerTable)

SELECT i.Package_ID, i.Received_Date, i.Start_Date,'U', 'I'

FROM inserted i

INNER JOIN...

THANKS!:-)

I am trying to alter the datatype of the primary key of the table. The primary key has the identity seed set on and the table has 3 triggers.

When I am using bids, I do not see the dataset on the left side of the visual studio ide. Can you tell me how to display the dataset?

When I was orginally using the code, I had full 'sa' permissions. Now when I using the other database, there are no special permissions that have been setup.

Thus can...

The sql you gave me works correctly. I just submitted the query in a general query window. My problem is I do not know where the database trigger is located...

What would you want to see? The columns in the tables and/or the data?

I found out what my problem is. Thanks everyone!

I am just giving you an example of the sql that is generated by the ssms. if there is sql problems, I just showed you an example, since I am...

Thanks!

Thanks for your answer so far!

I have the following additional questions:

1. Can you tell me how to work with a SSIS package in bids. I have only used bids for...

thanks all the suggestions work!

If the hidden columns/rows cause a problem, what do you think I should do to solve the problem?

Your solution worked great!

However, now I am having trouble saving the color and width of the line you suggested I draw. I try to save the color and line...

How will the ssrs report know how to find the stored procedure? Do you need to set something else up?