Database Discussion - Quick help please! Enterprise manager

Print Page | Close Window

Quick help please! Enterprise manager

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=13720
Printed Date: 30 March 2026 at 4:12am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Quick help please! Enterprise manager

Posted By: Gullanian
Subject: Quick help please! Enterprise manager
Date Posted: 08 February 2005 at 5:46pm

Trying to add records etc to my local SQL server. Get:

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E09)
SELECT permission denied on object 'v2_tblUsers', database 'drum_world2', owner 'dbo'.
/drumworld2/test.asp, line 28

I went to permissions for all account in the database drum_world2 and checked everything I saw but no help, anyone instruct me what to click to fix this?

Replies:

Posted By: Gullanian
Date Posted: 08 February 2005 at 5:52pm

nm fixed it with some random clicking here and there

Posted By: Gullanian
Date Posted: 08 February 2005 at 6:03pm

On another note, any way to do the right click generate sql script and get it to generate all records as well?

Posted By: michael
Date Posted: 08 February 2005 at 10:14pm

I have a .net windows app that does it very well. pm me your email and I can send it to you.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: Gullanian
Date Posted: 09 February 2005 at 3:48am

Thanks for the offer it's ok its sorted