Thanks A lot Ted. This worked for me:-).

Regards,

Manjunath C Bhat,

http://www.manjunathcbhat.in

Hi,

Here is a small piece of code which suits ur requirement. Kindly Go through and let me know if you need any thing else.

SET NOCOUNT ON

GO

sp_configure 'show advanced options', 1

GO

RECONFIGURE

GO

sp_configure...