SQL Server security best practice

Security! This is the word comes in mind of every concerned person when it come...

Change the Collation Settings in MS SQL Server

This post will show you how to change the collation settings in MS SQL Server for specific database...

Resolve collation conflict

In this post I will show you how you can resolve collation conflict error...

Book: SQL Server 2008 High Availability

In this book I have tried to cover every single piece of information that might requires for installing and configuring SQL Server HA option like Clustering, Replication, Log Shipping and Database Mirroring...

Why to recompile Stored Procedure

Generally, we create views and stored procedures (proc here after) ...


Change Authentication Mode with Registry

What if we need to change / read / write some registry entry in Server but we donot have access to server!!!! but at the same time we do have SA/Admin privilege on SQL Server (Assuming we need to change registry settings on SQL Server itself ) for example while setting up SQL Server they have installed SQL Server with *Mixed Authentication Mode* and now we need to change it to *Windows Only Authentication Mode* to do so from Query Analyzer we do have xTended Store Procedure to help us they are xp_regread and xp_regwrite
For an instance assume that your Authentication Mode is set to *Mixed Authentication Mode* to read it run below query in QA if it shows ‘0’ or '2' means that authentication mode is Mixed

EXECUTE master..xp_regread

Now if we wants to change it to *Windows Only* run below query in QA

declare @md int

set @md=1

EXECUTE master..xp_regwrite



'LoginMode', 'reg_dword', @md

This will make changes in your Registry and change your *Authentication Mode* also.

Disclaimer : In the example above both the xTended Stored Procedure used are Undocumented so use it at your own risk and please check for its availability / support before using it.

This posting is provided * AS IS * for the shake of knowledge sharing only.




Hemantgiri S. Goswami is SQL Server Specialist and Consultant, he is former SQL Server MVP. Hemantgiri is contributing to the SQL Server Community by participating in various SQL Server forums, authoring articles at:

Hemantgiri is founder and leader of the Surat User Group which primarily focusing on SQL Server and Windows OSs.

Hemantgiri S. Goswami Blogs at SQL Server Citation recent he has started writing on SQL Server in his native language Gujarati visit SQL Server Citation - Gujarati . Hemantgiri was awarded Most Valuable Professional (MVP) award by Microsoft for his contribution to the SQL Server Community.




Change settings for Welcome Screen in Windows XP

its vulnerable to bypass welcome screen, i don't suggest to use this option but as you don't wants it you may either use standard method of login by hitting
start-> settings-> control panels-> administrative tools-> Local Security Policy-> Security Options-> Interactive Logon :do not require CTL+ALT+DEL --(Change the value to ENABLE)

or do a trick with
Start-> Settings-> Control Panel-> User Accounts

This postings provided AS IS


MS Released SQL 2005 Everywhere Edition CTP

SQL Server Everywhere Microsoft SQL Server 2005 Everywhere Edition CTP available :


Securing Microsoft SQL Server

their are several ways to secure your SQL Server
1). Strengthen Password Mechanism
2). Using NTFS File System
3). Change the Port of SQL Server other than default
4). Use named instance
5). Set firewall
6). Using Windows Authentication
7). Using EFS

i would suggest to refer below links for more :

www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlc2.mspx -- C2 Audit






Login fail for user %s

if you get an error message like "Login fail for User %s , not associated with trusted connection"
here is a KB for your reference.


This posting provided AS IS

Upgrade help to SQL Server 2005

here is a reference article for those who wants to upgrade to SQL Server 2005

Microsoft SQL Server 2005 SP 1.0

MS released Service Pack Version 1.0 for SQL Server 2005 ,
here is download link

Download BPA for Microsoft SQL Server 2000

here is a download link for Best Practices Analyzer Tool for Microsoft SQL Server 2000 1.0


Handling Deadlock in Microsoft SQL Server

I have found wonderfull KB for handling deadlock conditions in SQL Server
http://support.microsoft.com/kb/118552/en-us just FYR

Not associated with a trusted SQL Server connection

You may receive a "Not associated with a trusted SQL Server connection" error message when you try to connect to SQL Server 2000 or SQL Server 2005


Microsoft SQL Server doesn't exists or access denied

whenever you get an error like "SQL Server does not exists or access denied"

refer below KB

Troubleshoot Microsoft SQL Linked Server

this is a KB for How to troubleshoot error 7391 that occurs when you use a linked server in SQL Server http://support.microsoft.com/kb/306212/en-us

Authentication Method Troubleshooting in ASP / SQL

Dear all,
here is a KB link FYI for Authentication methods for connections to SQL Server in ASP




Hi All,
today when i googling i reckon for GMAIL Drive , i google it to find out that still project is continue or not here is a link for GMAIL Drive project on source forge http://pgd.sourceforge.net/ and http://www.viksoe.dk/code/gmail.htm its damn easy working with this you can backup your important document with this tool , it provides funcationality for backup of documents by just drag and drop .


MSN Screen Saver

Today i have download MSN Screen Saver, you can personlized it the way wants you can add RSS feeds as per your choice , you can the whether information of your city,can display photos,can see news also.... nice Screen Saver.


A Web Forum for IT Professional and Student

Dear All,
we have started a Web Forum for IT pepole , out main goal is to serve our best to the society , students of the IT Colleges and IT Professionals by this we can share the knowledge and help peers and offcourse we can also learn something new.
Hope you will also enjoy with us ....
I must give credit to my friend Neelesh Desai to support me to host the Web Forum on his website , Developement team of the Snitz to develop such a good software.
here is a URL of our Forum hosted Aastha Computers
http://www.aasthacomputers.com/forum or



Auditing MS SQL DML Statements

i have wrote an article on "Auditing MS SQL DML Statements" , how to Audit insert / update / delete statements to get information from which system and who execute the statements , this will gives you power to audit your database without third party software. It uses INSERTED and DELETED tables to get the records that are updated/deleted and inserted.
click here to read full article.

Backup Non System Database at Once

To take backup of MS SQL Non System Database at once, i have wrote a small script for that , click here to read MS SQL Script .