Job monitor for SQLServer

Any recommendations for software that provides a nice end-user
interface to records of jobs run in SQLServer, hopefully with a
real-time updating as jobs run as well?
Thanks.
JoshHi
You may want to look at http://www.idera.com/Products/SQLschedule/
John
"jxstern" wrote:
> Any recommendations for software that provides a nice end-user
> interface to records of jobs run in SQLServer, hopefully with a
> real-time updating as jobs run as well?
> Thanks.
> Josh
>

Job monitor for SQLServer

Any recommendations for software that provides a nice end-user
interface to records of jobs run in SQLServer, hopefully with a
real-time updating as jobs run as well?
Thanks.
JoshHi
You may want to look at http://www.idera.com/Products/SQLschedule/
John
"jxstern" wrote:

> Any recommendations for software that provides a nice end-user
> interface to records of jobs run in SQLServer, hopefully with a
> real-time updating as jobs run as well?
> Thanks.
> Josh
>

Jet to Ansi SQL converter

I've got a weird question --
Have any of you ever come across software that can convert MS Jet SQL to ANSI standard SQL or other SQL flavors?
Could be a huge help in my next project. Please let me know if you know of anything like this!!
:)I'm not aware of any such software. And I probably wouldn't trust any that I came across. I just think it would be a difficult job writing software to interpret and translate all the crappy code that is out there!|||i do know that you can set the global database properties for microsoft access so that it will write it's queries in MS SQL format (ansi 92).

this would allow you to create simple queries in the query designer and then you could modify them and the designer would parse them but you can also do that in the graphical queries in the SQL Server 2000 Enterprise Manager

{For Access Queries in ANSI 92}
open a database
tools > options > Tables/Queries > SQL Server Compatible Syntax (ansi92)
choose this database or default for all new databases.

{For ANSI 92 Queries Graphically in SQL Server}
Open the SQL Server enterprise manager
expand Servers > [your server name] > Databases > [your database name]
open tables or views
right click one of the tables or views and select Open Table > Query
have at it.

i hope this helps

JDBC driver for SQL Server 2000 and Java 5?

How can I get a copy of an updated JDBC driver that works with Java 5 (for
SQL Server 2000)? I need to upgrade my software to run on the latest Java
runtime soon...
Tim O'Konski wrote:
> How can I get a copy of an updated JDBC driver that works with Java 5
(for
> SQL Server 2000)? I need to upgrade my software to run on the latest
Java
> runtime soon...
Your old driver will work just fine with Java 5. Apart from a very
misterious _possible issue_ that noone knows nothing about:
http://groups-beta.google.com/group/...54c78ec924fc65
Alin.
|||Microsoft SQL Server 2000 Driver for JDBC SP3 has now been certified
against Java 1.5. We did not see any regression with the BigDecimal
issue.
-shelby
Shelby Goerlitz
Microsoft, SQL Server
"Alin Sinpalean" <alin@.earthling.net> wrote in message
news:alin@.earthling.net:
> Tim O'Konski wrote:
>
> (for
>
> Java
>
> Your old driver will work just fine with Java 5. Apart from a very
> misterious _possible issue_ that noone knows nothing about:
> http://groups-beta.google.com/group/...jdbcdriver/br
> owse_thread/thread/bc54c78ec924fc65
> Alin.