Category: SQL

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
, ,

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 SQL Server Registration Tool – Aspnet_regsql.exe

ASP.Net, SQL, SQL-General, SQL-Tips and Tricks, SQL-Utilities, Varinder Sandhu

This tool is a part of Microsoft .Net framework and like other tools this tool is also located in [drive:]%windir%Microsoft.NETFrameworkversion folder on your Web server.The ASP.NET SQL Server Registration tool is used to create a Microsoft SQL Server database for use by the SQL Server providers in ASP.NET, or to

» Read more
, , ,

SQL Server 2011-Denali

SQL, SQL-General, SQL-Server 2011, Varinder Sandhu

SQL Server code-named “Denali” Microsoft SQL Server code-named “Denali” empowers organizations to be more agile in today’s competitive market. Customers can efficiently deliver mission-critical solutions through a highly scalable and available platform. Industry-leading tools help developers quickly build innovative applications while data integration and management tools help deliver credible data

» Read more
, ,

Migrating Logins from One SQL Server to Another

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

As I need to migrate the databases from one server to another server. I have to deal with migrate not only the data, but the SQL Server logins that access that data as well. There may be different ways to migrate SQL Server logins like you can manually re-enter the

» Read more
, , , ,
1 … 12 13 14 15