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/jonsay...dio-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

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"CJM" <cjmUK (AT) newsgroup (DOT) nospam> wrote

Tibor Karaszi wrote:
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

"CJM" <cjmUK (AT) newsgroup (DOT) nospam> wrote

See
http://connect.microsoft.com/SQLServ...dbackID=265567
and vote for it!

You may also want to look at
http://aspalliance.com/1374_Extend_F...io_with_Addins

and the tool pack http://www.ssmstoolspack.com/Main.aspx

John

John Bell wrote:
Done.

Thanks - I'll take a look at this shortly.

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

"CJM" <cjmUK (AT) newsgroup (DOT) nospam> wrote

You could have checked the link properties on a SQL 2008 client machine!!!

John

CJM (cjmUK (AT) newsgroup (DOT) nospam) writes:
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.




--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx

John Bell wrote:
There seemed to be no need; I'd read that they were different programs,
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.

Erland Sommarskog wrote:
So it has transpired. But annoyingly, there are still plenty of
references to SQL Workbench in SQL 2008, even of the executable has
changed name.

These should be bugged... can you elaborate?