SyntaxFix

[sql] Is there a way to list open transactions on SQL Server 2000 database?

Use this because whenever transaction open more than one transaction then below will work SELECT * FROM sys.sysprocesses WHERE open_tran <> 0

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to sql-server

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Count the Number of Tables in a SQL Server Database • Visual Studio 2017 does not have Business Intelligence Integration Services/Projects • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database • How to create temp table using Create statement in SQL Server? • SQL Query Where Date = Today Minus 7 Days • How do I pass a list as a parameter in a stored procedure? • SQL Server date format yyyymmdd

Examples related to transactions

• sql try/catch rollback/commit - preventing erroneous commit after rollback • Laravel: Using try...catch with DB::transaction() • UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-only • Transaction marked as rollback only: How do I find the cause • Transaction isolation levels relation with locks on table • Spring transaction REQUIRED vs REQUIRES_NEW : Rollback Transaction • When to use SELECT ... FOR UPDATE? • Correct use of transactions in SQL Server • MySQL : transaction within a stored procedure • issue ORA-00001: unique constraint violated coming in INSERT/UPDATE

Examples related to sql-server-2000

• SQL get the last date time record • INSERT INTO @TABLE EXEC @query with SQL Server 2000 • How to get the first and last date of the current year? • SQL select max(date) and corresponding value • SQL where datetime column equals today's date? • Is there a way to get a list of all current temporary tables in SQL Server? • Grant execute permission for a user on all stored procedures in database? • Is there a way to list open transactions on SQL Server 2000 database? • Get the time of a datetime using T-SQL? • select a value where it doesn't exist in another table