SELECT OBJECT_NAME(ObjectID) as ObjectName, st.Text, DB_NAME(database_ID) as dbname, Blocking_session_ID as BlockingSessionID, * FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS st
It will give us details like about running SQL Objects, with Database name:
About me
Tejas Shah
Microsoft Certified Professional Expert. I have 14+ years of experience in Design and Develop 100+ .Net applications using Asp.Net, C#, Asp.Net Core, VB.Net, SQL Server, MVC, AngularJS, JavaScript, Azure, HTML5 and CSS3.
Categories
Recent Post
-
SQL Server Reporting Services, List out all the data sources with Report Name and Path
Posted by Tejas Shah on November 22, 2017
-
SQL Server, T-SQL create Linked Server with Azure SQL Database
Posted by Tejas Shah on November 11, 2017
-
SQL Server: Use of Recursive Query with example
Posted by Tejas Shah on August 12, 2015
-
SQL Server, avoid encoding special character when using FOR XML PATH
Posted by Tejas Shah on June 26, 2015
-
SQL SERVER: Find Current Location of Log File(s) with File Size of All the Database
Posted by Tejas Shah on April 20, 2015