> I've also tried connecting directly to the database as the > main user ( not SA )... and I get a permission denied error. > > Server Msg: 262, State: 42000, [Microsoft][ODBC SQL Server > Driver][SQL Server] > CREATE PROCEDURE permission denied in database 'mydbname'.
I'm not sure what you mean by the "main user", but it's clear that the login you're using doesn't have rights to create procedures. That's usually a good thing; the login used by your application doesn't typically need to create, alter or drop schema objects. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209408 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
