Using MSSQL

[aVex]

Hi,

Would like to know how can I administer my MSSQL DB ?
From my desktop if I have EM ? Can I do it ?
Or there are also other methods like web-based EM ?

I cannot seem to find the place to access my db after creating it and its users ... . sheesh ...

sorry if i look dumb ...

[aVex]

I think I have to upgrade my notebook's SQL Server edition right ?
I tried to connect using the IP and it says that I must upgrade to MSSQL 2000 ..... ?

Btw, does MySQL supports stored procedures ?

[Brangwyn]

You need to use the 2000 version of Enterprise Manager to connect to MSSQL2000

As far as I know (and I don't really follow MySQL so could be wrong) MySQL still doesn't have official stored procedures support, it was originally slated for version 4, but I think they've pushed it back to V5 now.

[aVex]

oh ... sigh, btw, how do u go about installing the EM .Net thingy that you shared ur link with ? Can I also install that app. on my website ?

[Brangwyn]

You can download the latest version here and just follow the install instructions to get your own version up and running.

http://www.aspenterprisemanager.com/

When I just tested the link it didn't seem to work so I'm not sure whats up with their website right now, if you can't find it anywhere else then PM me with your email address and I'll zip my one up and email it to you.

[aVex]

Will do !

Thanks Brangy !!