Dooooohhhh sorry guys it was a long day and I forget to put the default instance name first !!!!

cheers for the reponses

Thanks Guys,I had suspected it needed to be in its own batch after a little playing around.

Because we have another database on the same server which both constantly communicate and both of them are of a different collation therefore queries are taking extra time and any...

There is a specific group on windows server for sql server logins, that group has sysadmin right on the database therefore removes the need to create a login with sysadmin...

Thanks had to eventually stop the sql server service, remove the data files for the database which was struggling with recovery and then restored the database from a backup.

All is...