Categories:
If you ever need to know what is database name based on a data or transaction log file location, run the following T-SQL code.
Categories:
The following command effectively gives the user permission to execute ALL stored procedures in the database:
Categories:
Display estimated time for backup and restore operations.
Categories:
List of currently active sessions for each database on your servers.
Categories:
The query generates a DROP statement for all auto-created statistics to all databases.
Categories:
The services in Windows can be listed using the current script.
Categories:
With this, you can easily collect the details of all components that are installed on your server.
Categories:
Windows Servers allow the maximum of two concurrent remote sessions by default.