Skip to main content

[SQL] check who is using DB

[SQL] check who is using DB


Query

 exec sp_who;


Result



Labels:

Comments

Post a Comment

Popular posts from this blog

[Cisco] command and CDR log backup by FTP (gw-accounting file)

Below command has been tested with ISR4331 devices.  1. check Cisco device file size command :  a. show current folder dir flash:  b. show all folder and files dir flash 2. check file only start with "cdr." dir flash:cdr.* 3. Remove file (Add option [ /recursive /force]  when you delete file is not recovering free space) delete /recursive /force  flash:cdr.* 4. check subfolder file dir flash:\tracelogs 5. example for log back to ftp https://www.cisco.com/c/en/us/td/docs/ios/voice/cdr/developer/manual/cdrdev/cdrcsv.html#marker-1163166 enable conf t gw-accounting file primary ftp 192.168.1.51/cisco/cdr username cisco password xxxxx secondary sftp 192.168.1.52/cisco/cdr username cisco password xxxxx acct-template callhistory-detail maximum buffer-size  30 maximum retry-count 3 (note : if these setting is not working. check these area, FTP password can not be used @ and some of special characters for this command. Second, ftp location is case sensitive. Please...
Post a Comment
Read more

[Cisco Network] connect by serial and usb & setup IP

Accessing the CLI via PuTTY with a Console Connection Step 1. Connect the switch to the computer using a standard 9-pin serial cable. The Cisco DB9 to RJ45 Console Cable also supports console connections, but only if the switch has an RJ45 Console port. An RJ45 Console port resembles an Ethernet port and is labeled CONSOLE on the back of the switch. Newer laptops don’t have Serial ports on them, so in this case you have to use a USB to Serial adapter. When plugging that into a computer it assigns a COM port number to it that is not COM1. If this is the case for you, you need to know where to look to find the correct COM port number when setting up the connection with PuTTY. Right-click on the Windows logo/Start menu and click on Device Manager to open it. In the Device Manager, you would look to see what COM port is given to the USB adapter. In this case you would need to use COM4 for the Serial line to make the connection.     Step 2. Open the PuTTY application. The  PuT...
Post a Comment
Read more

vmware esxi 백업

  'ESXi'의 버추얼 머신(Virtual Machine)을 옮기려면 백업파일을 받아야 합니다. 'ESXi'에서 버추얼 머신 백업(backup)하면 다운로드할 수 있습니다. 이 방식으로 버추얼 머신을 백업하고 복원하는 방법을 알아봅시다.  실행 중인 버추얼 머신을 정지시키고 진행해야 합니다.   1-1. 웹에서 다운받기 백업받으려는 가상 시스템을 클릭하고 작업 > 내보내기 를 선택합니다. 2-1. 웹에서 복원하기 가상 시스템 > VM 생성/등록 을 선택하고 '생성 유형'을 'OVF 또는 OVA 파일에서 가상 시스템 배포'를 선택합니다. 위에서 다운받은 백업 파일을 넣어줍니다. 이때 넣어줄 파일은 '*.ovf'와 '*.vmdk'입니다. 하드용량에따라 시간이 걸립니다.  5M-10M 속도로 상당히 느립니다. 
Post a Comment
Read more