ITPub博客

alter procedure dba.GetMaxTMstmp @tbname nvarchar(100)asdeclare @Max_TMstmp bigintdeclare @sql nvarchar(4000)declare @sql2 nvarchar(4000)declare @i int=0--set @tbname='bond'--print @tbnamebegin--print @tbnameset @sql2='select @i=count(1) from sys.columns col join sys.tables tbl on ...

https://www.sqlshack.com/understanding-backups-on-alwayson-availability-groups-part-1/Log backup for database "test1_ag2" on a secondary replica failed because the last backup LSN (0x00000020:000000ad:0001) from the primary database is greater than the current local redo LSN (0x00000020:000000ac:0...

SELECT    SERVERPROPERTY('MachineName') AS ComputerName,  SERVERPROPERTY('ServerName') AS InstanceName,    SERVERPROPERTY('Edition') AS Edition,  SERVERPROPERTY('ProductVersion') AS ProductVersion,    SERVERPROPERTY('ProductLevel') AS ProductLevel, ...

https://docs.influxdata.com/influxdb/v1.2/guides/writing_data/http://1316478764.iteye.com/blog/2100778

一、先启动邮件服务SQL SCRIPTS exec master..sp_configure 'show advanced options',1  goreconfiguregoexec master..sp_configure 'Database mail XPs',1goreconfigurego二、创建发邮件时所需要的account 点击(此处)折叠或打开exec msdb..sysmail_add_account_sp  @account_name = 'OPS...

exec master..sp_configure ,1 go exec master..sp_configure ,1 go

1、 备份数据库在主副本上，将需要做AlwaysOn的数据库做一次全备和日志备份（NOTE：禁用事务日志备份作业，如果有的话）替换参数，执行如下脚本生成备份语句，然后执行：DECLARE @DBNameNVARCHAR(255)DECLARE @SQLNVARCHAR(MAX)DECLARE @BackupToPathNVARCHAR(500) SET @DBName='dat...

1.下载最新包wget https://files.phpmyadmin.net/phpMyAdmin/4.6.6/phpMyAdmin-4.6.6-all-languages.tar.gz

1.下载最新包wget https://files.phpmyadmin.net/phpMyAdmin/4.6.6/phpMyAdmin-4.6.6-all-languages.tar.gz

1、安装apachesudo apt-get install apache2为了测试apache2是否正常，访问http://localhost/或http://127.0.0.1/，出现It Works！即是安装成功。2、安装mysqlsudo apt-get install mysql-server安装过程中MySQL要求设定账户有密码，这是与操作系统没关系的账户与密码。3、安装相关模块sudo apt-get install libap...

ApplicationIntent=ReadOnly

use demogocreate table testid([ID] [bigint] IDENTITY(1,1) NOT NULL,col1 varchar(100),[TMSTAMP] [timestamp] NOT NULL)insert into testid(col1) values ('a')insert into testid(col1) values ('b')insert into testid(col1) values ('c')create table testid2([ID] [bigint] IDENTITY(1,1) NOT ...

n.replica_server_name, rs.role_desc, DB_NAME(drs.database_id) as 'database_name', CASE WHEN drs.is_suspended=0 THEN 'RESUMED' ELSE WHEN drs.suspend_reason_desc='SUSPEND_FROM_PARTNER' THEN '在强制故障转移后挂起数据库副本' WHEN drs.suspend_reason_desc='SUSPEND_FROM_APPLY' THEN '在将日志写入文件...

CREATE PROCEDURE [dbo].[sys_viewTableSpace]ASBEGINSET NOCOUNT ON;CREATE TABLE [dbo].#tableinfo( 表名 [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, 记录数 [int] NULL, 预留空间 [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, 使用空间 [varchar](50) COLLATE Chinese_PRC_CI_AS NU...

DELIMITER |CREATE TRIGGER phpmyadmin.tri_hisInsert AFTER INSERTON pma__history FOR EACH ROWBEGIN  INSERT INTO user_act_history (`username`,`db`,`table`,`timevalue`,`sqlquery`) VALUES (NEW.`username`,NEW.`db`,NEW.`table`,NEW.`timevalue`,NEW.`sqlquery`);END|DELIMITER ;

EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0,    @time = 0, @reset = 1EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0,    @time = 0, @reset = 0exec sp_replflush 

点击(此处)折叠或打开

 and may differ in some ways from the official phpMyAdmin documentation. Specifically it does:

/usr/sbin/pma-secureDebian and Ubuntu have changed way how setup is enabled and disabled, in a way that single command has to be executed for either of these.To allow editing configuration invoke:/usr/sbin/pma-configureTo block editing configuration invoke:/usr/sbin/pma-secure...

sudo service apache2 restart