general questions on MS SQL.

Hi,

I'm starting a project on an MS SQL database and had a few general questions before I start. I have used microsoft access databases a good number of times in some projects. I interact with the MS Access databases using the DAO jet engine and its ms classes. (C++).

What method can I use to connect to an MS SQL database besides ODBC using C/C++?

I'm told a stored procedure is a 'function' that is launched at a user defined event. Can I have an .exe called upon an event I define in the database? Where are these stored procedures defined?

Thanks,
Mark