Pages

▼
Showing posts with label Admin. Show all posts
Showing posts with label Admin. Show all posts
Thursday, June 18, 2009

TCP Port of SQL Server

›
By default the default TCP Port for SQL Server is 1433.  It can be changed for security purpose to minimize the potential threat of a hacker...
Friday, May 22, 2009

Expiration Date of SQL Server Evaluation Edition

›
If you have installed the Evaluation / Trial Version of SQL Server, you may like to find out what is the expiry date of the Trial Version.  ...
Friday, February 20, 2009

SQL Server Versions and Editions.

›
Lets see how to find which Sql Server Version is installed and Service Packs applied on your machine- To know Execute SELECT @@version If y...
1 comment:
Sunday, December 21, 2008

How To Enable Xp_CmdShell in Sql Server?

›
Today I will show you how to enable the Xp_CmdShell extended stored procedure in Sql Server 2005 and 2008. Well normal error message you...
7 comments:

How to configure SQL Server 2005 to allow remote connections

›
By default, SQL Server 2005 does not allow remote connections. To configure SQL Server 2005 to allow remote connections, we need to follow t...
Sunday, November 23, 2008

Some Useful Views And SPs in Sql Server.

›
Here is the good collection of views and Store Procedure which can be very useful. Applicable for Sql Server 2005 and + VIEWS : To use all t...
Saturday, November 22, 2008

Sql Server Connection Issues - Msg 18456

›
Now I'll try to help you understand the connection issues with Sql Server. Today we will focus on the error "Msg 18456, Level 14, S...