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'

Error in restoring the DB in MS SQL

When there is an error to restore the DB with below error message in MS SQL


Backup failed for Server 'localhost\SqlExpress'. (Microsoft.SqlServer.SmoExtended) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10


The solution is to provide access to the path where the log files are to be stored

Method to Move the database Log files (MS SQL)

alter database <db_name>


MODIFY FILE ( NAME = 'WPSBankDB_Log2', filename = 'path where it needs to be moved')


　

alter database <db_name>


MODIFY FILE ( NAME = 'WPSBankDB_Data2', filename = 'path where it needs to be moved' )

Possible reason with Online Interface (Message queue connectivity Problem)

1.  For SIB check whether the param value is entered correctly as "true"as it is CASE SENSITIVE param name is host_online

How to remove administrative shares in Windows Server 2003

Source : http://support.microsoft.com/kb/816524




By default, Windows automatically creates special hidden administrative shares that administrators, programs, and services can use to manage the computer environment or network. These special shared resources are not visible in Windows Explorer or in My Computer, but you can use the Shared Folders tool in Computer Management to view them. Depending on the configuration of your computer, you may see some or all the following special shared resources listed in the Shares folder in Shared Folders:

• DriveLetter$: Root partitions and volumes are shared as the drive letter name appended with the $ character. For example, drive letters C and D are shared as C$ and D$.
• ADMIN$: A resource that is used during remote administration of a computer.
• IPC$: A resource that shares the named pipes that you must have for communication between programs. Note that this resource cannot be deleted.
• NETLOGON: A resource that is used on domain controllers.
• SYSVOL: A resources that is used on domain controllers.
• PRINT$: A resource that is used during the remote administration of printers.
• FAX$: A shared folder on a server that is used by fax clients during fax transmission.

Note NETLOGON and SYSVOL are not hidden shares but are instead special administrative shares.

Generally, Microsoft recommends that you do not modify these special shared resources. However, if you want to remove the special shared resources and prevent them from being created automatically, you can do this by editing the registry.

To remove administrative shares by editing the registry

To remove administrative shares and prevent them from being automatically created in Windows:

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

322756

(http://support.microsoft.com/kb/322756/ )

How to back up and restore the registry in Windows

1. Click Start, and then click Run.
2. In the Open box, type regedit, and then click OK.
3. Locate, and then click the following registry key:
   HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters\AutoShareServer
   Note The registry key AutoShareServer must be set as type REG_DWORD. When this value is set to 0 (zero), Windows does not automatically create administrative shares. Note that this does not apply to the IPC$ share or shares that you create manually.
4. On the Edit menu, click Modify. In the Value data box, type 0, and then click OK.
5. Quit Registry Editor.
6. Stop and then start the Server service. To do so:
   1. Click Start, and then click Run.
   2. In the Open box, type cmd, and then click OK.
   3. At the command prompt, type the following lines. Press ENTER after each line:
      net stop server
      net start server
   4. Type exit to quit Command Prompt.

Issue with Excel - Microsoft Office Excel cannot access the file

Please refer to the below link

http://blogs.msdn.com/b/dataaccesstechnologies/archive/2012/12/19/error-microsoft-office-excel-cannot-access-the-file-while-accessing-microsoft-office-11-0-object-library-from-ssis.aspx

Solution is as below
SOLUTION:
For Windows 2008 Server x64: Create the following directory:
C:\Windows\SysWOW64\config\systemprofile\Desktop
For Windows 2008 Server x86: Create the following directory:
C:\Windows\System32\config\systemprofile\Desktop

Issue with the Web solution - Unable to get the project file from the Web Server

For the "Unable to get the project file from the Web Server" error message, please check the following:

1. Check the webinfo file, make sure the "URLPath" is correct.

2. Recreate the virtual directory for it and restart IIS.

3. Delete the project cache in "C:\Documents and Settings\<username>\VSWebCache"

Additionally I post two related links below, please check them at your convenience.

Unable to get the project file from web server

http://forums.asp.net/t/300746.aspx

Fix for: "Unable to get the project file from the Web server" error

http://askars.wordpress.com/2006/10/28/fix-for-unable-to-get-the-project-file-from-the-web-server-error/ 

To check for a duplicate entry in a column in excel

Take the Column in column A in which the duplicate value needs to be checked.
Use the Below formula in a new column say column B next to the A and insert the formula against it.

The status FALSE means that it is not an duplicate entry

The status TRUE means it is an duplicate entry

Change the Password for the user in IBM MQ

Below is the command to change the Password for  a user in IBM MQ

The below needs to be given in thecommand prompt

AMQMSRVN -user <domain\>NEW_NAME -password <password>