Our monitoring tool has reported that blocking on prodution
i checked the details
one user is running adhoc query on standalone database(not production database)
one more query is running by the same user against tempdb
SELECT SCHEMA_NAME(tbl.schema_id) AS [Schema], tbl.name AS [Name] FROM sys.tables AS tbl WHERE (tbl.name not like '#%') ORDER BY [Schema] ASC,[Name] ASC
is this Intellisense feature? (which helps the user to make correct SQL Queries)
one of production process (running aginst production db) is blocked by this user temp db query.
So my question is user is trying to run adhoc query in standalone database and production db process is blocked. Just trying to understand how SQL works (because nothing in appln client or our server processes accesses this standalone databse)