------------------------------ FIX CONNECTION TIME OUT------------------------------
command.CommandTimeout = 250 : returnValue = command.ExecuteNonQuery ' ALEX
------------------------------------ FILES ---------------------------------------------------
VALIDATE MSSQL DATABASE TABLES VIEWS SP
DELETE_ALL_VIEW_AND_SP_BEFORE_MIGRATIONS
------------------------------ SELECT MULTILNE IN ON FIELD ------------------------------
Select perig + ',' AS [text()] From ParPosoTypos ST1 ORDER BY ST1.Perig For XML PATH ('')
------------------------------ RESET DATABASE LOG FILE ------------------------------
CHECKPOINT;
GO
CHECKPOINT; -- run twice to ensure file wrap-around
GO
DBCC SHRINKFILE('MyPage_log', 100); -- unit is set in MBs
GO
fix dynosavros
X=".*" Y=".*" Height=".*" Width=".*" AdapterExpanded=".*" DataTableExpanded=".*" OldAdapterHeight=".*" OldDataTableHeight=".*" SplitterPosition=".*" />
X="61" Y="61" Height="50" Width="165" AdapterExpanded="false" DataTableExpanded="false" OldAdapterHeight="50" OldDataTableHeight="50" SplitterPosition="22" />
---------------------------------------- REPLACE----------------------------------------
remove all comments << '.*$
Remove all empty lines ^(?([^\r\n])\s)*\r?$\r?\n ^$\n
----------- BEFORE DELETE TABLE RECORD ----> VALIDATE NO LINK RECORDS EXIST IN OTHER TABLES -----------------
Delete From SysTableList
Insert into SysTableList ( TableTest , TableCod , TableDelete )
SELECT T.NAME AS [TABLE NAME] , C.NAME AS [COLUMN NAME] , SUBSTRING ( C.NAME , 4 , 255)
FROM SYS.OBJECTS AS T
JOIN SYS.COLUMNS AS C
ON T.OBJECT_ID=C.OBJECT_ID
JOIN SYS.TYPES AS P
ON C.SYSTEM_TYPE_ID=P.SYSTEM_TYPE_ID
WHERE T.TYPE_DESC='USER_TABLE'AND C.NAME LIKE 'Cod%' And LEn (C.NAME) > 4 ;
Delete From SysTableDeletePermitions
DBCC CHECKIDENT ("dbo.SysTableDeletePermitions" , RESEED, 1)
Insert into SysTableDeletePermitions ( CodXristis, FromTable, ToTable, TxtField, CountSql, CountRecAllow, MsgDeleteConfirm, RunSqlBeforeDelete)
Select 0 , TableDelete , TableTest , tablecod ,
'Select count(' + tablecod + ') from ' + TableTest + ' where ' + tablecod + '= ##Cod## ' , 0 , ' Delete First ##Count## records from ' + TableTest , ''
From SysTableList