Anybody looked at LGX Report?

This is at freereporting.com.
It seems to be very similar to Reporting Services.
Has anybody here made a comparison?
JCLooks good, I noticed you have to pay for PDF outputs, which you don't
on RS.
Also one of the biggest advantages of RS is that it is seamless
connection to Visual Studio .Net

Any MySQL ENUM eqvivalent in MSSQL?

Hi,

Can't seem to find a similar data type in MSSQL like the one very handy ENUM type existing in e.g MySQL:

... Enum('on','off','standby') ...

It's also a convinient way to check for true/false. I'd appreciate any suggestions on possible "workarounds" or sources that might point me in the right direction.

Best

You could use a Rule or a Check Constraint.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Any Linux-based apps similar to MS SQL Enterprise w/ DTS ?

Hi all,

I bet this doesn't exist, but does anyone know of an MS SQL Enterprise
Manager-type application for Linux that would give me access to a DTS
stored on the server? I'm a web programmer by profession, and most of
my tools are Linux-based, but because I do so much indepth work in MS
SQL and DTS's, I've been dual-booting between Windows and Linux mainly
because there's no way I know of to access my MS SQL DTS's from Linux.

Any Linux solutions out there that will read and maybe even edit SQL
DTS's?

Thanks,

Alex.Don't know of any linux tools for sql server but here are two alternatives
that may be useful to you:
http://www.vmware.com/ - no need for dual booting if you can run both OSs at
the same time

http://www.microsoft.com/downloads/...&displaylang=en
SQL Server web data admin tool

"Alex" <alex@.totallynerd.com> wrote in message
news:2ba4b4eb.0404150752.6019c780@.posting.google.c om...
> Hi all,
> I bet this doesn't exist, but does anyone know of an MS SQL Enterprise
> Manager-type application for Linux that would give me access to a DTS
> stored on the server? I'm a web programmer by profession, and most of
> my tools are Linux-based, but because I do so much indepth work in MS
> SQL and DTS's, I've been dual-booting between Windows and Linux mainly
> because there's no way I know of to access my MS SQL DTS's from Linux.
> Any Linux solutions out there that will read and maybe even edit SQL
> DTS's?
> Thanks,
> Alex.

Any debugger in MSSQL 2005?

In SQL Server 2005, is there any debugging tools for T-SQL programming works similar to that in Visual Studio .NET?You have to use visual Studio to debug TSQL in SQL 2005. There is nothing in management studio.

Any 3rd party tools for integrating VSS w/ query analyzer or similar?

Are there any 3rd party tools that allow VSS to be directly intergrated with
Query Analyzer? Or are there replacements for Query Analyzer that have VSS
built in?
We found http://www.mssqlXpress.com , but it likely has more bells and
whistles than we need and/or want to pay for. We just need/want QA with VSS
built in ...
Thanks in advance!
MarkOne thing you can do is add VSS to the external tools in Query analyzer
passing command line parameters...
SS.exe I think is VSS executable...For instance to check out the current
file..
Command: ss.exe
Arguments; checkout $(Filename)$(FileExt) -C-
Initial Directory: $(FileDir)
Ken Henderson covers some of this in his new book 'The Guru's Guide to SQL
Server Architecture and Internals'...
It's a good book , I recommend it.!
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mark" <mfield@.idonotlikespam.cce.umn.edu> wrote in message
news:eaeFIaxlDHA.2272@.tk2msftngp13.phx.gbl...
> Are there any 3rd party tools that allow VSS to be directly intergrated
with
> Query Analyzer? Or are there replacements for Query Analyzer that have
VSS
> built in?
> We found http://www.mssqlXpress.com , but it likely has more bells and
> whistles than we need and/or want to pay for. We just need/want QA with
VSS
> built in ...
> Thanks in advance!
> Mark
>