SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in SQL Assistant with VS 2012      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic SQL Assistant with VS 2012 Author Message neverden Joined: 02 Dec 2008 Posts: 58 SQL Assistant with VS 2012 I have been using SQL Assistant with SSMS for years. I am going to start using SQL Server Data Tools with VS 2012. I have it loaded and set to load the plugin. When I open up a query window, connect to a DB and start typing it opens up a SQL Assistnat window to connect to a database (even though I am already connected). Should this happen? seems very odd to me. I would think it would act like SSMS. Also, I don't see SQL Assistant menus in VS. Should I? I think I just don't have it setup correctly. Mon Jun 10, 2013 8:11 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 Please try once starting both SQL Assistant and VS in Run as Administrator mode. Please let us know if this helps. Mon Jun 10, 2013 8:35 am neverden Joined: 02 Dec 2008 Posts: 58 I now have the menus (which is good) but its still trying to connect o the DB using the SQL Assistant dialog. In SSMS it just uses the connection that SSMS makes. Shouldn't it work the same with VS? Mon Jun 10, 2013 10:40 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 No. It doesn't work the same way in VS. VS db connection is not accessible to SQL Assistant and that's why it needs its own connection. Please use the Auto-connect option to avoid repeating connection prompts. Mon Jun 10, 2013 10:54 am neverden Joined: 02 Dec 2008 Posts: 58 I change database and servers a lot. Will this cause issues? Will I have to change the connection in VS and SQL Assistant every time I change database/servers? Mon Jun 10, 2013 11:18 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 Does the contents of SQL Assistant popups change when you change the database context? Mon Jun 10, 2013 2:18 pm Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.