SyntaxFix

[sql-server] Find Locked Table in SQL Server

sp_lock

When reading sp_lock information, use the OBJECT_NAME( ) function to get the name of a table from its ID number, for example:

SELECT object_name(16003073)

EDIT :

There is another proc provided by microsoft which reports objects without the ID translation : http://support.microsoft.com/kb/q255596/

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 sql-server-2008

• Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object • How to Use Multiple Columns in Partition By And Ensure No Duplicate Row is Returned • SQL Server : How to test if a string has only digit characters • Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query • Get last 30 day records from today date in SQL Server • How to subtract 30 days from the current date using SQL Server • Calculate time difference in minutes in SQL Server • SQL Connection Error: System.Data.SqlClient.SqlException (0x80131904) • SQL Server Service not available in service list after installation of SQL Server Management Studio • How to delete large data of table in SQL without log?

Examples related to sql-server-2005

• Add a row number to result set of a SQL query • SQL Server : Transpose rows to columns • Select info from table where row has max date • How to query for Xml values and attributes from table in SQL Server? • How to restore SQL Server 2014 backup in SQL Server 2008 • SQL Server 2005 Using CHARINDEX() To split a string • Is it necessary to use # for creating temp tables in SQL server? • SQL Query to find the last day of the month • JDBC connection to MSSQL server in windows authentication mode • How to convert the system date format to dd/mm/yy in SQL Server 2008 R2?

Examples related to sql-server-2012

• Count the Number of Tables in a SQL Server Database • SQL Server IF EXISTS THEN 1 ELSE 2 • Get last 30 day records from today date in SQL Server • No process is on the other end of the pipe (SQL Server 2012) • How to subtract 30 days from the current date using SQL Server • Possible to restore a backup of SQL Server 2014 on SQL Server 2012? • SQL Server: Best way to concatenate multiple columns? • SQL Server - An expression of non-boolean type specified in a context where a condition is expected, near 'RETURN' • SSIS Excel Connection Manager failed to Connect to the Source • Sql server - log is full due to ACTIVE_TRANSACTION

Examples related to sql-server-2008-r2

• A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233) • Rebuild all indexes in a Database • How to get last 7 days data from current datetime to last 7 days in sql server • Get last 30 day records from today date in SQL Server • what is numeric(18, 0) in sql server 2008 r2 • Conversion failed when converting date and/or time from character string in SQL SERVER 2008 • 'MOD' is not a recognized built-in function name • How to Convert datetime value to yyyymmddhhmmss in SQL server? • SQL Server stored procedure Nullable parameter • SQL Server 2008 R2 can't connect to local database in Management Studio