Register | Login
Posting to the Forums  Minimize 

To post to the forum:

  • You must not be in the "aggregated" view.  Select a forum to which you wish to post.
  • You must be logged in to the website.  If you do not wish to register, you can use the anonymous login:

    User: anon
    Pass: password

Use the "login" link at the top right of this page to log in.

Print  

Discussions  Minimize 
 
  Forum  SqlAssist for S...  Bugs and Misbeh...  SQL Server Management Studio Express Edition problem
Previous Previous
 
Next Next
New Post 9/17/2007 7:06 AM
  anonymous
77 posts


SQL Server Management Studio Express Edition problem 

Hello,

I'm using SQL Server Management Studio 2005  Express Edition SP2.

I've downloaded the latest SqlAssistSSMS2005Setup.msi from your website.

I've closed all applications and installed the .msi (I didn't have any previous version installed)

I launch the SQL Server Management Studio and login.

Then I open a stored procedure from a database and start typing 'SELECT'  but I see no new toolbar and no new menu options anywhere.

Everything inside SQL Server Management appears as nothing has been changed.

How do I get the SqlAssist functionality working ? Thanks for helping because I'm confused.

I mentioned that I've checked these two DLLs to be registered

%systemroot%\Microsoft.NET\Framework\v2.0.50727\regasm SqlAssistSSMS2005.dll

%systemroot%\Microsoft.NET\Framework\v2.0.50727\regasm SACore.dll

 

 
New Post 9/19/2007 12:00 AM
  Steve Schaneville
149 posts


Re: SQL Server Management Studio Express Edition problem 

I'm sorry, but SqlAssist does not work with the Express edition of SSMS.  This is actually dictated by Microsoft... they are not allowing developers to write plugins for that version of the application. 

~Steve

 
New Post 9/19/2007 12:37 AM
  anonymous
77 posts


Re: SQL Server Management Studio Express Edition problem 

 

Hello,

Thank you very much for answering. Yes, I'm running SQL Server Management Studio 2005 Express Edition.

- Sorry to have bothered you, I apologize if I am wrong, could you please write explicitly in the Download page that

that SqlAssist is not available  for SSMSEE? Thank you very much. The Dowload page is this:

http://www.roundpolygons.com/SqlAssist/Download/tabid/94/Default.aspx

- I think there has to be a means to simulate Intellisense in the Express Edition as well.

The Red Gate "SQL Prompt" product does that successfully for the Express Edition.

I don't know their implementation details of course. Maybe some kind of Win32 hooks would help controlling the SSMSEE code editing window.

Once a DLL hook is loaded in the SSMSEE process address space, then the content of the SSMSEE code editing window could maybe be read and modified ?

 
New Post 9/19/2007 8:42 PM
  Steve Schaneville
149 posts


Re: SQL Server Management Studio Express Edition problem 

You are right that SQL Prompt uses system-wide hooks to inject its intellisense into SSMSEE.  SqlAssist is not designed around hooks, but rather, works as a native Visual Studio addin (SSMS is built on the Visual Studio codebase).  Unfortunately SSMSEE does not support the addin interface (this is not technically true, but is stated as such in the Microsoft's SSMSEE license agreement).  So I cannot make SqlAssist work as an addin in that app.  Sorry about that. 

Yes, I'll add the note to the download page.  Thanks for the suggestion.

~Steve

 
Previous Previous
 
Next Next
  Forum  SqlAssist for S...  Bugs and Misbeh...  SQL Server Management Studio Express Edition problem
Syndicate   Print  

Old Forums Still Available  Minimize 

The Forums module was upgraded a while back.  Unfortunately it was not possible to move the old content into the new module.  You can still access the old forums by following this link.  You can no longer post in those forums however.

Print