블로그 이미지
010-9967-0955 보미아빠

카테고리

보미아빠, 석이 (500)
밥벌이 (16)
싸이클 (1)
일상 (1)
Total
Today
Yesterday

달력

« » 2024.3
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31

공지사항

최근에 올라온 글

netsh interface ip delete arpcache 로 되는게 아니구나....

 

Posted by 보미아빠
, |

http://answers.microsoft.com/en-us/windows/forum/windows_7-networking/internet-connection-lost-socket-error-10055/07c03b68-56ae-4872-abed-2073e4d81bab

 

http://support.microsoft.com/kb/196271/ko

 

http://esupport.trendmicro.com/solution/en-us/1036554.aspx

 

netsh winsock reset

 

To do this, perform the following:

1.

Make sure that the latest patch for IWSS 2.5 is installed in your machine.

2.

Open the Registry Editor.

Important: Always back up the whole registry before making any modifications. Incorrect changes to the registry can cause serious system problems.

3.

Under the HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters hive, add the following "MaxUserPort" registry key with the following details:

Data type: REG_DWORD

Range: 5,000-65,534 (port number)

Default value: 5000

4.

Set the value to "65530".

5.

Under the same hive, add the "TcpTimedWaitDelay" registry key with the following details:

Data type: REG_DWORD

Range: 0x0 0x12C (0-300 seconds)

Default value: 0x78 (120 seconds = 2 min)

6.

Set the value to "60".

Note: These two keys do not exist by default.

Posted by 보미아빠
, |

 

 

 

select who.[Current LSN], sl.name, cast(who.[Begin Time] as datetime) [Begin Time], what.Operation
  , what.[RowLog Contents 0]
  , what.[RowLog Contents 1]
  , what.*
  from fn_dblog (NULL, NULL) who
  join fn_dblog (NULL, NULL) what
    on left (who.[Current LSN], 17) = left (what.[Current LSN], 17)
  join sys.syslogins sl
    on who.[Transaction SID] = sl.sid
 where who.Operation = 'LOP_BEGIN_XACT'
   and what.PartitionId = (select partition_id from sys.partitions where object_id = object_id('student'))
   and what.[Context] IN ('LCX_HEAP','LCX_CLUSTERED')
   and cast(who.[Begin Time] as datetime) between '20000101' and '20200101'

 

 

http://www.sqlservercentral.com/articles/Transaction+Logs/71415/

http://raresql.com/2012/02/01/how-to-recover-modified-records-from-sql-server-part-1/

http://raresql.com/2012/02/01/how-to-recover-modified-records-from-sql-server-part-2/

 

Posted by 보미아빠
, |

최근에 달린 댓글

최근에 받은 트랙백

글 보관함