If you use SQL Prompt v3 and/or SQL Refactor like me (they are very useful), you will appreciate this hint on how to correctly enable SQL Server Management Studio add-in menus on a non-admin user account.

You have to run this command within each non-admin account you want to use with (read this thread to get more info):

C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe /setup

I am sure I will need this post in a few months, when I will setup my new notebook…

Originally appeared on: http://sqlblog.com/blogs/marco_russo/archive/2006/12/26/use-of-sql-prompt-sql-refactor-with-non-admin-user.aspx