Get Last Running Query Based on SPID

           Put a trigger on the table that checks if the anonymous action has occured, and in this case log the output of DBCC INPUTBUFFER(@@spid) to a table. Then find the beginning of this statement in your application and fix the injection hole

Comments

Post a Comment

Popular posts from this blog

Send Email Using SendGrid with Azure

Image
What is the SendGrid Email Service? SendGrid is a cloud-based email service that provides reliable transactional email delivery, scalability, and real-time analytics along with flexible APIs that make custom integration easy. Common SendGrid use cases include: Automatically sending receipts or purchase confirmations to customers. Administering distribution lists for sending customers monthly fliers and promotions. Collecting real-time metrics for things like blocked email and customer engagement. Forwarding customer inquiries. Processing incoming emails. Create a SendGrid Account Azure customers can unlock 25,000 free emails each month. These 25,000 free monthly emails will give you access to advanced reporting and analytics and all APIs (Web, SMTP, Event, Parse and more). For information about additional services provided by SendGrid, visit the SendGrid Solutions page. To sign up for a SendGrid account Sign in to the  Azure ...
Read more

IEnumerable And IEnumerator interfaces

Image
Before continuing, let me explain the structure, members of the   IEnumerable ,   IEnumerator   interfaces. The IEnumerable   interface contains an abstract member function called   GetEnumerator()   and return an interface IEnumerator   on any success call. This   IEnumerator   interface will allow us to iterate through any custom collection. Note:   IEnumerator   interface is meant to be used as accessors and is not helpful to make any changes in the collection or elements of the collection. Presumably, any element in a collection can be retrieved through its index property. But instead of element index, the   IEnumerator   provides two abstract methods and a property to pull a particular element in a collection. And they are   Reset() ,   MoveNext()   and   Current . See the figure. This is how it works.   Members of IEnumerator Interface Reset(), MoveNext(), Current() The...
Read more