I tend to think this method is faster than querying the schema, although that may be what's happening in the backgroud anyway.

It certainly makes the code more readable.

BOb


>>>Search Results
>>>
>>>--------------------------------------------------------------------------------
>>>for "db_ID" using All words
>>>--------------------------------------------------------------------------------
>>>
>>>Search needs a word or phrase to search for. Please try again.
>>>Search needs a category to search for. Please try again.
>>>Please enter a unique search to refine your results. You entered "db_ID" for your previous search, and those results are reflected in the list below.
>>>
>>>Sorry, no results were found for this search.
>>
>>I don't get it. What are you searching for. The docs for that function?
>>
>>DB_ID
>>Returns the database identification (ID) number.
>>
>>Syntax
>>DB_ID ( [ 'database_name' ] )
>
>Thanks. So, which method is better?
>
>The reason, I could not find this function, was simple - I didn't turn on my PCAnywhere, therefore have to work at home without SQL Server installed. I tried to search online, but the search returned 0 records.