I'm new to MM .NET. I'm creating an application with a SQL Server backend and with the SQL Server Security, the users will not be able to issue SELECT, INSERT, UPDATE and DELETE statements directly. Everything has to call a stored procedure.

This all seems to be working except when the business object's NewRow() method is called. The following commands are being sent:

SET FMTONLY OFF;
SET NO_BROWSABLE ON;
SET FMTONLY ON;
SELECT * FROM [Families]
SET FMTONLY OFF;
SET NO_BROWSABLE OFF;

I have put these commands in a stored procedure and want to call the stored procedure when the NewRow() method is called. How do I do this?