How to check date of last change in stored procedure or function in SQL server

SQL Query for Stored procedure Modification date and time SELECT name, create_date, modify_dateFROM sys.objectsWHERE type = ‘P’order by modify_date desc

Read more

How to check MSSQL Number Of ActiveConnections

First you need to open the SSMS. 1. Start search SSMS. 2.Open the SQL Server management studio. 3.Then connect to

Read more