MSSQL_NOOB (12/13/2012)
MSSQL 2000A username has a DB_OWNER privilege. But when he tries to create views OR create dts package; it gives him a permissions error.
What is the specific Error Message?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/