Script for Macro Scheduler

For FGB volume
//Recorded Events

Let>WW_TIMEOUT=5

CapsOff

MouseMove>646,741

Wait>1.252

//Clicking on:

//SnapShotFile>%BMP_DIR%snapshot_0.png

Wait>0.156

LClick

Wait>0.063

-------------------------

While condition

Let>x=0

While>x<1

Let>x=x+1

EndWhile

Quey to find the port number of the sql server

Step 1


DECLARE @tcp_port nvarchar(5)
if @@SERVICENAME = 'MSSQLSERVER'
BEGIN


EXEC xp_regread
@rootkey = 'HKEY_LOCAL_MACHINE',
@key = 'SOFTWARE\MICROSOFT\MSSQLSERVER\MSSQLSERVER\SUPERSOCKETNETLIB\TCP',
@value_name = 'TcpPort',
@value = @tcp_port OUTPUT
END
ELSE
BEGIN
declare @keyname nvarchar(500)


set @keyname = '' + 'Software\Microsoft\Microsoft SQL Server\' + @@SERVICENAME + N'\MSSQLServer\SuperSocketNetLib\TCP'


EXEC xp_regread
@rootkey = 'HKEY_LOCAL_MACHINE',
@key = @keyname,
@value_name = 'TcpPort',
@value = @tcp_port OUTPUT
END


select @tcp_port




Step 2




SELECT DISTINCT
local_tcp_port

FROM sys.dm_exec_connections
WHERE local_tcp_port IS NOT NULL
and net_transport = 'TCP'