Category: Computer

computer related topics

0

Transmission behind proxy on nginx and blocklist

Transmission docker on Raspberry PI Create docker   docker create –name=transmission \ -v /home/dockeruser/transmission/config:/config \ -v /home/dockeruser/transmission/downloads:/downloads \ -v /home/dockeruser/transmission/watch:/watch \ -e PGID=1001 -e PUID=1001 \ -e TZ="America/Los_Angeles" \ -p 9091:9091 -p 51413:51413 \...

0

FTPS via WinSCP.NET

Download COM object from https://winscp.net/eng/docs/library#vbnet or from NuGet Example Code in VB.net   Imports WinSCP —–   Try ‘ Setup session options Dim sessionOptions As New SessionOptions With sessionOptions .Protocol = Protocol.Ftp .FtpSecure =...

0

To get list of tables used in a stored procedure

;WITH stored_procedures AS ( SELECT o.name AS proc_name, oo.name AS tables_used_in_procedure, ROW_NUMBER() OVER(partition BY o.name,oo.name ORDER BY o.name,oo.name) AS ROW FROM sysdepends d INNER JOIN sysobjects o ON o.id=d.id INNER JOIN sysobjects oo ON...