Search

MyPAGE MyPAGE
  • MyPage
  • Documentation

99. NOTES

SYSTEM DATA

Empty
  •  Print 
  • Email
Details
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

 

Documentation

  • 10. ΒΑΣΙΚΕΣ ΛΕΙΤΟΥΡΓΙΕΣ
  • 20. CRM
  • 22. CRM TASK
  • 30. ACTION
  • 40.MASS EMAIL
  • 50. REPORT AND LOG
  • 60. ΕΚΤΥΠΩΤΙΚΑ
  • 72. ΛΟΓΙΣΤΙΚΗ (CONFIG)
  • 80. PHONE (SIP)
  • 82. EMAIL OUT
  • 83. EMAIL IN
  • 90. LAW OFFICE CONFIG
  • 99. NOTES
  • ESHOP
  • SECURITY
  • Άλλα θέματα
  • Παραμετροποιησεις
  • Σ Τ Α Τ Ι Σ Τ Ι Κ Α
  • ΣΤΟΙΧΕΙΑ ΠΡΟΙΟΝΤΟΣ
  • manual
  • MyPage
  • Documentation
 
Copyright © 2015 Minitek. All Rights Reserved. 

This website uses cookies so that we can provide you with the best user experience (Cookies Policy).