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 SMDL File.

Hello,

I'm looking for Programmatically genration of Report Model .smdl file.

Please guide me or suggest some links so that ui can refer same.

Is there any smdl genrator or any classes for the same...?

Thanks in advance.

Sandip

Sandip,

Did you find the answer? As I am also struggling with the samilar question and was not able to get any heads up.

I am trying to understand whether we can create SMDL automatically or can we use objects rather than using databases.

Atul

|||I am hoping that this points you in the right direction:

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

Programmatically create a Report Model SMDL File.

Hello,

I'm looking for Programmatically genration of Report Model .smdl file.

Please guide me or suggest some links so that ui can refer same.

Is there any smdl genrator or any classes for the same...?

Thanks in advance.

Sandip

Sandip,

Did you find the answer? As I am also struggling with the samilar question and was not able to get any heads up.

I am trying to understand whether we can create SMDL automatically or can we use objects rather than using databases.

Atul

|||I am hoping that this points you in the right direction:

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