Changing SQL Server Database Owner

[sqldba]

Hi, I'm a DBA supporting a SQL Server application. I'm not familiar with Crystal Reports. Developers wish to create and use views with Crystal Reports. We allow them to initially create the views with them as owners. Creating reports on this view apparently inserts the development database name and their owner id in the Crystal report. Problem is upon implementation. When DBA creates the view with DBO owner id., developers are saying that their report won't run against the DBO owner id view. Since user owner id is imbedded in the Crystal Report... developer says they have to go and change every reference to field individually, replacing their user id with DBO owner id. Is there a better way?

Thanks in advance for your help, Guy

 

[balves]

Go to the Database menu in Crystal Reports and use the Set Location menu item. For each table in the report, and for each table in any sub-report remove the owner part of the table path (e.g., "dbo.Customer" to "Customer&quot.

If you are not connecting to the live database in VB or some other front-end, make sure that the database that the report uses is the live database, not the test database, before you roll it out to users. Brian J. Alves
Terrier Consulting, Inc.
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer
(Currently available for consulting in Chicago)