.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Writing a VB.NET extensibility project as a SSMS 2008 R2 add-in

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server


I am trying to write an add-in into the SSMS 2008 R2 IDE.  I believe it is possible, though maybe not fully supported by Microsoft. 
I have created a new project in Visual Studio 2010 of type Extensibility - Visual Studio Add-in.  This has created my project and all of the relevant code to get the add-in loaded onto the Tools menu.  THe only line of code I have added is inot the OnConnection method to display a messagebox so I know it has at least loaded.

When I build this as is, it will load as an Add-in into VS 2010 onto the Tools menu - which is fine - at least part is working.  But when I try to add this as an Add-in into SSMS 2008 it keeps giving me the error message:
The Add-in 'DataFollower.Connect' failed to load or cause an exception.  Would you like to remove this add-in? ... Error Message: Class not registered  Error number: 80040154
To get this add-in registerd in SSMS I followed the methods found using google searches.  And loaded into the registry :

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Shell\Addins\DataFollower.Connect]

View Complete Post

More Related Resource Links

is it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site p


is it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site project


my current project references




i have a very annoying iis problem

iis server stops working until app pool is recycled


i am hoping that new visual studio (net framework 4.0) may solve this very annoying unsolveable problem


Business Intelligence Reports Project in Visual studio 2008 ?



I wonder how to add a project template called  Intelligence Reports, something like that, to Visual studio 2008. I have SQL 2008 installed. Do I need to install some updates to get Intelligence Reports template to Visual studio 2008 ?

Thank you..

VS 2008 Web Application Project


Hi, I am working on a VS time clock project to be used for student's to clock in and out. When the student clocks in the time/date is saved to a temp table. Upon login out to the login screen for the next user to use I need to save the clocked in time to a permanate table. It is an update from the temp table to the permanate table. However, when the page redirects to the login page, I recieve the dbnull to date is invalid error. Now understand, when the page is redirecting to the login page for the next user, the only way I could figure out to get the browser to forget the sessionstate, was to use a delete statement that removes the data from the perm table, but before it erases it, I need to save it to the permanate database table.


Anyone have a solution they can send my way??


Thanks :) 

Visual Studio Web Deployment Project for VS 2008


What is the latest version of Visual Studio web deployment project which I can use with  VS 2008 ?

Can I use VS 2010 Web Deployment Project with  VS 2008 ?


Problems converting VS 2003 project to VS 2008



I'm having problems converting a VS 2003 project to VS 2008 (tried 2005 as well, same problem). There are several problems;
a) I don't have VS 2003 installed.
b) The project is a web service, however I'm not sure what type of VS project it was created as.
c) The general knowledge about the project setup is..slim.

I get a error message using the conversion wizard, however, I'm not familiar with the tool and I cannot quite find any good information on Google for it, so I am left with a error message I do not understand.

Conversion Issues - myProject.csproj:
Unable to open the Web site 'C:\local\path\to\project\myProject.csproj'. The Web site 'C:\local\path\to\project\myProject.csproj' does not exist.

The web service is not intended to run on the dev machine, it is copied to a test or a prod server. However, I do not know how this was done previously. I'm thinking that in order to convert, it has to access the server on which it should run (which is set somehow in a config maybe). But that doesn't actually make any sence..

If anyone could shed light on this, I would really appreciate it.

Thank you.

Copy/paste broken in SSMS 2008 R2

After uninstalling an SSMS addin (from Red Gate), my copy/paste functionality in SSMS broke -- don't know if it's correlated.  As documented in the bug https://connect.microsoft.com/SQLServer/feedback/details/126743/copy-paste-stop-working-in-sql-2005 it seems that paste is working fine, because it works when I copy from other programs.  When I paste from SSMS, though, I can't paste anywhere.  It's as though SSMS clears the clipboard and that's all she wrote. Anyone else seeing this problem? -matthew

SQL 2008 R2 (final): SSMS freezes: "Failed to retrieve data for this request.

The original thread is locked for some reason--but the cause of the bug had something to do with the "ssms tools pack" add-in, which, according to the comments in the connect item, will be fixed in an update of ssms tools: http://social.msdn.microsoft.com/Forums/en-US/sqlkjdatabaseengine/thread/f65737b7-fe4d-487b-aa41-ef437d100bc7 https://connect.microsoft.com/SQLServer/feedback/details/556169/ssms-completely-locked-up-after-right-clicking-a-table  

SSMS Project templates

