As wierd as it sounds this issue was resolved by restarting the SQL Server.

Maybe just restarting the SQL services could do the trick too.

Just checked ANSI settings and Server/database/Tempdb collation is the same as the other server where this query works. 🙁

Thank you for your advice Grant. I will check the settings as suggested and get back shortly. It is really strange that I get no errors logged in any of...

Thank you all for your valued advice. The server in question is a virtual server with SAN connected disks. What I find is that queries causing most IO are...

Thank you GilaMonster and Lynn Pettis for your advice.

Your advice and help is highly appreciated.

Regards,

Kailash.

Thank you Koen Verbeeck!! I will proceed with the install.

Thank you, thats great and has done the trick.

kind Regards

Kailash.

Have a look at this, hope it helps -

Get Back into SQL Server After You've Locked Yourself Out - http://www.mssqltips.com/sqlservertip/2633/get-back-into-sql-server-after-youve-locked-yourself-out/

Just a thought, Can I not do the following?

1) Provide only CREATE VIEW permissions on the DATABASE (Database Permissions)

2) Create a new Schema and give Alter permissions to this...

Thank you all (Lowell, Steve Jones & Jason) for all your help and advice. I will work with Lowell's DDLTrigger example and customise it to suit my needs.

Lowell, Thank...