Welsh Corgi (12/14/2012)
This is not a bug.The User has been denied the CREATE VIEW Permission.
Try revoking the deny permission.
REVOKE CREATE VIEW TO [UserName]
I have issued the following
USE [dbname]
GO
REVOKE CREATE VIEW FROM <username>
It completed successfully; but the user has been out of office - so I cannot test it yet. It's his domain account and we're not allowed to have his password. Since it's 2000, I cannot use EXECUTE AS, correct?