Development tool OTHER THAN Enterprise Manager ???

Question

Development tool OTHER THAN Enterprise Manager ???

Jeff-67583

SSCertifiable

Points: 5625
More actions
April 12, 2005 at 10:07 am

#85527

Hi,
Developer permissions use to be "dbo". The organinzation has implemented change management methodologies. The development environments are now set to db_ddladmin, db_securityadmin, db_datawriter, and db_datareader. Currently, our developers are using Enterprise Manager to develop schema objects. They prefer this tool over MS Query Analyzer (for complex joins).
While using EM, they constantly get "nag" screens: ie: Creating a new table or going into Design View for a table: "you are not logged on as the database owner or system administrator. You may not be able to save cahnges to tables you do not own" ... contine OK/Help
Additionally, they sometimes have a second step of going back into Design View to change the object owner from themselves (NT account) to "dbo". Or when they change it, they receive the following "nag" screen: "Warnings were encountered after the pre-save validation process, and may result in a failure during save. Do you want to continue attempting to save?" ... Yes/No/Save Text File/Help
Needless to say, these "nag" screens are beginning to frustrate them. Note: MS Query Analyzer does not produces similar "nag" wranings.
Are there any other GUI tools that developers could use for development that allows them to create objects as if they were the "dbo" but without full "dbo"/db_owner permissions? Or is there a way to disable these "nag" screens?
Many thanks. Jeff

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 738673 More actions · Answer 1

There are some third party development tools like those from Apex SQL, Embarcadero, and Imceda. Not sure how GIU they are.

Gé Brander SSCarpal Tunnel Points: 4353 More actions · Answer 2

We are very happy with Embarcadero DBArtisan. Same possibilities as EM, and you can manage Oracle, Sybase and DB2 databases too with the same tool, and same appearence.

philcart SSC-Forever Points: 47797 More actions · Answer 3

You could always get your developers to stop being lazy and write some code

Next thing they'll be wanting to run a code generation tool to write the application code

eg: http://www.yessoftware.com/products/product.php?product_id=1

--------------------
Colt 45 - the original point and click interface

Jeff-67583 SSCertifiable Points: 5625 More actions · Answer 4

Thanks for the sugeestions.

Steve - any insight into if these issues will be alleviated with MSSQL 2005?

Many thanks. Jeff

K. Brian Kelley SSC Guru Points: 114704 More actions · Answer 5

Too early really to say on SQL Server 2005. Beta 3 is yet to come out and there may be some changes there. ApexSQL Edit does allow object creation similar in means to the way Access/SQL Server Enterprise Manager does it. Can't speak for the others.

K. Brian Kelley
@kbriankelley

Jeff-67583 SSCertifiable Points: 5625 More actions · Answer 6

Hi Brian,

I've peformed some initial analysis using the ApexSQLEdit tool. In your experience using this tool, is there a functionality similar to MS EM and Access that allows "Show table(s)" ... to allow developers to graphically select table/view and complete relationship joins?

Many thanks. Jeff