Ross,

In a Query Analyzer window, execute 'select * from sysdatabases' against
the Master DB. If a database (DB) is published, the 'category' field
will report a '1'. See SQL Books Online for the sysdatabases table.

Hope this helps...

Thanks.

Mark H.

*** Sent via Developersdex http://www.developersdex.com ***

Hi

Is there a stored procedure that can be used (or a select statement) that
can determine if a SQL database has been published?

Many thanks
Ross

The sp_dboption procedure will give you this information. Pass the database
name as the parameter.

The output will look something like this:

The following options are set:
-----------------------------------
published
select into/bulkcopy
merge publish
trunc. log on chkpt.
auto create statistics
auto update statistics


Rand
This posting is provided "as is" with no warranties and confers no rights.