The following code displays the oldest active transaction on a Database.
USE Mydb
Go
DBCC OPENTRAN
Go
Subscribe to:
Post Comments (Atom)
About Me
- Jesse
- has 6+ years experience as database administrator in MS SQL Server 2000/2005/2008/2008 R2, 2012. He has a bachelor of Science Degree in Computer Science along with MCP (Microsoft Certified Professional), MCTS(Microsoft Certified Technology Specialist), Certificate in Application Programming Technique (SAP – ABAP/4), Certificate in Client Server Technology (SAP), Certificate in Business Process Engineering (SAP), Certificate in Enterprise Resource Planning (SAP). He is currently undertaking his Master of Business(Enterprise Resource Planning) Degree part-time.
No comments:
Post a Comment