Author: Varinder Sandhu

Varinder Sandhu

SQL SERVER 2008 – Enable xp_cmdshell

SQL, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

—  To allow advanced options to be changed EXEC sp_configure ‘show advanced options’, 1 GO —- To update the currently configured value for advanced options. RECONFIGURE GO —- To enable the feature. EXEC sp_configure ‘xp_cmdshell’, 1 GO —- To update the currently configured value for this feature. RECONFIGURE GO Alternative way 1. Click the Start button. 2. Select All Programs. 3. Navigate to the Microsoft SQL Server 2008 folder. 4. Right Click on Server

» Read more
, ,

Varinder Sandhu – Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development.

Blog-News, Varinder Sandhu

Dear and Respected All, I am pleased to announce that Yesterday (27-December-2010) I have passed the examination of Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development. For more details about this exam 70-433: http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-433&locale=en-us

» Read more
, ,

The partner transaction manager has disabled its support for remote/network transactions

SQL, SQL-Advanced, SQL-General, Varinder Sandhu

First verify the “Distribute Transaction Coordinator” Service is running on both database server computer and client computers Go to “Administrative Tools > Services” Turn on the “Distribute Transaction Coordinator” Service if it is not running If  it is running and client application is not on the same computer as the

» Read more
, ,

ASP.NET IIS Registration Tool – Aspnet_regiis.exe

ASP.Net, Varinder Sandhu

When multiple versions of the .NET Framework are executing side-by-side on a single computer, the ASP.NET ISAPI version mapped to an ASP.NET application determines which version of the common language runtime (CLR) is used for the application. The ASP.NET IIS Registration Tool (Aspnet_regiis.exe) allows an administrator or installation program to

» Read more
, , ,
1 … 25 26 27 28 29 … 31