Within SQL Server 2005 you could take help of certificates to restrict the access from a particular client's machine. Few times (even me) confused with or get an impression that SSL encryption is same, for more information on SSL( Secure Sockets Layer) refer to KBA316898 in this case. There is much...
Problem: SQL Server 2005 error: xp_cmdshell: a call to 'CreateProcess' failed with error code: '5'. We get above error when trying to execute XP_CMDSHELL even though it has been enabled using Surface Area Configuration tool and the login has SYSADMIN privileges. Solution: First of all...