what error are you seeing in the SQL Server Log? What happens if you add the users directly, or add them to a domain group (Vs. a local group?)...

Good point Steve, I should have mentioned that as well. If your goal is to minimize the size of the transaction log then pausing long enough between iterations to allow...

sounds like a policy management alert. Some configuration of your server has changed that is not conforming to a policy that was set up.

for limiting rows you have two options. If the IDs to be deleted are pretty well grouped together and mostly contiguous you can divide up the deletes by ID ranges....

With the clustered index on ID I would propose the following:

select into a temp table the IDs that qualify for being deleted (use NOLOCK if you can)

delete from the main...

see if you can access the cached version of some pages with a google search for your business or old web site. you may get luck and be able to...

are you replicating between databases on the same server or to another server?

People have accused me of being certified. I would merely claim to be certifiable.

Put them all into one XML column. ;^)

Thanks for providing additional info. I do not have time at the moment to spend more than a minute or two to look at it but I will get to...

This looks overly complex to me, but I don;t have sufficient information to explain why or how to design it more efficiently.

I would suggest that you break this query up...

Students that need to loose weight should have a NULL lunch period.

Then there are two other options:

1) check for null and use a 3 value insert statement if it is null, else insert 4 values.

2) select the column default value into...

In order for the column default to be used you would have to use an insert statement that omitted that column.

Since you know the default (is 4) you could do...

Then EXCEPT or LEFT OUTER JOIN is what you want.