In case if you want to include extended properties to the database objects you can use sp_addextendedproperty of SQL Server. Which comes handy incase if you want to include Description for a column/table/any db objects. Suppose if I have table… Continue Reading
If you are software tester or a software developer and if you want to know which objects are recently created or modified then here is the query You can add filters/where conditions if you want specifics example you can include… Continue Reading
Every support team may come across once in their career to know about how many connections/sessions are in use. I have compiled the list queries which are specific a database. Microsoft SQL In this sysprocesses is a system table The following… Continue Reading