Thread View: comp.databases.ms-sqlserver
6 messages
6 total messages
Started by ^-^
Tue, 22 Apr 2003 09:25
Enterprise manager web admin?
Author: ^-^
Date: Tue, 22 Apr 2003 09:25
Date: Tue, 22 Apr 2003 09:25
8 lines
2099 bytes
2099 bytes
Hi there... Is it possible to have a "web admin" feature in sql server? If not for admin, only for displaying stats for the system admin eg: number of rows in tables, database size.... almost like the taskpad view in enterprise manager.... Is this possible and does it exist? Thanks ^-^
Re: Enterprise manager web admin?
Author: Greg Linwood
Date: Tue, 22 Apr 2003 11:59
Date: Tue, 22 Apr 2003 11:59
37 lines
3204 bytes
3204 bytes
You might already know this, but the SQL Enterprise Manager itself is web-enabled (has been since 6.5) - you can just set it up to connect over TCP/IP and it can actually do the job. A common problem with this, though, is that it tends to work slowly when the server has many databases or many objects in an individual database so this might only be a good choice if you've got plenty of bandwidth. The Query Analyser works quite well over the web - quite a bit more efficient than EM actually. To set either SQL EM or SQL QA up to work over the web, you just configure a client network library alias to work over TCP/IP and connect to that aliased server. Another option you might consider is to use Terminal Services which will let you do quite a bit more than EM or QA (or any other web interface you develop) will. It's also possible to create an ASP or remote app to do specific things via the SQL-DMO distributed programming API if you're interested in doing some (fairly simple) programming. Maybe someone will chip in with a nice set of ASP scripts for you yet though.. <g> Regards, Greg Linwood "^-^" <tjoppie@inetonline.co.za> wrote in message news:b831oi$7m0$1@ctb-nnrp2.saix.net... > Hi there... > Is it possible to have a "web admin" feature in sql server? If not for > admin, only for displaying stats for the system admin eg: number of rows in > tables, database size.... almost like the taskpad view in enterprise > manager.... Is this possible and does it exist? > > Thanks > ^-^ > >
Re: Enterprise manager web admin?
Author: Andrew J. Kelly
Date: Tue, 22 Apr 2003 12:48
Date: Tue, 22 Apr 2003 12:48
31 lines
2591 bytes
2591 bytes
In addition to Greg's comments here are some 3rd party tools that may do what your after. http://www.support.microsoft.com/?id=325003 Manage MSDE with oSql http://www.zeta.org.au/~extrasql/ Low cost Web Admin tool http://microsoft.com/downloads/details.aspx?FamilyId=F0D03472-5E6C-459E-A6D8-6745A729C3C9&displaylang=en Web Admin app http://www.laplas-soft.com/exec-intro.htm -- Andrew J. Kelly SQL Server MVP "^-^" <tjoppie@inetonline.co.za> wrote in message news:b831oi$7m0$1@ctb-nnrp2.saix.net... > Hi there... > Is it possible to have a "web admin" feature in sql server? If not for > admin, only for displaying stats for the system admin eg: number of rows in > tables, database size.... almost like the taskpad view in enterprise > manager.... Is this possible and does it exist? > > Thanks > ^-^ > >
Re: Enterprise manager web admin?
Author: Jasper Smith
Date: Tue, 22 Apr 2003 18:59
Date: Tue, 22 Apr 2003 18:59
24 lines
2272 bytes
2272 bytes
Have a look at http://www.aspenterprisemanager.com -- HTH Jasper Smith (SQL Server MVP) I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "^-^" <tjoppie@inetonline.co.za> wrote in message news:b831oi$7m0$1@ctb-nnrp2.saix.net... > Hi there... > Is it possible to have a "web admin" feature in sql server? If not for > admin, only for displaying stats for the system admin eg: number of rows in > tables, database size.... almost like the taskpad view in enterprise > manager.... Is this possible and does it exist? > > Thanks > ^-^ > >
Re: Enterprise manager web admin?
Author: Andrew J. Kelly
Date: Tue, 22 Apr 2003 20:08
Date: Tue, 22 Apr 2003 20:08
36 lines
2698 bytes
2698 bytes
Thanks Jasper, just added that one to my list. -- Andrew J. Kelly SQL Server MVP "Jasper Smith" <jasper_smith9@hotmail.com> wrote in message news:OuJFSGQCDHA.2328@TK2MSFTNGP10.phx.gbl... > Have a look at http://www.aspenterprisemanager.com > > -- > HTH > > Jasper Smith (SQL Server MVP) > > I support PASS - the definitive, global > community for SQL Server professionals - > http://www.sqlpass.org > > "^-^" <tjoppie@inetonline.co.za> wrote in message > news:b831oi$7m0$1@ctb-nnrp2.saix.net... > > Hi there... > > Is it possible to have a "web admin" feature in sql server? If not for > > admin, only for displaying stats for the system admin eg: number of rows > in > > tables, database size.... almost like the taskpad view in enterprise > > manager.... Is this possible and does it exist? > > > > Thanks > > ^-^ > > > > > >
Re: Enterprise manager web admin?
Author: Greg Linwood
Date: Tue, 22 Apr 2003 22:08
Date: Tue, 22 Apr 2003 22:08
33 lines
2563 bytes
2563 bytes
wow... someone's been busy with that one! Regards, Greg Linwood "Jasper Smith" <jasper_smith9@hotmail.com> wrote in message news:OuJFSGQCDHA.2328@TK2MSFTNGP10.phx.gbl... > Have a look at http://www.aspenterprisemanager.com > > -- > HTH > > Jasper Smith (SQL Server MVP) > > I support PASS - the definitive, global > community for SQL Server professionals - > http://www.sqlpass.org > > "^-^" <tjoppie@inetonline.co.za> wrote in message > news:b831oi$7m0$1@ctb-nnrp2.saix.net... > > Hi there... > > Is it possible to have a "web admin" feature in sql server? If not for > > admin, only for displaying stats for the system admin eg: number of rows > in > > tables, database size.... almost like the taskpad view in enterprise > > manager.... Is this possible and does it exist? > > > > Thanks > > ^-^ > > > > > >
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads