Add-in for SQL Server Mnagement Studio 2005

Hi,
I notice that a few third party SQL Server tool developers (RedGate
for example) have started to sell utilities that appear as add-ins
to
SQL Server Management Studio 2005 (with additional menu's and
dialogs).
I cant find any documentation on how you do this. Is it an
unsupported hack ? If so, can anyone point me in the right direction
on how I would work out how to do this.
(Sorry for the cross post, I posted the same message in
microsoft.public.sqlserver.server by mistake).
Thanks in advance,
Matt
Asked and answered in .server. Please refrain from multiposting.

Adam Machanic
SQL Server MVP - http://sqlblog.com
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
<matt_randle@.yahoo.com> wrote in message
news:1183902073.740953.145580@.22g2000hsm.googlegro ups.com...
> Hi,
> I notice that a few third party SQL Server tool developers (RedGate
> for example) have started to sell utilities that appear as add-ins
> to
> SQL Server Management Studio 2005 (with additional menu's and
> dialogs).
>
> I cant find any documentation on how you do this. Is it an
> unsupported hack ? If so, can anyone point me in the right direction
> on how I would work out how to do this.
> (Sorry for the cross post, I posted the same message in
> microsoft.public.sqlserver.server by mistake).
> Thanks in advance,
>
> Matt
>
|||Adam Machanic (amachanic@.IHATESPAMgmail.com) writes:
> Asked and answered in .server. Please refrain from multiposting.
Hey, he did after all say:
[vbcol=seagreen]
And this groups is certainly the appropriate one for the topic.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||Ok. Thanks for your reply (in the other group). If I can work out
how to do it, ill put up a blog post explaining it. I notice that it
will be a supported feature in the next release of SSMS though so may
just wait for that.
Thanks.
On 8 Jul, 16:09, "Adam Machanic" <amacha...@.IHATESPAMgmail.com> wrote:
> Asked and answered in .server. Please refrain from multiposting.
> --
> Adam Machanic
> SQL Server MVP -http://sqlblog.com
> Author, "Expert SQL Server 2005 Development"http://www.apress.com/book/bookDisplay.html?bID=10220
> <matt_ran...@.yahoo.com> wrote in message
> news:1183902073.740953.145580@.22g2000hsm.googlegro ups.com...
>

Add User to SQL Server Express?

Ok, I need to add aspnet user to my database in SQL Server express. I have the SQL Server Mangament Tool Express CTP that i am using to do it.
Anyway when i go to add the permissions for my user to the table I type it in and it returns back that there is no user that exists with that name. I then went to the top level for SQL Server Express and it has the ASPNET user. I don't understand why the engine itself can see it and use it but not my individual database.
The quick answer is there are two permissions to a SQL Server database the server permissions created under the sercurity section and the database permissions I think you have created the database permissions not the server permissions. try the link below download the eval version and install it as a named instance and use the full management studio to create the server permissions in the Express edition. hope this helps.
http://www.microsoft.com/sql/downloads/trial-software.mspx|||So basically install SQL Server again? along with the Managment tools? Is there anyway to install just the managment tools?
|||Ok, I got the Managment tools installed. Took a bit dang thing kept wanting to install SQL Server trial.
Anyway, I am still running into the same problem. I can't seem to add the ASPNET user to the database itself. It is added the server permissions and to the sample databases, but I must be missing something somewhere because for the life of me can't figure out how to add the user to the database.
|||

I think you should install the full eval version because I just checked mine the database login is in security section inside the database and the server login is in the old SQL Server 2000 security section. The installation is completely automated after you choose the components to install the installer will do everything for you so I think you should install it. Hope this helps.

|||Thank you for your help that last post helped a lot. I feel stupid now lol.
I didn't even think to go to the security folder to add a new user. I was just right clicking on the database folder and going to permissions. It think this will be one thing i won't forget.
Thanks for the help. If these forums had a rep system I would definatly be giving you some. this little problem has stopped my development all day long.
|||I am glad I could help.

Add Reference to Excel in Scripting tool in SSIS 2005

How can I add a reference to the Microsoft excel 2003 in the script tool in SSIS 2005? I need to automate Excel for formatting.

Thank you.

Dan

Adding refereneces to external assembleis is documented in Books Online -

Referencing Other Assemblies in Scripting Solutions

http://technet.microsoft.com/en-us/library/ms136007.aspx

For Office applications like Excel that are COM, you will need to download the PIAs if you have not already.You will need to reference the PIA.

Download - http://www.microsoft.com/downloads/details.aspx?FamilyID=3C9A983A-AC14-4125-8BA0-D36D67E0F4AD&displaylang=en

General page of on PIAs if you are not familar already - http://msdn2.microsoft.com/en-us/library/aax7sdch.aspx

Add a print button on to Reportviewer of srs

Hi,
I have generated reports using SQL server reporting services 2000. I need to
put a print button in the report tool bar which will prints the content
displayed in the report(only the report content). Can any body tell me how to
enable the print option in the tool bar of repotviewer.
Thanks in advance
AjayAjay,
To my knowledge, you need to export to PDF, then print from acrobat reader.
Ask for a second opinion though...
--
TIM ELLISON
"Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
news:8517AE77-6E2F-4F29-AB37-93FEEEA5C173@.microsoft.com...
> Hi,
> I have generated reports using SQL server reporting services 2000. I need
to
> put a print button in the report tool bar which will prints the content
> displayed in the report(only the report content). Can any body tell me how
to
> enable the print option in the tool bar of repotviewer.
> Thanks in advance
> Ajay
>|||Ajay,
It is simple ... you can't :-(
However, if you are willing to hold you breath a couple of months, Service
Pack 2 will come with a print control and you will have the much coveted
print button.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
news:8517AE77-6E2F-4F29-AB37-93FEEEA5C173@.microsoft.com...
> Hi,
> I have generated reports using SQL server reporting services 2000. I need
> to
> put a print button in the report tool bar which will prints the content
> displayed in the report(only the report content). Can any body tell me how
> to
> enable the print option in the tool bar of repotviewer.
> Thanks in advance
> Ajay
>|||When Service Pack 2 will be released ? Is it before SQL Server 2005 ?
Thanks
"Teo Lachev [MVP]" wrote:
> Ajay,
> It is simple ... you can't :-(
> However, if you are willing to hold you breath a couple of months, Service
> Pack 2 will come with a print control and you will have the much coveted
> print button.
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/|||The last think I heard is that it will be slated to January - February
timeframe.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Keenz" <Keenz@.discussions.microsoft.com> wrote in message
news:E60EFA77-809F-476B-BE01-FD58778ABF05@.microsoft.com...
> When Service Pack 2 will be released ? Is it before SQL Server 2005 ?
> Thanks
> "Teo Lachev [MVP]" wrote:
>> Ajay,
>> It is simple ... you can't :-(
>> However, if you are willing to hold you breath a couple of months,
>> Service
>> Pack 2 will come with a print control and you will have the much coveted
>> print button.
>> --
>> Hope this helps.
>> ---
>> Teo Lachev, MVP [SQL Server], MCSD, MCT
>> Author: "Microsoft Reporting Services in Action"
>> Publisher website: http://www.manning.com/lachev
>> Buy it from Amazon.com: http://shrinkster.com/eq
>> Home page and blog: http://www.prologika.com/|||Has the new service pack release for print option in the report veiwer .
Please need the information urgently.
Thanks
Ajay kumar
"Ajay Kumar" wrote:
> Hi,
> I have generated reports using SQL server reporting services 2000. I need to
> put a print button in the report tool bar which will prints the content
> displayed in the report(only the report content). Can any body tell me how to
> enable the print option in the tool bar of repotviewer.
> Thanks in advance
> Ajay
>|||SP2 will contain a new print button on the tool bar. We are currently in
beta.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
news:69CE9B88-19EC-455F-8B51-4668360B8C21@.microsoft.com...
> Has the new service pack release for print option in the report veiwer .
> Please need the information urgently.
> Thanks
> Ajay kumar
> "Ajay Kumar" wrote:
>> Hi,
>> I have generated reports using SQL server reporting services 2000. I need
>> to
>> put a print button in the report tool bar which will prints the content
>> displayed in the report(only the report content). Can any body tell me
>> how to
>> enable the print option in the tool bar of repotviewer.
>> Thanks in advance
>> Ajay|||Any news from service pack 2 ?
Greetz
"Daniel Reib [MSFT]" wrote:
> SP2 will contain a new print button on the tool bar. We are currently in
> beta.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
> news:69CE9B88-19EC-455F-8B51-4668360B8C21@.microsoft.com...
> >
> > Has the new service pack release for print option in the report veiwer .
> >
> > Please need the information urgently.
> >
> > Thanks
> > Ajay kumar
> >
> > "Ajay Kumar" wrote:
> >
> >> Hi,
> >>
> >> I have generated reports using SQL server reporting services 2000. I need
> >> to
> >> put a print button in the report tool bar which will prints the content
> >> displayed in the report(only the report content). Can any body tell me
> >> how to
> >> enable the print option in the tool bar of repotviewer.
> >>
> >> Thanks in advance
> >>
> >> Ajay
> >>
>
>|||Not sure what you are asking. SP2 was released last week.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Koen" <Koen@.discussions.microsoft.com> wrote in message
news:6D56A681-91A3-4E37-8910-E63F38D321DF@.microsoft.com...
> Any news from service pack 2 ?
> Greetz
> "Daniel Reib [MSFT]" wrote:
>> SP2 will contain a new print button on the tool bar. We are currently in
>> beta.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Ajay Kumar" <AjayKumar@.discussions.microsoft.com> wrote in message
>> news:69CE9B88-19EC-455F-8B51-4668360B8C21@.microsoft.com...
>> >
>> > Has the new service pack release for print option in the report veiwer
>> > .
>> >
>> > Please need the information urgently.
>> >
>> > Thanks
>> > Ajay kumar
>> >
>> > "Ajay Kumar" wrote:
>> >
>> >> Hi,
>> >>
>> >> I have generated reports using SQL server reporting services 2000. I
>> >> need
>> >> to
>> >> put a print button in the report tool bar which will prints the
>> >> content
>> >> displayed in the report(only the report content). Can any body tell me
>> >> how to
>> >> enable the print option in the tool bar of repotviewer.
>> >>
>> >> Thanks in advance
>> >>
>> >> Ajay
>> >>
>>

