• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 334
  • Last Modified:

Trigger not working on Sql 2008 server database from my laptop?

Hi,

There are Entered_date and Enetered_by fields on each of tables.
The production database is on the network server. Those two fields are populated fine.
But when I test my application against a test database server on my laptop.
Two fields are not populated.

Two fields are populated by a trigger from this:

ALTER TRIGGER [dbo].[AuditIns_tblxxxx]
   ON [dbo].[tblxxxx]
   AFTER INSERT
AS
BEGIN

      SET NOCOUNT ON;

      update [dbo].[tblxxx]
      set Entered_date = current_timestamp, Entered_By = system_user
      from inserted i
      INNER JOIN [dbo].[tblxxx] t on i.[IdGuid] = t.[IdGuid];


END

So it looks like this line is not working when I run my sql server on my laptop.
set Entered_date = current_timestamp, Entered_By = system_user

Any suggestion as why it is not working?
0
dkim18
Asked:
dkim18
  • 5
  • 4
1 Solution
 
dkim18Author Commented:
It looks like the problem is the trigger is not running.
0
 
wdosanjosCommented:
The trigger might be disabled on the test database.  Run the following query to verify.  The is_disabled column should be 0 (zero) if the trigger is enabled.
SELECT *
  FROM [YourDatbase].[sys].[triggers]
  WHERE Name = 'AuditIns_tblxxxx'

Open in new window

0
 
dkim18Author Commented:
It didn't bring back any records.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
wdosanjosCommented:
Humm... try running the query without the WHERE clause.  BTW, has the trigger been created on your test database?
0
 
dkim18Author Commented:
A copy of the database was attached to my local sql server so it has the tiggers.
I can see it from the table's trigger property.
0
 
dkim18Author Commented:
The production sql server brought back records with trigger names.
SELECT name, is_disabled FROM sys.triggers

But not from my local sql server.
0
 
wdosanjosCommented:
Does SELECT * FROM [YourDatabase].[sys].[triggers] return any rows?
0
 
wdosanjosCommented:
I'm not sure why that happened, but it seems the solution is to recreate the triggers on the test database.
0
 
dkim18Author Commented:
Sorry.
You are right. The tiggers are not there on the local test server.
I am pretty sured I've seen them but not now I don't see them any more.

The my sql server just froze and I had to restart it but I don't see why the trigger would not be there.
All I did was attached the copy of the production database to my local test sql server.
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now