99. NOTES

------------------------------  FIX CONNECTION TIME OUT------------------------------  

command.CommandTimeout = 250 : returnValue = command.ExecuteNonQuery ' ALEX

------------------------------------   FILES   ---------------------------------------------------

CLEAR_DATABASE

VALIDATE MSSQL DATABASE TABLES VIEWS SP

DELETE_SP_WHERE_NO_TABLES

Delete_Extended_Properties

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