Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I find out, if database (@DataBaseName) exists?
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00761718
Message ID:
00762210
Views:
20
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform