Showing posts with label studio. Show all posts
Showing posts with label studio. Show all posts

Tuesday, March 27, 2012

Customize SQL Server Management Studio (or Express)?

Is there any way to customize the SSMS or Express? SSMS seems to have the same codebase as Visual Studio, so would the Visual Studio SDK work?

Curtis

I recently answered this question in another post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1530544&SiteID=1

Long story short: we don't support or recommend 3rd party extensions to Management Studio. We do use the Visual Studio shell, so you might technically be able to add menu items, but we are free to change our extensions in SPs and major releases and this could break your extensions.

Paul A. Mestemaker II

Program Manager

Microsoft SQL Server Manageability

http://blogs.msdn.com/sqlrem/

Customize SQL Server Management Studio (or Express)?

Is there any way to customize the SSMS or Express? SSMS seems to have the same codebase as Visual Studio, so would the Visual Studio SDK work?

Curtis

I recently answered this question in another post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1530544&SiteID=1

Long story short: we don't support or recommend 3rd party extensions to Management Studio. We do use the Visual Studio shell, so you might technically be able to add menu items, but we are free to change our extensions in SPs and major releases and this could break your extensions.

Paul A. Mestemaker II

Program Manager

Microsoft SQL Server Manageability

http://blogs.msdn.com/sqlrem/

Thursday, March 22, 2012

custom summary reports in mgmt studio

Is it possible to create custom summary reports and run them in management studio? I am assuming these reports are RS reports.

thanks,

Derek

Is it possible to create custom summary reports and run them in management studio?

Doubt if there is such feature.

I am assuming these reports are RS reports

SSMS installation doesn't require RS installation, so probably it's wrong assumption.

|||

This is not possible. Though this is something we're investigating for SP2. I suggest you vote on the following item in the Product Feedback Center: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=fb83d75b-424a-4c72-a735-30692a077e57

Cheers,
Dan

Monday, March 19, 2012

Custom reports from SQL 2000

What would I need to create custom reports from SQL 2000 reporting services?
I was told I would need Visual Studio to create the reports. It would be
nice to do some ad hoc reporting without having to go to our developer each
time we want to create a new report.RS 2005 has an end user reporting solution as well as the report designer
which exists in RS 2000.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rockn" <Rockn@.newsgroups.nospam> wrote in message
news:ebCEtnANHHA.4244@.TK2MSFTNGP04.phx.gbl...
> What would I need to create custom reports from SQL 2000 reporting
> services? I was told I would need Visual Studio to create the reports. It
> would be nice to do some ad hoc reporting without having to go to our
> developer each time we want to create a new report.
>|||I believe this would only let you set the parameters for the report not the
content or type of report.
I would like to create completely custom reports. If VS2003 is the only way
to do it without upgrading to SQL 2005 we may have to go that route.
We have the media for SQL 2005 and isn't there some client side report
writer you could use in conjunction with the SQL 2000 data base we are
currently using for production?
"Paul.G." <PaulG@.discussions.microsoft.com> wrote in message
news:3E8832DC-C2F9-402B-B64D-3AD4B0EF748F@.microsoft.com...
> reports in Reporting services 2000 are created only in visual studio
> 2003.
> But as the reports are plain XML document, then your developper team can
> create a module for you that interacts with your database and let you
> create
> reports on the FLY. That means an application created by your team that
> let
> you create reports that you need.
> BUT this approche takes a gr8 deal of developpemnt, time, and resources.
> What I suggess is to define your needs and go to your developper team.
> "Rockn" wrote:
>> What would I need to create custom reports from SQL 2000 reporting
>> services?
>> I was told I would need Visual Studio to create the reports. It would be
>> nice to do some ad hoc reporting without having to go to our developer
>> each
>> time we want to create a new report.
>>|||Hello Rockn,
My understanding is that: You want konw is it possible that SQL 2005
Reporting service use the SQL 2000 database as the datasource.
My answer is yes. You could use the SQL 2000 database as the datasource of
the SQL 2005 reporting services.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi,
Just want to say Hi, and I was wondering how everything is going. If
anything is unclear, please let me know. It is my pleasure to be of
assistance.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
=====================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

Tuesday, February 14, 2012

Custom API Development in SQL Server 2005

Hello,

In Visual Studio 2005, you can create custom add-ins that work in that environment, to add additional features that are useful to the developer/analyst. Can you do that with SQL Server? Can you create a custom add-in, and does anyone know of a good resource?

Thanks.

This has been answered in a couple of other posts:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1530544&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1541276&SiteID=1

Paul A. Mestemaker II

Program Manager

Microsoft SQL Server Manageability

http://blogs.msdn.com/sqlrem/

Custom API Development in SQL Server 2005

Hello,

In Visual Studio 2005, you can create custom add-ins that work in that environment, to add additional features that are useful to the developer/analyst. Can you do that with SQL Server? Can you create a custom add-in, and does anyone know of a good resource?

Thanks.

This has been answered in a couple of other posts:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1530544&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1541276&SiteID=1

Paul A. Mestemaker II

Program Manager

Microsoft SQL Server Manageability

http://blogs.msdn.com/sqlrem/