How to run SQL against the BCM database

OSQL is installed with SQLServer.

On the same machine as BCM, with the same login that installed BCM, from a command prompt, run:

OSQL -E -S .\microsoftsmlbiz -d msbusinesscontactmanager

Use your own server instance and database names if they are different from the defaults.

You find can your server instance name by looking at your SQL Server service; Start, My Computers, Manage, Services and Applications\Services.

You can find database name in your mail profile; Start, Control Panel, Mail, Show Profiles, select your bcm profile, Properties, Data Files..., Name: Business Contact Manager, Filename: :

From the OSQL prompt you can enter SQL commands; e.g. SELECT * FROM OrgTable
Type GO on the following line to execute the command.
Type EXIT to leave OSQL.