Programming Tool

I wasn't really sure where to post my question, so if I'm off-topic,
could you please refer me to a more appropriate newsgroup?
I'm quite new to MS SQL Server 2000 stored procedures development and
I'm finding the Enterprise Manager to be quite difficult and cumbersome
to work with. I'm looking for an editor with a common programming IDE
look and feel.
Can anybody please recommend me a good alternative?
Thank you,
Seanvisual studio .net allows T-SQL editing and debugging.
Greg Jackson
Portland, OR|||Hello Sean,
Try TOAD for SQL Server (www.toadss.com). A new version will be out in the
summer time...
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support PASS, the Professional Association for SQL Server. ([url]www.sqlpass.org[/url
])

> I wasn't really sure where to post my question, so if I'm off-topic,
> could you please refer me to a more appropriate newsgroup?
> I'm quite new to MS SQL Server 2000 stored procedures development and
> I'm finding the Enterprise Manager to be quite difficult and
> cumbersome to work with. I'm looking for an editor with a common
> programming IDE look and feel.
> Can anybody please recommend me a good alternative?
> Thank you,
>|||You can use Access - create a project (adp file)
"Fao, Sean" <enceladus311@.yahoo.comI-WANT-NO-SPAM> wrote in message
news:uv9ly1WLFHA.3420@.tk2msftngp13.phx.gbl...
>I wasn't really sure where to post my question, so if I'm off-topic,
> could you please refer me to a more appropriate newsgroup?
> I'm quite new to MS SQL Server 2000 stored procedures development and
> I'm finding the Enterprise Manager to be quite difficult and cumbersome
> to work with. I'm looking for an editor with a common programming IDE
> look and feel.
> Can anybody please recommend me a good alternative?
> Thank you,
> --
> Sean|||Query Analyzer.
Save your stored procedure creation scripts to files and check them in to
your favorite version control software.
Keith
"Fao, Sean" <enceladus311@.yahoo.comI-WANT-NO-SPAM> wrote in message
news:uv9ly1WLFHA.3420@.tk2msftngp13.phx.gbl...
> I wasn't really sure where to post my question, so if I'm off-topic,
> could you please refer me to a more appropriate newsgroup?
> I'm quite new to MS SQL Server 2000 stored procedures development and
> I'm finding the Enterprise Manager to be quite difficult and cumbersome
> to work with. I'm looking for an editor with a common programming IDE
> look and feel.
> Can anybody please recommend me a good alternative?
> Thank you,
> --
> Sean|||
> I wasn't really sure where to post my question, so if I'm off-topic,
> could you please refer me to a more appropriate newsgroup?
> I'm quite new to MS SQL Server 2000 stored procedures development and
> I'm finding the Enterprise Manager to be quite difficult and cumbersome
> to work with. I'm looking for an editor with a common programming IDE
> look and feel.
> Can anybody please recommend me a good alternative?
You might want to take a look at our tool:
Database Workbench
www.upscene.com
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com|||that is a sweet gig.
Been using it for a while.
Greg Jackson
PDX, Oregon|||Thanks, I'll give that a try.
By the way, looks like a link update to
http://www.toadsoft.com/toadsqlserv...d_sqlserver.htm ;-).
Thanks again,
Sean
Kevin Kline [MVP] wrote:
> Hello Sean,
> Try TOAD for SQL Server (www.toadss.com). A new version will be out in th
e summer time...
> -Kevin Kline
> Quest Software (www.quest.com)
> SQL Server MVP
> I support PASS, the Professional Association for SQL Server. ([url]www.sqlpass.org[/
url])
>
>|||Martijn Tonies wrote:
>
> You might want to take a look at our tool:
> Database Workbench
> www.upscene.com
Good deal. I'll also look into this one.
Thanks,
Sean

Programming Tool

I wasn't really sure where to post my question, so if I'm off-topic,
could you please refer me to a more appropriate newsgroup?
I'm quite new to MS SQL Server 2000 stored procedures development and
I'm finding the Enterprise Manager to be quite difficult and cumbersome
to work with. I'm looking for an editor with a common programming IDE
look and feel.
Can anybody please recommend me a good alternative?
Thank you,
Sean
visual studio .net allows T-SQL editing and debugging.
Greg Jackson
Portland, OR
|||Hello Sean,
Try TOAD for SQL Server (www.toadss.com). A new version will be out in the summer time...
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support PASS, the Professional Association for SQL Server. (www.sqlpass.org)

