Check progress of shrink database

Its very simple. Open management studio create a new query on the instance where is the database that you are shrinking and paste this query:

Select percent_complete, status, command , estimated_completion_time from sys.dm_exec_requests

And find dbccfilescompact

Annunci

Sql server list table

Its very simple to find all the table or view in a sql db. On management studio select your db and open a new query.

Then past this query

Select * from information_schema.tables

If you want to see only table add

Where table_type =’base table’