Start 32 bits ODBC DSN editor from command-line
To start the 32 bits ODBC DSN editor, run: %WINDIR%\System32\odbcad32.exe
Month: May 2011
Determine the correct w3wp.exe process ID, to attach the Microsoft Visual Studio debugger to, by using the Windows Task Manager
If you have multiple application pools started in IIS 7 and you want to determine which w3wp.exe process to attach the Microsoft Visual Studio 2010 debugger to, you can use the Microsoft Windows Task Manager.…
Using anonymous authentication on a .NET 4.0 WCF service that calls another WCF service
Let’s say you created a ASP .NET 4.0 website that uses a WCF service to get data from a Microsoft SQL Server database. The website uses anonymous authentication and you are asked to show data…
To copy the contents of a folder to an other folder, including all subfolders in C#
To copy the contents of a folder to an other folder, including all subfolders, overwriting existing files, you can use the following function in C#: /// <summary> /// Copies the contents of a folder,…
Solving: Search in "All Mail Items" in Microsoft Outlook 2010, does not return any result
When you have instant search disabled, searching in Microsoft Outlook by using the "All Mail Items" button, does not return any result: Solution To search in "All Mail Items", without having instant search…
Using Microsoft Outlook 2010 with BPOS without local *.ost file.
Install Microsoft Outlook 2010, after installing don’t start Microsoft Outlook 2010, first create a mail profile in Start > Control Panel > Mail Follow the steps on http://blogs.technet.com/b/simonmay/archive/2010/08/16/manually-configure-outlook-2010-for-exchange-online-bpos.aspx to manually connect Microsoft Outlook 2010 to…
Scripting triggers in Microsoft SQL Server
By default when you use the Script Wizard in Microsoft SQL Server Management Studio to script objects in a database, triggers are note included. You can include triggers if you [Include all objects] and [Set…
Fixing the VS2010 sp1 error: The command you are attempting cannot be completed because the file …vdproj is under source code control and is not checked out
After installing Microsoft Visual Studio 2010 sp1 I was getting the error: Fixing the VS2010 sp1 error: The command you are attempting cannot be completed because the file …vdproj is under source code control and…
Using the sysdtslog90 table for logging package (user) variables in Microsoft SQL Server 2005 Integration Services
The sysdtslog90 table is used by Microsoft SQL Server 2005 SSIS to log messages. If you want to use this table for custom logging, you can user event handlers on SSIS tasks. - Select the…
Solving: SQL Server Integration Services Script Task has stopped working in Microsoft SQL Server 2005 sp4 BIDS on Windows 2008 R2 sp1 x64 machine
I was getting the error "SQL Server Integration Services Script Task has stopped working", when I set a breakpoint in a script task in Microsoft SQL Server 2005 with sp4 BIDS on a Microsoft Windows…