yes it is a sysadmin account

I guess the whole question which is more efficient, not in, not exists, left join

I have the view limited to only necessary columns

So I should understand this to mean that I can not use a sql login for this process?

So is there a way to do this for sql 2005

rather not reboot active/passive cluster

tried this

EXECUTE master.dbo.xp_delete_file 1,N'T:\sqlbackups\',N'*.bak',N'2009-09-13T10:32:50',1

No problem I get the HIPPA world.

patient table

patid

facid

hrxs table

patid

facid

rxno

orderid

facilities table

facid

contractid

in patients you could have

patid facid

122 100

122 ...

Actually the select statement you told me to remove inputs the data referenced with the insert

You should have MSDTC setup on the boxes, also look at EXACT ON

Your run value should be 1 not zero, try running the reconfigure

Maybe John can chime in, have you rebooted the server (inclduing SQl Server0

Here is correct it has to enabled on the sql server side or the AWE does nothing for sql

run this

SELECT 'Memory through AWE'

SELECT

SUM(awe_allocated_kb) / 1024 AS 'Memory through AWE'

FROM

sys.dm_os_memory_clerks

What does buffer and proc cache look like?