The Transact-SQL script included with SQL Workbook Publisher, Sqlwpub.sql, must be installed in each SQL Server database that will be used to retrieve information and publish workbooks. Workbooks must be published to the same database that stores the data used to create the workbook. Data can be retrieved from only one database per workbook with a SELECT statement. You can use stored procedures in scripts to access data from multiple databases and servers if the stored procedures are registered in the databases they will be accessing.