Get-DbaModule View Source Brandon Abshire, netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves database modules (stored procedures, functions, views, triggers) modified after a specified date
Description Queries sys.sql_modules and sys.objects to find database modules that have been modified within a specified timeframe, helping DBAs track recent code changes for troubleshooting, auditing, or deployment verification.
Essential for identifying which stored procedures, functions, views, or triggers were altered during maintenance windows or after application deployments.
Get-DbaMsdtc View Source Klaas Vandenberghe (@powerdbaklaas) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves Microsoft Distributed Transaction Coordinator (MSDTC) service status and configuration details
Description Returns comprehensive MSDTC information including service state, security settings, and component identifiers (CIDs) from target servers. MSDTC is essential for SQL Server distributed transactions, linked server operations, and cross-database transactions that span multiple servers or instances.
Get-DbaOleDbProvider View Source Chrissy LeMaire (@cl) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves OLE DB provider configurations registered with SQL Server for linked servers and distributed queries
Description Returns the OLE DB providers that SQL Server knows about and can use for external data connections like linked servers, distributed queries, and OPENROWSET operations. This is essential for auditing your server’s connectivity capabilities and troubleshooting linked server connection issues.
Get-DbaSsisExecutionHistory View Source Chris Tucker (@ChrisTuc47368095) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves SSIS package execution history from the SSIS catalog database (SSISDB).
Description Retrieves detailed execution history for SSIS packages from the SSIS catalog database, including execution status, timing, and environment details. This function queries the catalog.executions view in SSISDB to provide comprehensive execution information for troubleshooting failed packages, monitoring performance, and analyzing SSIS workloads.
Invoke-DbaDbTransfer View Source Kirill Kravtsov (@nvarscar) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Transfers database objects and data between SQL Server instances or databases using SMO Transfer objects.
Description Transfers database objects and data between SQL Server instances or databases by executing an SMO Transfer object. This function handles database migrations, environment synchronization, and selective object deployment scenarios where you need to copy specific objects or data without doing a full database restore.
New-DbaCustomError View Source Adam Lancaster, github.com/lancasteradam Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Creates custom error messages in SQL Server’s sys.messages table for standardized application and stored procedure error handling
Description Creates custom error messages in SQL Server’s sys.messages table using sp_addmessage, enabling standardized error handling across applications and stored procedures. This replaces the need to manually execute sp_addmessage for each custom message you want to define.
New-DbaDbTransfer View Source Kirill Kravtsov (@nvarscar) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Creates a configured SMO Transfer object for copying database objects between SQL Server instances
Description Returns a configured SMO Transfer object that defines what database objects to copy and how to copy them between SQL Server instances.
This function prepares the transfer configuration but does not execute the actual copy operation - you must call .
New-DbaScriptingOption View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Outputs Synopsis Creates a customizable SMO ScriptingOptions object for controlling T-SQL script generation
Description Creates a Microsoft.SqlServer.Management.Smo.ScriptingOptions object that controls how SQL Server objects get scripted into T-SQL CREATE statements. This object lets you customize what gets included when using Export-DbaScript and other dbatools scripting commands - things like whether to include indexes, triggers, permissions, dependencies, or batch separators.
Remove-DbaCustomError View Source Adam Lancaster, github.com/lancasteradam Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Removes user-defined error messages from the sys.messages system catalog
Description Removes custom error messages that applications have added to SQL Server’s sys.messages catalog, cleaning up obsolete or unwanted user-defined messages with IDs between 50001 and 2147483647. This is essential when decommissioning applications, cleaning up test environments, or managing custom error message lifecycles during application deployments.
Set-DbaExtendedProperty View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Updates the value of existing extended properties on SQL Server database objects
Description Updates the value of existing extended properties on SQL Server database objects. Extended properties store custom metadata like application versions, documentation, or business rules directly with database objects. This function modifies the values of properties that already exist, making it useful for maintaining application version numbers, updating documentation, or batch-modifying metadata across multiple objects.
dbatools