Following on from yesterdays post on sys.dm_tran_active_snapshot_database_transactions here is a look at four more dynamic management views that contain information about snapshot transactions.
sys.dm_tran_current_snapshot displays the transaction sequence number (XSN) for each transaction that was active when the current snapshot transaction started. sys.dm_tran_transactions_snapshot displays the all of the transactions with a XSN that were active when [...]
I’ve worked out its impossible to just memorise all of the new Dynamic Management View and Functions in SQL Server 2005; so my new approach is to actually use one or two and see what they do.
According to the documentation for sys.dm_tran_active_snapshot_database_transactions it returns “a virtual table for all active transactions that generate or potentially [...]
Isn’t that what we’re all asking in our own lives?
I know I am.
Yesterday I had a SQL Server 2005 connection running as SA and tried to get the Actual Execution plan for a stored procedure. The procedure should have returned a million rows, instead all I got was an empty result set. All the columns [...]
Paj’s Home: Cryptography: JavaScript MD5 - Online MD4, MD5 and SHA1
Following on from my previous post I’ve created a procedure to read encrypted data using the same principles: Executing the procedure in the context of a least privilege user and elevating the permissions using code signing as follows.
create procedure sales_api.usp_getCCTrans with execute as ‘lpu_code_context’ as begin begin try [...]