> I wasn't really sure where to post my question, so if I'm off-topic,
> could you please refer me to a more appropriate newsgroup?
> I'm quite new to MS SQL Server 2000 stored procedures development and
> I'm finding the Enterprise Manager to be quite difficult and
> cumbersome to work with. I'm looking for an editor with a common
> programming IDE look and feel.
> Can anybody please recommend me a good alternative?
> Thank you,
>
|||You can use Access - create a project (adp file)
"Fao, Sean" <enceladus311@.yahoo.comI-WANT-NO-SPAM> wrote in message
news:uv9ly1WLFHA.3420@.tk2msftngp13.phx.gbl...
>I wasn't really sure where to post my question, so if I'm off-topic,
> could you please refer me to a more appropriate newsgroup?
> I'm quite new to MS SQL Server 2000 stored procedures development and
> I'm finding the Enterprise Manager to be quite difficult and cumbersome
> to work with. I'm looking for an editor with a common programming IDE
> look and feel.
> Can anybody please recommend me a good alternative?
> Thank you,
> --
> Sean
|||Query Analyzer.
Save your stored procedure creation scripts to files and check them in to
your favorite version control software.
Keith
"Fao, Sean" <enceladus311@.yahoo.comI-WANT-NO-SPAM> wrote in message
news:uv9ly1WLFHA.3420@.tk2msftngp13.phx.gbl...
> I wasn't really sure where to post my question, so if I'm off-topic,
> could you please refer me to a more appropriate newsgroup?
> I'm quite new to MS SQL Server 2000 stored procedures development and
> I'm finding the Enterprise Manager to be quite difficult and cumbersome
> to work with. I'm looking for an editor with a common programming IDE
> look and feel.
> Can anybody please recommend me a good alternative?
> Thank you,
> --
> Sean
|||
> I wasn't really sure where to post my question, so if I'm off-topic,
> could you please refer me to a more appropriate newsgroup?
> I'm quite new to MS SQL Server 2000 stored procedures development and
> I'm finding the Enterprise Manager to be quite difficult and cumbersome
> to work with. I'm looking for an editor with a common programming IDE
> look and feel.
> Can anybody please recommend me a good alternative?
You might want to take a look at our tool:
Database Workbench
www.upscene.com
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com
|||that is a sweet gig.
Been using it for a while.
Greg Jackson
PDX, Oregon
|||Thanks, I'll give that a try.
By the way, looks like a link update to
http://www.toadsoft.com/toadsqlserve..._sqlserver.htm ;-).
Thanks again,
Sean
Kevin Kline [MVP] wrote:
> Hello Sean,
> Try TOAD for SQL Server (www.toadss.com). A new version will be out in the summer time...
> -Kevin Kline
> Quest Software (www.quest.com)
> SQL Server MVP
> I support PASS, the Professional Association for SQL Server. (www.sqlpass.org)
>
>
|||Martijn Tonies wrote:
>
> You might want to take a look at our tool:
> Database Workbench
> www.upscene.com
Good deal. I'll also look into this one.
Thanks,
Sean

Programmatically create a Report Model

We would like to take advantage of the Report Builder tool to provide
end-user ad-hoc reporting. The database for the application can be
different depending on how the client configures it (they can add various
fields and data collection forms). At TechEd, I attended a session on
Microsoft Dynamics AX 4.0 and its tight integration with Reporting
Services/Report Builder. This is very much in line with what we'd like to
do. I imagine the users adding a field (through our interface), setting a
few properties, and then after some automated process occurs, they would be
able to use Report Builder to access any data collected in that field.
What we'd like to do is programmatically generate and maintain a report
model based on how the individual install is configured. I've found some
documentation that makes me believe this is possible, but I'm hoping someone
can nudge me in the right direction. The ReportingServices2005 class has
several model related methods (CreateModel) and I found the .xsd for the
semantic model XML file
(http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/SemanticModeling.xsd),
but no real documentation on how to put together a Report Model document
from scratch. Looking at the files generated from BIDS is somewhat
overwhelming and I have no idea where I'd pull most of the information.
Any help that can be provided would be greatly appreciated. Thanks!
RussellHi Russell,
Thank you for your posting!
From your description, my understanding of this issue is: You want to
programmatically manage the Report Model xml file (smdl). If I
misunderstood your concern, please feel free to let me know.
I would like to know what information you want to pull from the Report
Model. The smdl file is a xml file and I think you could control the file
in VS .NET.
The CreateModel of the Reporting Services 2005 class is used to upload the
Report Model file to Report Server. I think it is not quite meet your
requirement.
Here is an article about refine a report model.
Refining a Report Model
http://www.sqlmag.com/Article/ArticleID/50048/sql_server_50048.html
Hope this information will be helpful and please let me know the result.
Thank you!
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 Russell,
I would like to know whether the information is helpful. Feel free to let
me know if you have any questions.
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 Russel
did you have any success with that? did you solve it by creating the SMDL
File with an XMLTextWriter or did you find an other solution? an oblect that
could be referenced?
i am having the same problem and would like to establish the SMDL file fully
by code, from scratch.
any info is appreciated.
Kind Regards, Rene
"RussellReed" schrieb:
> We would like to take advantage of the Report Builder tool to provide
> end-user ad-hoc reporting. The database for the application can be
> different depending on how the client configures it (they can add various
> fields and data collection forms). At TechEd, I attended a session on
> Microsoft Dynamics AX 4.0 and its tight integration with Reporting
> Services/Report Builder. This is very much in line with what we'd like to
> do. I imagine the users adding a field (through our interface), setting a
> few properties, and then after some automated process occurs, they would be
> able to use Report Builder to access any data collected in that field.
> What we'd like to do is programmatically generate and maintain a report
> model based on how the individual install is configured. I've found some
> documentation that makes me believe this is possible, but I'm hoping someone
> can nudge me in the right direction. The ReportingServices2005 class has
> several model related methods (CreateModel) and I found the .xsd for the
> semantic model XML file
> (http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/SemanticModeling.xsd),
> but no real documentation on how to put together a Report Model document
> from scratch. Looking at the files generated from BIDS is somewhat
> overwhelming and I have no idea where I'd pull most of the information.
> Any help that can be provided would be greatly appreciated. Thanks!
> Russell
>
>