August 01, 1999 10:01 PM

SQL Server Q & A: Answers from Microsoft

Rating: (0)
SQL Server Magazine
InstantDoc ID #5676
Answers from Microsoft

We use sp_addalias with database scripting. Does the concept of db_owner in SQL Server 7.0 mean the alias concept does not exist anymore?

Aliases still exist in SQL Server 7.0, but don't use them, because they are going away in a future release. If you want to have the same functionality (for the most part) as aliasing a user to database owner (DBO), simply add the user to the db_owner role. The only caveat is that the users must now create objects with the qualifier DBO. For example, instead of:

CREATE VIEW myview AS 
SELECT * FROM authors
run...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

I cannot see table alias names from an IBM DB2 database when trying to import data into SQL2000 using DTS. Is there a possible workaround this problem?

mike draghici 7/17/2001 8:13:13 AM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS