SQL Master

Well this is most common question I answered many times on Sql Server MSDN forums. How to remove Time from Datetime column in Sql Server 200...

In my previous post I wrote about Linked Server with Excel. Now we will see how to create a linked server for DBF files. That is accessing ...

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

By default, SQL Server 2005 does not allow remote connections. To configure SQL Server 2005 to allow remote connections, we need to follow t...

How to create a check constraint to allow alphabets i.e. A-Z characters only or alphabets + numbers with no special characters in Sql Server...