Warning: Undefined variable $ub in /home/sgso7sed/public_html/wp-content/plugins/advanced-page-visit-counter/public/class-advanced-page-visit-counter-public.php on line 148
Scripts • SQL Server Monitoring

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:

Need to change database owner programmatically?

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:

The following C# source code shows how to send an email from a Gmail address using the SMTP server.

Categories:

Windows Servers allow the maximum of two concurrent remote sessions by default.