|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SSMS 2008 Add-ons: What is the 2008 replacement for SQLWB.EXE?going to pass a parameter from SQL 2008 to a console application. Although Add-Ons are not specifically supported, according to these articles [1], [2], it is possible in 2005 and I'm assuming also in 2008. However, I've fallen almost at the first hurdle; I can't seem to find SQLWB.EXE (SQL WorkBench) in the expected place. I'm assuming that this file has been replaced in 2008, but I can't seem to pin down the equivalent version. Has anyone any experience in general in developing 2008 Add-ons? Any good resources? And can anyone indicate the 2008 replacement for SQLWB.EXE? [1] http://sqlblogcasts.com/blogs/jonsayce/archive/2008/01/15/building-a-sql-server-management-studio-addin.aspx [2] http://jcooney.net/archive/2007/11/26/55358.aspx I have no ideas about addins, but the name of SSMS in 2008 is SSMS.EXE
-- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "CJM" <cjmUK@newsgroup.nospam> wrote in message news:OHx12T90JHA.140@TK2MSFTNGP03.phx.gbl... > I'm trying to create a simple Add-On for SQL Server 2008; it is simply going to pass a parameter > from SQL 2008 to a console application. > > Although Add-Ons are not specifically supported, according to these articles [1], [2], it is > possible in 2005 and I'm assuming also in 2008. However, I've fallen almost at the first hurdle; I > can't seem to find SQLWB.EXE (SQL WorkBench) in the expected place. I'm assuming that this file > has been replaced in 2008, but I can't seem to pin down the equivalent version. > > Has anyone any experience in general in developing 2008 Add-ons? Any good resources? > > And can anyone indicate the 2008 replacement for SQLWB.EXE? > > [1] > http://sqlblogcasts.com/blogs/jonsayce/archive/2008/01/15/building-a-sql-server-management-studio-addin.aspx > > [2] http://jcooney.net/archive/2007/11/26/55358.aspx Tibor Karaszi wrote:
> I have no ideas about addins, but the name of SSMS in 2008 is SSMS.EXE Timor,> I was under the impression (from where I can't recall) that SQLWB.EXE and SSMS.exe were different applications, but it seems you might be right - that SSMS.EXE is the file I've been after all a long! Oops - another unnecessary delay! Let's see if this thing works... Thanks Chris
Show quote
Hide quote
"CJM" <cjmUK@newsgroup.nospam> wrote in message You could have checked the link properties on a SQL 2008 client machine!!!news:uUQlRs90JHA.1432@TK2MSFTNGP02.phx.gbl... > Tibor Karaszi wrote: >> I have no ideas about addins, but the name of SSMS in 2008 is SSMS.EXE >> > > Timor, > > I was under the impression (from where I can't recall) that SQLWB.EXE and > SSMS.exe were different applications, but it seems you might be right - > that SSMS.EXE is the file I've been after all a long! > > Oops - another unnecessary delay! > > Let's see if this thing works... > > Thanks > > Chris > John John Bell wrote:
> There seemed to be no need; I'd read that they were different programs, > > You could have checked the link properties on a SQL 2008 client machine!!! > and this was re-inforced with a response to a query elsewhere. I'd been told that there was an SSMS.EXE and an SQLWB.EXE in 2005, thus clearly the 2008 version of SSMS.EXE couldn't be what I was looking for. However, that initial information has been proved wrong (once I'd got my hands on a 2005 installation to check), and the situation has become clear. However, the error wasn't a result of laziness; the internets is full of interesting information but not all of it is correct. CJM (cjmUK@newsgroup.nospam) writes:
> I was under the impression (from where I can't recall) that SQLWB.EXE Just a little piece of history: the reason the SSMS executable was> and SSMS.exe were different applications, but it seems you might be > right - that SSMS.EXE is the file I've been after all a long! called SQLWB in SQL 2005 is that it was originally named SQL Workbench. The name was changed somewhere in the beta process of SQL 2005. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx Erland Sommarskog wrote:
> So it has transpired. But annoyingly, there are still plenty of > Just a little piece of history: the reason the SSMS executable was > called SQLWB in SQL 2005 is that it was originally named SQL Workbench. > The name was changed somewhere in the beta process of SQL 2005. > references to SQL Workbench in SQL 2008, even of the executable has changed name. > So it has transpired. But annoyingly, there are still plenty of These should be bugged... can you elaborate?> references to SQL Workbench in SQL 2008, Aaron Bertrand [SQL Server MVP] wrote:
>> So it has transpired. But annoyingly, there are still plenty of I understand that parts of the object model need to for building add-ins >> references to SQL Workbench in SQL 2008, > > These should be bugged... can you elaborate? > still refer to SQL Workbench, but you probably overlook these because it's truly under the bonnet. But in the folder where we found SSMS.EXE (C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE) we have: \SqlWorkbenchProjectItems\ \SqlWorkbenchProjects\ SqlWorkbench.Interfaces.dll SqlWorkbenchProject.dll Yes names of DLLs are not going to change, as they really are under the hood
as you suggest, and would represent very possible breaking changes for little to no benefit whatsoever. There are similar things that have happened with Policy-Based Management, originally it was called Dynamic Management Framework, and there are all kinds of class libraries with DMF in their names. A On 5/14/09 10:57 AM, in article #SLWTRK1JHA.1***@TK2MSFTNGP02.phx.gbl, "CJM" <cjmUK@newsgroup.nospam> wrote: Show quoteHide quote > Aaron Bertrand [SQL Server MVP] wrote: >>> So it has transpired. But annoyingly, there are still plenty of >>> references to SQL Workbench in SQL 2008, >> >> These should be bugged... can you elaborate? >> > > I understand that parts of the object model need to for building add-ins > still refer to SQL Workbench, but you probably overlook these because > it's truly under the bonnet. > > But in the folder where we found SSMS.EXE (C:\Program Files > (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE) we have: > > \SqlWorkbenchProjectItems\ > \SqlWorkbenchProjects\ > SqlWorkbench.Interfaces.dll > SqlWorkbenchProject.dll
Show quote
Hide quote
"CJM" <cjmUK@newsgroup.nospam> wrote in message See news:OHx12T90JHA.140@TK2MSFTNGP03.phx.gbl... > I'm trying to create a simple Add-On for SQL Server 2008; it is simply > going to pass a parameter from SQL 2008 to a console application. > > Although Add-Ons are not specifically supported, according to these > articles [1], [2], it is possible in 2005 and I'm assuming also in 2008. > However, I've fallen almost at the first hurdle; I can't seem to find > SQLWB.EXE (SQL WorkBench) in the expected place. I'm assuming that this > file has been replaced in 2008, but I can't seem to pin down the > equivalent version. > > Has anyone any experience in general in developing 2008 Add-ons? Any good > resources? > > And can anyone indicate the 2008 replacement for SQLWB.EXE? > > [1] > http://sqlblogcasts.com/blogs/jonsayce/archive/2008/01/15/building-a-sql-server-management-studio-addin.aspx > > [2] http://jcooney.net/archive/2007/11/26/55358.aspx http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=265567 and vote for it! You may also want to look at http://aspalliance.com/1374_Extend_Functionality_in_SQL_Server_2005_Management_Studio_with_Addins and the tool pack http://www.ssmstoolspack.com/Main.aspx John John Bell wrote:
> Done.> > See > http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=265567 > and vote for it! > > You may also want to look at Thanks - I'll take a look at this shortly.> http://aspalliance.com/1374_Extend_Functionality_in_SQL_Server_2005_Management_Studio_with_Addins > Yeah, just discovered these a short while ago. I probably haven't managed to use half of it yet! I also considered harassing the developer if I get stuck! :) Thanks Chris  
Other interesting topics
Move SQL2008 Express to another machine
Cannot find a GUI to execute a query execute long sql script saving SQL files in SSMS as ASCII ODBC Drivers 64-Bit Maintenance Plan Fails sql server balnk date SQL Server Profiler and Prepared Queries Database diagrams in ss2008 Generating script to individual files |
|||||||||||||||||||||||
