Thanks a bunch for the tips. 

Ed - I saw the first article but didn't know about the second. I will give it a read.

Haha yes, I don't know how I missed doing that. Thanks a bunch for the help!

Ah, good suggestion on deleting directly from the CTE. That should make things a little faster. Thanks again.

I promise to not keep bugging you on this 🙂 but I've run into one more issue with my cleanup script.

Here is my setup:

--Create table

USE MASTER

CREATE TABLE UserLogon

(

UserName NVARCHAR(255),

Dt...

Good idea. I'll try that. Thanks again.

I hope you won't mind me asking for a little more help on this. I've been testing this script and things were going well until this morning. I have around...

Thank you again very much for the helpful explanations! I appreciate you taking the time.

Do you mind if I ask one more question? Obviously your code works and mine didn't. However, do you use the @@ROWCOUNT method because it is faster? I've pretty new...

Excellent. Thank you very much.

The three part naming convention did the trick. Thanks again.

I took the suggestion to insert if the username doesn't exist and update if it does. I found out quickly why...

Ha, I've never heard the term "upsert". That's brilliant 🙂

I have a meeting, but then I will take these latest suggestions and test. Thanks again to all for the help.

Here is what I tried in our test environment, but I am getting this error:

Login failed for user 'testuser'. (Microsoft SQL Server, Error: 18456)

(I was able to get back in...

Thank you both very much! That really helps!

Thank you both for the replies. I will check out that link.

Thanks to everyone for the replies.

Jeff - You may not have time to do this but would you mind giving your recommendations for both of these areas? Lately I've really...