EM without SQL Server?

Hi I'm new to SQL Server.
Actually I don't have SQL server installed locally, only on my hoster.
Now I was wondering whether I can get/use EM for SQL standalone,
as mmc snap-in, to connect to my remote DB? And where to get it, or any good alternative manager. (I tried www.aspenterprisemanager.com/ - it couldn't connect to the server, I tried another (unreleased) manager and that was buggy)Do you have a CD with any SQL Server edition? You should be able to install just the Client Tools off of it.|||drjabarov, no I don't have any SQL Server CD's...
I was thinking, I only need this to upload & execute some SPROCS
on my SQL server, what if I got MSDE and used osql.exe?
Not sure whether that would work... however I'd rather have a graphical interface...Isn't there any (cheap) alternative to EM?

Thanks for your reply.|||sure a cheap alternative is the developer edition
40$ from microsoft
however you should check your liscensing.
you could also download the eval edition to you client and use the enterprise manager to register your sql server
it's a 120 day time bomb however. so you will have to uninstall it and then reinstall it
however you should check your liscensing.

there are no cheap management tools for sql server

netiq mgmt server costs $7,500 for a 5 server lisc.|||oops, hmm I see.
Thanks for the tip with the trial edition, I'll give that a try.

EM showing (No Items)

Having made no changes to the database server we are now getting no
database list when connecting via EM from client machines, as well as
locally on the database server. I've researched the problem to no
success. The database list shows up fine in QA, however. I used the
following script in QA:
use master
go
select * from sysdatabases
go
And this is the error message I received:
(36 row(s) affected)
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 51805.
I saw a similar message when trying to delete an outdated Login
account.
Anyone have any ideas? Thanks in advance!
Jon Brookins
Paragon New Media, Inc.What version? Have you run DBCC CHECKDB recently?
"Jon Brookins" <jonathan@.pnmi.com> wrote in message
news:fa11c6b4.0310101200.58233742@.posting.google.com...
> Having made no changes to the database server we are now getting no
> database list when connecting via EM from client machines, as well as
> locally on the database server. I've researched the problem to no
> success. The database list shows up fine in QA, however. I used the
> following script in QA:
> use master
> go
> select * from sysdatabases
> go
> And this is the error message I received:
>
> (36 row(s) affected)
> Server: Msg 220, Level 16, State 1, Line 1
> Arithmetic overflow error for data type smallint, value = 51805.
> I saw a similar message when trying to delete an outdated Login
> account.
> Anyone have any ideas? Thanks in advance!
> Jon Brookins
> Paragon New Media, Inc.|||CHECKDB sounds like a good suggestion. Also, you might want to prepare yourself for restoring a
clean backup of the master database.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Jon Brookins" <jonathan@.pnmi.com> wrote in message
news:fa11c6b4.0310101200.58233742@.posting.google.com...
> Having made no changes to the database server we are now getting no
> database list when connecting via EM from client machines, as well as
> locally on the database server. I've researched the problem to no
> success. The database list shows up fine in QA, however. I used the
> following script in QA:
> use master
> go
> select * from sysdatabases
> go
> And this is the error message I received:
>
> (36 row(s) affected)
> Server: Msg 220, Level 16, State 1, Line 1
> Arithmetic overflow error for data type smallint, value = 51805.
> I saw a similar message when trying to delete an outdated Login
> account.
> Anyone have any ideas? Thanks in advance!
> Jon Brookins
> Paragon New Media, Inc.