Posted by monty on 08/22/07 11:48

On Aug 22, 3:31 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> monty (manishgandh...@gmail.com) writes:
> > yes by enabling the DB_OWNER i mean giving DB_OWNER role to the user.
> > And I am running with the same user in QA with which i am connecting
> > through API.
>
> > Also I have examined ISqlServerErrorInfo object to get the error
> > message because of that only I am getting error DB_E_ERRORSINCOMMAND.
>
> > Feel free to ask for more information.....
>
> I guess then I would need to see your code, including the error-handling
> part...
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

it's ok....but i just want to know....do we need to have DB_OWNER role
for executing DDL statements through OLEDB API ??

• Next in forum: Re: ssis EXEC command
• Prev in forum: Re: Restore LDF file after restoring backups in SQL Server 2005?
• Thread view: Re: Problem with DB_OWNER role..

[Reply to this message]