So what you saying is, just dont make your default login db anything other than master. Its not a bug its just bad practice.

Thanx man.

Thanx.

Who cares, just as long as you enjoy what you do and the paycheck arrives.

Apologies, I have removed it.

I had a similar experience with telephone number selection, using the “LIKE” statement didn’t work very well. I actually filled up all available disk space on the server because MSDB...

In my initial query I used a join as part of the cursor, all joined fields had indexes on, doing that took even longer. My posted example was an improvement...

Thank you very much for your reply, let me check, ill get back to you.