Check for Exclusive Access before running script?

[Siiig]

Hey guys, I tried to search the forums briefly, but got a lot of complaints about exclusive access causing problems--I actually want it.



I have a VB Script in my database that runs through and refreshes a number of static tables from an ODBC source (required for speed down the line), and--while I know I should be splitting the database into a front/back configuration, it's currently just a single DB.

We're working with the fact that we need to get everyone out of the DB before we can update it, but if someone triggers the update, we tend to lose a few tables (because the script runs as far as it can before bombing out).

I would really like to have a check before anything executes that basically just says "Do you have exclusive access? Yes? Run script. No? Tell the user we're not exclusive </3"


I found some information about the AllPermissions() function, but I can't figure out how to use it =X

[ssanfu]

I would really like to have a check before anything executes that basically just says "Do you have exclusive access? Yes? Run script. No? Tell the user we're not exclusive </3"

I found code here that checks if dB opened exclusive or not:

How to Determine If a Database Is Open Exclusively
http://support.microsoft.com/kb/117539