/* Delimiter changed to ; */ /* Writing to session log file now: C:\Users\Justin Shea\AppData\Roaming\HeidiSQL\Sessionlogs\000002.log */ /* Connecting to ad-fl.cfrclw3gxpkn.us-east-1.rds.amazonaws.com via Microsoft SQL Server (TCP/IP), username adfl, using password: Yes ... */ SELECT @@SPID; /* Connected. Thread-ID: 78 */ SELECT DATEDIFF(SECOND, "login_time", CURRENT_TIMESTAMP) FROM "master"."dbo"."sysprocesses" WHERE "spid"=1; SELECT @@VERSION; USE "ad_live"; /* Entering session "AD Live" */ SELECT *, SCHEMA_NAME("schema_id") AS 'schema' FROM "ad_live"."sys"."objects" WHERE "type" IN ('P', 'U', 'V', 'TR', 'FN'); SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='dbo' AND TABLE_NAME='advertisment_adInterstitial'; SELECT C.CONSTRAINT_NAME, C.CONSTRAINT_TYPE, K.COLUMN_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS C INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS K ON C.CONSTRAINT_NAME = K.CONSTRAINT_NAME AND K.TABLE_NAME='advertisment_adInterstitial' AND K.TABLE_SCHEMA='dbo' WHERE C.CONSTRAINT_TYPE IN ('PRIMARY KEY', 'UNIQUE') ORDER BY K.ORDINAL_POSITION; SELECT '' AS "Collation", '' AS "Charset", 0 AS "Id", '' AS "Default", '' AS "Compiled", 1 AS "Sortlen"; SELECT TOP 1000 * FROM "ad_live"."dbo"."advertisment_adInterstitial"; SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='dbo' AND TABLE_NAME='advertisment_adInterstitial'; SELECT C.CONSTRAINT_NAME, C.CONSTRAINT_TYPE, K.COLUMN_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS C INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS K ON C.CONSTRAINT_NAME = K.CONSTRAINT_NAME AND K.TABLE_NAME='advertisment_adInterstitial' AND K.TABLE_SCHEMA='dbo' WHERE C.CONSTRAINT_TYPE IN ('PRIMARY KEY', 'UNIQUE') ORDER BY K.ORDINAL_POSITION; UPDATE TOP(1) "ad_live"."dbo"."advertisment_adInterstitial" SET "script"='test' WHERE "id"=1 AND "script"=' ' AND "image"='no_image.jpg' AND "link" IS NULL AND "status" IS NULL AND "create_date"='15/07/2009 08:43:56' AND "script_bottom" IS NULL; /* SQL Error (3621): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value The statement has been terminated. */ UPDATE TOP(1) "ad_live"."dbo"."advertisment_adInterstitial" SET "script"='test' WHERE "id"=1 AND "script"=' ' AND "image"='no_image.jpg' AND "link" IS NULL AND "status" IS NULL AND "create_date"='15/07/2009 08:43:56' AND "script_bottom" IS NULL; /* SQL Error (3621): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value The statement has been terminated. */