The default trace may be your best option

https://www.mytechmantra.com/LearnSQLServer/SQL-Server-Find-which-user-deleted-the-database-in-SQL-Server/

That's very much appreciated and I may take you up on your kind offer over the coming months.

I just want to say thank you for this series.  As a DBA whose employer is looking to move some of their services into Azure, this introduction has been invaluable.

Thanks Ted - this helped me out of a tight spot today.

Great article - you started my day with a smile 🙂

Kill them all and let Codd sort them out.

Thank you Gail, your article has really helped further my understanding of this rather murky area. It's great that you and other experts take the time out to help...

Given the almost 50/50 split between right and wrong answers, I suspect most people are taking an educated guess at the answer (I know I did). The emphasis on...

Nice post, thanks for sharing.

My powers of guess work are strong today 🙂

Happy Halloween!

That's a great job on the pumpkin (Jack-O-Lantern to you I think) Steve. Was that your handiwork?

Have a great day!

Thanks for the question. Straight forward with no smoke and mirrors 😀

Thanks so much for this article. I already have the 70-432 which I completed last year, but so far I haven't motivated myself to take the 70-450 (largely due to...

:hehe: Steve must be having a bad week

khullargirish02 (5/27/2011)

---

The answers are different for each line.

In prefix compression, does the entire prefix stored in the header need to match the data to be used?

No

if I have a prefix...