Posts by fasr • 143 points
5 posts
-
2
votes3
answers15502
viewsA: SQL Server command to list active transactions
I found this command too: DBCC OPENTRAN
sql-serveranswered fasr 143 -
2
votes2
answers174
viewsA: What SQL server command to list the user’s transaction Isolation level
I found this command that lists the settings set for the user, including transaction Isolation level. DBCC USEROPTIONS
-
2
votes3
answers15502
viewsQ: SQL Server command to list active transactions
Which SQL Server command lists the currently active transactions?
sql-serverasked fasr 143 -
2
votes2
answers174
viewsQ: What SQL server command to list the user’s transaction Isolation level
Is there any command I can run on sql server to list the user’s Isolation level transaction?
-
6
votes5
answers29661
viewsA: How do I know if a column exists in an SQL Server table?
This way, one searches the column name in all Schema tables. SELECT COLUMN_NAME, TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE 'NomeColuna'