I have used the following T-SQL commands quite often when working on the SQL Server side. There are other ways to find some of this information, but you should have these commands in your toolbox.
Using the SQL Server Management Studio(SSMS) interface…