Ad hoc reporting for sql server

Hi,
I am looking for a software or a reporting tool for end user to general ad
hoc reports. the backend is sql server.
Does anyone know what is the best reporting software for end users out there
in the market?
Thanks
Henry
I have limited experience of the competition but SQL Server Reporting
Services certainly fits the spec. You can define a report model which the
users use as a basis (sort of 'Universe') and the web Reports Manager allows
them to use Report Builder locally to create and then upload ad-hoc reports.
I looked at this myself but then ultimately decided that this would be too
much of a maintenance headache, so we decided to use change requests to be
sent to the database developers to create and manage the reports centrally
instead.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Thanks,
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OwnlnBSUHHA.4844@.TK2MSFTNGP03.phx.gbl...
>I have limited experience of the competition but SQL Server Reporting
>Services certainly fits the spec. You can define a report model which the
>users use as a basis (sort of 'Universe') and the web Reports Manager
>allows them to use Report Builder locally to create and then upload ad-hoc
>reports. I looked at this myself but then ultimately decided that this
>would be too much of a maintenance headache, so we decided to use change
>requests to be sent to the database developers to create and manage the
>reports centrally instead.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>

Ad hoc reporting for sql server

Hi,
I am looking for a software or a reporting tool for end user to general ad
hoc reports. the backend is sql server.
Does anyone know what is the best reporting software for end users out there
in the market?
Thanks
HenryI have limited experience of the competition but SQL Server Reporting
Services certainly fits the spec. You can define a report model which the
users use as a basis (sort of 'Universe') and the web Reports Manager allows
them to use Report Builder locally to create and then upload ad-hoc reports.
I looked at this myself but then ultimately decided that this would be too
much of a maintenance headache, so we decided to use change requests to be
sent to the database developers to create and manage the reports centrally
instead.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Thanks,
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OwnlnBSUHHA.4844@.TK2MSFTNGP03.phx.gbl...
>I have limited experience of the competition but SQL Server Reporting
>Services certainly fits the spec. You can define a report model which the
>users use as a basis (sort of 'Universe') and the web Reports Manager
>allows them to use Report Builder locally to create and then upload ad-hoc
>reports. I looked at this myself but then ultimately decided that this
>would be too much of a maintenance headache, so we decided to use change
>requests to be sent to the database developers to create and manage the
>reports centrally instead.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>

Ad hoc reporting for sql server

Hi,
I am looking for a software or a reporting tool for end user to general ad
hoc reports. the backend is sql server.
Does anyone know what is the best reporting software for end users out there
in the market?
Thanks
HenryI have limited experience of the competition but SQL Server Reporting
Services certainly fits the spec. You can define a report model which the
users use as a basis (sort of 'Universe') and the web Reports Manager allows
them to use Report Builder locally to create and then upload ad-hoc reports.
I looked at this myself but then ultimately decided that this would be too
much of a maintenance headache, so we decided to use change requests to be
sent to the database developers to create and manage the reports centrally
instead.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Thanks,
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OwnlnBSUHHA.4844@.TK2MSFTNGP03.phx.gbl...
>I have limited experience of the competition but SQL Server Reporting
>Services certainly fits the spec. You can define a report model which the
>users use as a basis (sort of 'Universe') and the web Reports Manager
>allows them to use Report Builder locally to create and then upload ad-hoc
>reports. I looked at this myself but then ultimately decided that this
>would be too much of a maintenance headache, so we decided to use change
>requests to be sent to the database developers to create and manage the
>reports centrally instead.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>