[RESOLVED] MSDE same as using MDB?

[ober0330]

Hmm... and you can use that database just like you were running it off of the full SQL Server (queries of all types?).

What setup.exe file are you talking about? And I have the Enterprise Manager, if that's what you're referring to.

[Dave Sell]

Hmm... and you can use that database just like you were running it off of the full SQL Server (queries of all types?).

Yes, but there are some limitations, like I think you don't get stored procedures. I have been using it for a while for high-performance logging and am quite pleased with the performance.

What setup.exe file are you talking about?

When you download the MSDE executable it extracts itself to a folder on your hard drive. In that new folder is a setup.exe

And I have the Enterprise Manager, if that's what you're referring to.

Yes that, and the Query analyser can be used with MSDE. I used them to create new databases, handle minor user privies, and run SQL statements.