Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Changing SQL Server Database Owner

Changing SQL Server Database Owner

Changing SQL Server Database Owner

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

RE: Changing SQL Server Database Owner

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").  

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)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close