每當以資料庫使用者身分加入或移除登入時,就會發生 Audit Add DB User 事件類別。 這個事件類別用於 預存程式sp_grantdbaccess、 sp_revokedbaccess、 sp_adduser和sp_dropuser 預存程式。 未來的 SQL Server 版本可能會移除此事件類別。 建議您改用 Audit Database Principal Management 事件類別。 Audit Add DB...
A. Add a database userThe following example adds the database user Vidur to the existing Recruiting role in the current database, using the existing SQL Server login Vidur.SQL Copy EXEC sp_adduser 'Vidur', 'Vidur', 'Recruiting';
sp_add_log_shipping_primary_database[ @database = ]'database', [ @backup_directory= ]N'backup_directory', [ @backup_share= ]N'backup_share', [ @backup_job_name= ]'backup_job_name'[ , [ @backup_retention_period= ]backup_retention_period] [ , [ @monito...
When you connect to a database by saving the user name and password, SharePoint Designer 2010 generates a SQL-based connection string that stores the user name and password in the data source connection (a process known as SQL authentication). If your site is located on a server running Mic...
SQL Serverのインスタンスに Login オブジェクトを作成します。 構文 PowerShellコピー Add-SqlLogin[-LoginName <String>]-LoginType<LoginType> [-DefaultDatabase <String>] [-EnforcePasswordPolicy] [-EnforcePasswordExpiration] [-MustChangePasswordAtNextLogin] [-Certificate <String>] [-AsymmetricKey...
Before you add a secondary data connection to a SQL Server database to your form template, you need the following information from your database administrator: The name of the server with the database that you will use with this form template. ...
AddDatabaseContext(StringCollection) 将数据库上下文添加到 queries 参数标识的查询集合。 (从 SqlSmoObject 继承。) AddDatabaseContext(StringCollection, ScriptingOptions) 将数据库上下文添加到 queries 参数标识的查询集合,并且使用指定的脚本选项。 (从 SqlSmoObject 继承。) 页首 请参阅 参考 DataFile 类...
此範例假設作業和作業BackupDatabaseRunReports已經存在。 SQL USEmsdb; GO EXEC sp_add_schedule @schedule_name = N'NightlyJobs', @freq_type = 4, @freq_interval = 1, @active_start_time = 010000; GO EXEC sp_attach_schedule @job_name = N'BackupDatabase', @schedule_name = N'NightlyJobs';...
@database_name为 sysnameNULL. 不允许括在括号 ([ ]) 中的名称。 [ @event_description_keyword = ] N'event_description_keyword' 必须在错误消息日志中 SQL Server 错误的说明中找到的字符序列。@event_description_keyword为nvarchar(100),默认值为NULL. 此参数可用于筛选对象名称(例如customer_table)。
[@database_user_name= ] N'database_user_name' The name of the user account to use when executing a Transact-SQL step.@database_user_nameissysname, with a default ofNULL. When@database_user_nameisNULL, the step runs in the job owner's user context on@database_name. SQL Server Agen...