版本和 SQL Server 2017 支持的功能 版本和 SQL Server 2016 支持的功能 若要从命令提示符向 SQL Server 实例添加功能,请参阅从命令提示符安装 SQL Server。 注意 如果将功能添加到 SQL Server 的现有安装,则会在安装介质的版本级别安装功能,这些功能可能位于 SQL Server 的其他版本级别...
Get-SqlAssessmentItem Get-SqlBackupHistory Get-SqlColumnEncryptionKey Get-SqlColumnMasterKey Get-SqlCredential Get-SqlDatabase Get-SqlErrorLog Get-SqlInstance Get-SqlLogin Get-SqlSensitivityClassification Get-SqlSensitivityRecommendations Get-SqlSmartAdmin ...
Access to the remote server is denied because no login-mapping exists. 若要解决此问题,请将User ID参数添加到连接字符串。 在以下示例中,myUser是传递给连接字符串的用户 ID: SQL EXEC master.dbo.sp_addlinkedserver @server = N'LinkServerName', @provider = N'SQLNCLI', @srvproduct = ...
Applies to:SQL Server Defines the name of the local instance of SQL Server. When the computer hosting SQL Server is renamed, usesp_addserverto inform the instance of the SQL Server Database Engine of the new computer name. This procedure must be executed on all instances of the Database ...
Add users to Oracle ArcGIS Pro 3.3| |Help archive Oracledatabase administrators create user accounts in theOracleinstance and assign these accounts storage (tablespaces) and privileges. The database administrator (sys user) canuseOracletoolsto create users, a default tablespace for the user, and ...
Applies to: SQL Server Azure SQL Managed Instance Creates a new Database Mail account holding information about an SMTP account. Transact-SQL syntax conventions Syntax syntaxsql Copy sysmail_add_account_sp [ @account_name = ] 'account_name' , [ @email_address = ] 'email_address' , [ [...
USE master; GO EXEC sp_addlinkedserver N'SEATTLESales', N'SQL Server'; GO 下例使用 SQL Server Native Client OLE DB 访问接口在 SQL Server 实例中创建链接服务器 S1_instance1。 复制 EXEC sp_addlinkedserver @server=N'S1_instance1', @srvproduct=N'', @provider=N'SQLNCLI', @datasrc=N...
Applies to: SQL Server Azure SQL Managed Instance Creates a schedule that can be used by any number of jobs. Transact-SQL syntax conventions Syntax syntaxsql Copy sp_add_schedule [ @schedule_name = ] 'schedule_name' [ , [ @enabled = ] enabled ] [ , [ @freq_type = ] freq_type ...
Azure SQL Managed Instance では、SQL Server アカウントを使用します。@job_loginはnvarchar(257)で、既定値はNULLです。 この Windows アカウントは、エージェントがディストリビューターに接続するとき、および Windows 統合認証を使用してサブスクライバーに接続するときに必...
This article has step-by-step instructions on how to add components or features to an existent SQL Server instance.