Compartilhar via

Working with MSDE

  • Artigo

A lot of the blog posts and workarounds that are discussed refer to using Enterprise Manager to accomplish various things (like backing up databases or attaching and detaching databases). As Enterprise Manager is a tool that is shipped with SQL Server some of our Embedded customers may be asking how they can accomplish some of these same tasks if they do not have the full SQL Server product installed, but instead have installed the database engine that shipped with the XP Embedded suite of tools. This engine is MSDE (Micrososft SQL Server Desktop Engine) - for more info on MSDE and the latest version called SQL Express, see here.

One of the most common utilities used to manage MSDE is located in C:\Program Files\Microsoft SQL Server\80\Tools\Binn folder and is called osql.exe. Osql accepts SQL statements, system (stored) procedures, and script files, and sends them to the SQL Server engine interactively. For an overview of how to use osql visit this link.

Some common stored procedures that you may use with osql include attaching and detaching a database, adding a user and granting them access to the db. Using osql.exe to interact with your database may be challenging and require a fair level of SQL knowledge, and the SQL newsgroup is a great place to get answers to questions associated with MSDE.

- Lynda

Comments