i tried with both scripts, both scripts returns only one grant statement, but it should return more grant statements.

Thank you !!!

thank you.

Actually i need a sql script to add the user to local admin also.

Thank you!!!

Its working now.

thank you Koen Verbeeck !! it is working now.

its not working.still the blank mail queued.

it sending blank email if the table is empty.

i dont want to receive mail if the the table is empty.

there are users created before 24hrs, but result is 0 rows .

is the condition is correct ?

createdate > DATEADD(hh,-24,GETDATE())

its working ....thanks Lynn Pettis !!!

Hi Ed Wagner,

i want to delete all the users from the table.But you mentioned only 3 users.

can you provide the code to drop all the users from that table.

thank you Lynn Pettis!!!

Thank You !!

---

any more suggestions to resolve this ?

CDC jobs are running fine..

I disabled and reconfigured CDC stuff, still facing same issue frequently..