Data Adapter says I don't have perms to create Stored Procedure

[other3]

This is in a database that is local to my own machine.

Everything I know I learned from The Grateful Dead and Buffy The Vampire Slayer
Charlie

 

[Sheco]

Sounds like a permissions issue.

 

[other3]

Yes I agree. Do you know what I need to do to change that. I can read and write and do everything else from VB.NET to that particular Database on the server, but it won't let me create stored procedures.


Everything I know I learned from The Grateful Dead and Buffy The Vampire Slayer
Charlie

 

[earthandfire]

So far you haven't said what database system it is, so really there is nothing much that we can say to help, other than make wild guesses.

 

[other3]

Sorry, SQL Server 2000 Developer.

Everything I know I learned from The Grateful Dead and Buffy The Vampire Slayer
Charlie

 

[earthandfire]

Using Enterprise Manager, right click the database in question and select Properties. In the dialog box that opens, select the Permissions tab and then select Create SP for the user that you are using to log on through your VB app.


Hope this helps.

 

[other3]

I'll know tomorrow. If it doesn't Buffy's coming to get you.


Everything I know I learned from The Grateful Dead and Buffy The Vampire Slayer
Charlie