Thank you,

What is the difference to write After insert update and for insert, update?

I had to put this code inside another trigger on the same table,so if I have...

This what I have now for my logic for one trigger

UPDATE Employee SET date = i.edate

FROM inserted i

JOIN Employee ON i.id...

Question,

1.Why do you write if update?

You already have code before for update and insert?

2.If update works for update and insert?

Thank you

Also,

Would it be an option to add a persisted calculated column to reflect the condition you're looking for or a INSTEAD OF trigger to use the columns of the INSERTED...

Guys,

I was able to fix it, there is another trigger which does update and insert on another column and I added my updated statment to that trigger and it worked.

Yes

3 triggers

Sorry, I didn't put corectly:

ALTER TRIGGER [Name]

ON [dbo].[Employee]

FOR INSERT,Update as

BEGIN

...

This is what I have on my trigger, I just created, so maybe I didn't created properly

that location is 250gb

I need right click on SQLAgent or SQLServer? if yes I don't see any how big is the file.

Thank you

Find out what's using MemToLeave

How can I do that?

reduce the buffer pool by a like amount ? What anount?

restart SQL regularly

How often?

Thank you for your help

Hello, I am trying to check if my SQL Server setting are correct:

How much memory does the server have? 12G of RAM

Available Physical Memory6.07 GB

AWE should be enabled as you've...

I was reading wrong article

The best solution get upgrade it to 64

But what else can be done?

Do I need to re start all my exchange servers

Is it a 32bit or 64bit server?

32 bit

9.00.4053.00SP3Standard Edition

How much memory does the server have? 12G of RAM

Available Physical Memory6.07 GB

Are there any other apps on the server? NO

Operating...