I got it.. thanks.

frankly, that doesn't make sense to me...

but thank you for clarification anyway.

That sounds nice!

Thank you.

Hi Koen,

Thanks for making it clear like crystal to me.

Hi Dev,

SQL Server has two solutions to track changes made on tables: "Change Tracking" and "CDC". You can search the msdn...

Sounds interesting!

But the ETL implimintation is useful in case of Change Data Capture (CDC) and not Change Tracking.

Thanks for sharing the idea anyway.

Got it.. thanks a lot.

Thanks!

cheers buddy!

Thanks for your reply.

Have a nice weekend.

Hi,

When I logged on as the OS user who created the instance, the command worked OK.

I think there's a Windows privilege required... sysadmin isn't enough.

Database mail is configured. I sent a test email from it and it worked just fine. Still the alert is not working.

wow! amanzing query 🙂

I'm adding it to my notes.

Thanks for sharing.

I got the answer from another forum as follows:

"If you right-click a file in Explorer and chose properties, there are two sizes listed. Size and Size on disk

They're only different...

do you mean the files of the snapshot take same size as the original?

If yes,...

That's what I've already checked... as I said in my...

sorry guys.. it seems taking the db offline and then online resolves the issue.

It was my mistake becuase I actually didn't rename it to its original filename.

Good day!