Monday, April 16, 2018

How to get a list of database objects changed for specific time sql server

To get List of database objects changed for last 30 days from currect date.

SELECT type, name,create_date,modify_date

FROM    sys.objects

WHERE   modify_date >= DATEADD(DAY, -30, GETDATE())

order by [TYPE] asc

Change default Port on Next.js app

 If any other app or process is running on port 3000 , you will get this error in your terminal Port 3000 is already in use. error Command f...