Mar 12

Run .vbs file without Security warning

Posted on by
0
Digg me

When you try to run/execute a .vbs file, you will be prompted with Security Warning. The security warning is good and it saves your PC from some malicious programs. But its an annoyance when you try to execute your own code.

As VBScript developer you will face this issue a lot when try to Schedule your task. To overcome this Microsoft suggest to set the Environment variable called  SEE_MASK_NOZONECHECKS to 1.

set oShell= CreateObject("Wscript.Shell")
set oEnv = oShell.Environment("PROCESS")
oEnv("SEE_MASK_NOZONECHECKS") = 1
oShell.Run "c:\projects\sample.vbs   /norestart",0,True
oEnv.Remove("SEE_MASK_NOZONECHECKS")

 

Recently tested this code on  Windows 7 64 bit and it worked fine.

Source: 

http://support.microsoft.com/kb/889815

Mar 12

Save and Schedule SSIS Packages using SQL Server 2008 R2 for Nonadmins

Posted on by
0
Digg me

How to Save and Schedule SSIS Packages using SQL Server 2008 R2 for Non Administrators

Step 1

Upgrade SQLServer 2008 R2 with latest SP

Step 2

Saving Package from Business Intelligence (.dtsx) to SQL Server

EXEC sp_addrolemember 'db_ssisltduser', '<<user/group>>'

EXEC sp_addrolemember 'SQLAgentUserRole', '<<user/group>>'

Step 3

Follow this step for Connecting to a Remote Integration Services Server

http://msdn.microsoft.com/en-us/library/aa337083(v=sql.105).aspx

Oct 10

Add INR [ ₹ ] to WooCommerce Settings

Posted on by
1
Digg me

 

 
Best practice is to download the file settings-init.php, make changes and upload it back.
 
1. Download  woocommerce/admin/settings/settings-init.php  (plugins folder)
 
2. Code to add currency starts between Line 45 to 72
 
3. Now add this line in suitable position  'INR' => __( 'Indian Rupee (& # 8377;)', 'woocommerce' ),
 
[HTML code  &#.. should be without spaces]
 
4. Save & Upload to woocommerce/admin/settings folder
 
 
Note : & # 8377;   is the HTML code for new Indian Rupee Sign
Oct 01

How to Delete Project folder from Team Foundation Server ?

Posted on by
0
Digg me

 

To delete folder from TFS 2010, follow these steps.  Note : You must be admin privilege to perform this operation.

It can done remotely from machine which has Visual Studio 2010.

 

x64 Installation

C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE>tf destroy $/root/projectfolder  /silent

or

x86 Installation

C:\Program Files (86)\Microsoft Visual Studio 10.0\Common7\IDE>tf destroy $/root/projectfolder  /silent

/silent : Wont prompt you with too many questions. 

 

For other operations such as Deleting a file, Branching, Shelving.. review this link from Microsoft.

http://msdn.microsoft.com/en-us/library/z51z7zy0(v=vs.100).aspx