Commands: completion Generate the autocompletion script for the specified shell config Modify sqlconfig files using subcommands like "sqlcmd config use-context mssql" create Install/Create SQL Server, Azure SQL,
[-DisableCommands] [-HostName <String>] [-ApplicationName <String>] [-ApplicationIntent <ApplicationIntent>] [-MultiSubnetFailover] [-FailoverPartner <String>] [-HostNameInCertificate <String>] [-TrustServerCertificate] [-NewPassword <String>] [-Variable <PSObject>] [-InputFile <String>] [-...
适用于:SQL Server 本文适用于 SQL Server 实例。 备注 本文侧重介绍 SQL Server。有关 Azure SQL 平台中此错误的特定详细信息,请参阅排查 Azure SQL 数据库中的事务日志错误和排查 Azure SQL 托管实例中的事务日志错误。 Azure SQL 数据库和 Azure SQL 托管实例基于最新稳定版本的 Microsoft S...
-ReadBatchThreshold number_of_commands The number of replication commands to be read from the transaction log before being issued to the Subscriber by the Distribution Agent. The default is 0. If this parameter isn't specified, the Log Reader Agent reads to the end of the log or to the nu...
Shrink commands impact database performance while running; they should be run during periods of low usage. It is not recommended to shrink data files if a regular application workload will cause the files to grow to the same allocated size again. Be aware of the potential negative performance ...
Applies to: SQL Server Azure SQL Managed Instance If you have one or more stored procedures that execute at the Publisher and affect published tables, consider including those stored procedures in your publication as stored procedure execution articles. The definition of the procedure (the CREATE ...
SSMS tips & tricks Script objects Import Flat File Concepts How-to References Resources SQL projects SqlPackage SQL Server Profiler Visual Studio native helpers Extended Features Visual Studio Code Tutorials SQL Server on Linux SQL on Azure Azure Arc Resources Reference Preuzmi PDF Learn...
commands must be made in a single line. REM Run the Snapshot agent from the command line to generate the standard snapshot REM schema and other files. SET DistPub=%computername% SET PubDB=AdventureWorks2022 SET PubName=AdvWorksSalesPersonMerge "C:\Program...
Server audits are managed with the T-SQL commands CREATE and ALTER SERVER AUDIT. Syntax EXECUTE sp_configure , <value>; Examples Limit server memory usage to 4 GB. EXECUTE sp_configure 'show advanced options', 1; RECONFIGURE; sp_configure 'max server ...
The SnapCenter Server can push out plug-ins to remote hosts. These plug-ins are used to interact with an application, a database, or a file system. In most cases, the plug-ins must be present on the remote host so that application- or database-...