MSSQL Manager

[VxJasonxV]

Yes, it's me again.
Ok, I am 100% throughly sure that I DO NOT have an SQL Manager installed.

1) There is no snap in for the MMC.
2) It's not in Computer Management, .NET management, or other.
3) There is NO start menu entry.

All I have is the service manager constantly running.

I have never used MSSQL, so unless I don't know if I'm missing something.

So, I have 2 questions for everyone:
1) There's a way to remotely administer just the SQL tables, databases, etc.?

2) Isn't there a way to administer it via the actual computer it's on? :P.

I put in a ticket saying that I believe that it's not present, and all I got back was a response saying it should be installed with ASP WebMatrix or what ever it's called :P.

I don't have the money to hire support, and I don't need it, I just need to know if it's there or not, that's ALL.

Thanks.

[Nestor]

Check your windows Add/Remove components and see if you have this feature enabled. Might be there, just not enabled.

[VxJasonxV]

In Add/Remove there's the SQL Desktop Engine. I can't change it (greyed out). If I attempt to repair it, I can't, because I don't have SQLRun01.msi.

It's not in the Add/Remove Windows Components either.

Any more ideas?

[saxroots]

SQL Desktop Engine (MSDE) doesn't come with SQL Manager.

Web Matrix is a programming environment that amongt other things allows you to manipulate MSDE directly. If you go to www.asp.net you will find a free Web Matrix tutorial which explains it.

You can work either with remote databases or local ones - no difference in procedure - just different addresses.

[VxJasonxV]

THANK YOU SAXROOTS!!!
That's ALL I've needed to know.