No. Our DBA told me he opened an ticket with MS. I will find out the status later.

Except db_owner, all other rights were granted to user by our DBA. I was told to grant user rights to create view. db_owner was granted to user much later.

Thanks, Chris

I used my own workstation. Kick off SQL Analyzer from SQL Enterprise (SA registered/login), I could create the view without any proble. If I diconnect/connect with user's id/passwrod, then I...

Hi SA24,

Thanks.

That's what I thought. No, he was not trying create on different database.

Server: Msg 262, Level 14, State 1, Procedure v_xxxx, Line 3

CREATE VIEW permission denied in database

Thanks Paul.

I tried to convert Julian date (non-standard, JDE OneWorld format) to SQL smalldatetime. The conversion formular required to use DATEADD function which change Julian date CHAR(6) to DATETIME format....