I was able to get IT to install Server 2003 SP2 this morning and after the reboot memory usage is HALF. CPU usage is down to 10% at the moment....

Thanks for the resources everyone. I've been going through them over the past couple of days and I'm not sure what I'm even looking for now. :hehe:

We do have a...

^ Yeah, it's a nice utility.

Another piece of the puzzle I just found is that the amount in ram is about the same size as all the databases on...

My new boss showed me Process Explorer. I'm still exploring it but it seems pretty good so far.

Since it's 64 bit we don't have PAE enables.

The upper memory limit is 2000000000 MB set by my previous boss. We haven't changed it since.

I using Process Explorer to get...

Kenneth,

In keeping with the topic, I would love to see how I can get each [id] from the [updated] table and call a stored procedure using the [id] column. There...

Very true that we don't always get to pick the db structure!

I have a database that is published from another company. Even though I fought long and hard to have...

I found out from the programmers that they use one thread in asycronous mode for everything and you cannot stop the query once it starts.

But I liked the idea of...

Ok now. Success everyone!

--drop trigger photo_numbers

CREATE TRIGGER photo_numbers

ON mls_photo

FOR INSERT , UPDATE

as

update [vreb].[dbo].mls set p_mod_date_time=Left(CONVERT( varchar , getdate() , 1),8), photo=

(case when m.medium_photo is null then '' else '1'...

But one problem. "Cannot insert the value NULL into column 'list_date', table 'vreb.dbo.mls'; column does not allow nulls. INSERT fails.

The statement has been terminated."

This is a field in the mls...

Ah,

vreb.dbo.mls

vrebphoto.dbo.mls_photo

I suppose this makes a difference.

Hi nigelrivett,

I still get: Invalid object name 'mls'.

If "Inserted" is the mls_photo record of the inserted/updated record, should the last line reference the mls.id?

Posing the question because I am having...

Hi Paul,

Yes, that seems like the way to go. I have the computed field but I am having trouble with the trigger. This is my first experience with them and...

I also got the error about the text fields but only when I tried to specify the mls table more by using vreb.dbo.mls(...

CREATE TRIGGER photo_numbers

ON mls_photo

FOR INSERT , UPDATE

as

insert...

Thanks!

I had someone send me this which actually adds to the database. However, when I update medium_photo2 = NULL, I get:

Server: Msg 208, Level 16, State 1, Procedure photo_numbers, Line...