I am using SQL2008R2. From SSMS when I try to create a new project three template choices are shown. SQL Server Scripts, Analysis Services Scripts and SQL Server Compact Edition Scripts. Regardless of which one I pick the solution explorer window is empty and there is no apparent way to add anything to it? I suspect the templates are messed up. How can I replace what is there with ones that work? Thanks.Tom

How can I access Command Window in SSMS 2008

Hello, I'm debugging some t-sql code, I can view locals, watches etc. but I've closed command window by mistake and i couldn't find it again. Is there a shortcut key for this window? How I can access this window? Thanks in advance.

SSMS 2008 - Shows Service Status as Stopped Though Service is started

Hi, I have a SQL Server 2008 - Active/Passive Cluster. The issue I am facing here is that, when I do a Failover from Node A to Node B, All the Cluster Services come online and the SQL Services are running (checked using the SQL Configuration Manager and Services console). However when I open the management studio, The Service status Indicator shows a Red Block mark against the ServerName and the SQL Server Agent. When I try connecting to the server remotely from another server, the status is displayed correctly in the SSMS(i.e the green sign with the arrow) .  This issue happens when I locally login to the server and connect using ssms. I am an Admin on both the boxes and even the service account with which the services run also has admin privileges. Any pointers? Thanks,

SSMS 2008 & Activity Monitor's Processor Time graph is disabled

Hi,I just upgraded one of my SQL 2005 clusters to SQL 2008 with CU9.  Now, when I connect to it with SSMS, either from my workstation or directly on a cluster node, the % Processor Time graph in the Activity Monitor screen is disabled.  The other three graphs are fine.  If I connect to a different SQL 2008 server, the % Processor Graph is fine.  I don't see any errors in any app event log.  Has anyone else seen this behavior?Thanks!

SSMS 2008 Activity Monitor Activity Monitor is unable to execute queries against server (SQL Server

I get the following error when running SQL Server SSMS 2008 (32-bit) on my (Windows 7 64-bit) workstation against our SQL Server 2005 (32-bit) development server running Windows Server 2003 (32-bit): TITLE: Microsoft SQL Server Management Studio ------------------------------ The Activity Monitor is unable to execute queries against server <my server\instance name>. Activity Monitor for this instance will be placed into a paused state. Use the context menu in the overview pane to resume the Activity Monitor. ------------------------------ ADDITIONAL INFORMATION: Unable to find SQL Server process ID 2256 on server VTX-DEV-01 (Microsoft.SqlServer.Management.ResourceMonitoring)   I can expand the panes and all display data except Overview and Data File I/O. This is true for all instances on that server. The SSMS 2005 Activity Monitor (also on my workstation) works fine when connected to that server. I checked for the registry setting to disable the performance counters on both my machine and the server, and it was not there. I started the Performance Counter DLL Host on my machine, but that made no difference. I can see all Processor counters on the server from my local Performance Monitor. I ran "lodctr /R" on both systems, but that didn't help. The only SQL counters I see on the server (from my workstation) are SQLServer:SSIS Pipeline and SQLServer:SSIS

Missing Database Node using SSMS 2008 Express

Hello,It works perfectly the first time I install SSMS 2008 Express and I can access my remote database. But, after I restart my machine and open an instance of SSMS the database node is missing.Before:After: I tried refreshing the database folder but still nothing. I even uninstall but it's still the same.Thank You for your help,-imperialx

Visual Studio 2008 Asp.net Development Server Launches When use local IIS is project option

I have a visual studio 2008 asp.net MVC webapp project.  The project is set to use local IIS WebServer. When I run without debugging, it runs just fine.  However when i run with debugging Visual studio launches the Asp.net Development Server on top of IIS.  I would not care if it wasnt for the fact that any time i make a web request to the MVC Site it seems to be creating duplicate requests resulting in a very painful debugging experience.Thanks,Giovanni

Relate table using SSMS 2008 Express

Hello,How to add relationship between tables using SSMS 2008 Express?Thank You,-imperialx

Missing Database Node in SSMS 2008 Express

Hello, It works perfectly the first time I install SSMS 2008 Express and I can access my remote database. But, after I restart my machine and open an instance of SSMS and login back, the database node is missing. I have asked this question over at asp.net forums with images (http://forums.asp.net/t/1600718.aspx).   Thanks, -imperialx

Database diagram failur - Invalid class string SSMS 2008

Hi There -  Help needed In SSMS 2008 (not express) the Database Diagram  cast the exeption "Invalid Class String" (MS Visual Database Tools). Why is this happening. I have used the diagram designer before succesfully My OS W7 - SqlServer 2008 - every thing updated  - every service pack installed I have tryed reinstall seceral times - not positiv What is going on - It had been working (1 month ago) Please help Freddy
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend