I was getting many dealock error's myself and I finally found and old Trigger that was running. Drove me nuts but that was the problem. DO NOT USE Triggers unless...

I need the same thing, I hope there are some examples

This may not be the best answer but I have a similar situation. I have a helpdesk table and a helpdesk history table. I have a trigger that inserts a...

I can actually answer this one!!! I will post the script that will inventory all of your software one PC's specified!!

Jason

Can you show me an example?

That was it thank you so much!!!  the finished trigger is below:

CREATE TRIGGER [HelpdeskNewUser] ON dbo.Helpdesk

AFTER INSERT

AS

if @@ROWCOUNT = 0

return

set nocount on

INSERT...

I don't know about your SP, but you should be able to query NT-Username by group if they belong to a common group for CaliforniaLocations VBScript would be like below:

On...

it is VARCHAR and the above works fine i just need the AM/PM part as well

Dan that did the trick!!! I forgot that I need AM/PM too! But your help is greatly appreciated!!!

Dan I tried it again and it WORKED!!!

Dan your the man!!! Thank you so much!

I tried it that way too, that doesn't work either I know it has to be something small I am missing.

Dan,

That looks like exactly what I need, but I am getting a syntax error somewhere near the from clause. Below is the trigger.

********Update Trigger with auto increment

CREATE TRIGGER [TicketHUP] ON [dbo].[Ticket]...