Monthly Archives: February 2019

T-SQL: Find table in complete instance

bschelst/ February 11, 2019/ SQL-Server/ 0 comments

Looking for a table, but you don’t remember in which database it’s located? The code below will create a stored procedure, which you can use in order to find a table in multiple databases.

T-SQL: Kill all connections to a specific database

bschelst/ February 11, 2019/ SQL-Server/ 0 comments

Sometimes you need to do maintenance on a database, and you don’t really want to use single user mode or disable accounts. In that situation you could kill all connections to a specific database.In order to achieve that, you can use the t-sql code below.