11 docs tagged with "SQL"

This SQL script creates a temporary table named @Table and populates it with the results of the system stored procedure sp_who2, which returns information about active connections to a SQL Server instance. The SELECT statement then retrieves all rows from @Table where the DBName column matches any value, effectively returning information about all active connections regardless of the database they are connected to.

Before running the command you need to change

This SQL script fetches information about database restores from a table called restorehistory in the msdb database.

Copy the command into Microsoft SQL Server Management Studio.

The script imports the Microsoft.Dynamics.Nav.Management.dll module, which provides the cmdlets that are used to manage users and tenants.