Using sqlcmd with BCM v3 databases

From a command line, on the same machine as the database and logged in as a user with permissiion to access the database, run:

sqlcmd -E -S .\MSSMLBIZ -d MSSmallBusiness

That should connect to database MSSmallBusiness. You'll see a prompt.

Type in a command, e.g.:

SELECT BusinessAddressStreet FROM PublicAccountsView
GO

That should dump the results to the screen.

Type EXIT to get out of sqlcmd.