>>Anyway, the original question remains: which method is better. They both accomplish the same, I assume, that db_id may be executing the same query, as you gave me, but internally. What should I use or there is no difference?
>
>The information_schema method suppouse to work for any backend that is ANSII compliant. DB_ID as Sql Server specific may be faster. Make your choice and stick with it. BTW, why do you need to check for existence of everything?
>
Thanks. I'll make a comment in SP and would use db_ID then.
The reason, I'm checking, is that I didn't create MACredit database on my local server and want to trap the error.
>>Thanks to you and Bob for the Help.
>>
>>May I call you, I have a quite urgent question and don't know, what keyword is correct to make a search?
>
>Yes.
Ok, I just have to find your phone then. :) May be you can e-mail it to me or send in private?
If it's not broken, fix it until it is.
My Blog