Hi Frnds,
If anyone had converted your database from SQL Server 2000 to 2005.Beware of this issue,in 2005 version,by default enlist is true.bcoz of this,a simple transaction(called from .NET appln) will be treated as a distributed transaction and try to make of use MSDTC(Distributed transaction coordinator) service.If this service is not installed or permissions are deined to access it,we will get an exception.so,make sure to add enlist=false to your connectionstring after migrating it to 2005,if you dont require MSDTC service.