...very Simple...

Define a NAV Automation Object

Name   DataType   Subtype   Length
conn   Automation   'Microsoft ActiveX Data Objects 2.8 Library'.Connection   

Code
CREATE(conn);
conn.Open('Provider=SQLOLEDB.1;Integrated Security=SSPI;Initial Catalog=[Servername];Data Source=[Databasename]');
conn.Execute('EXEC StoreProcedureName');
conn.Close;
CLEAR(conn);

Calling and Runnning With
ADO_Conne.Execute({sp name});

NB: You can pass parameters to stored procedures.

Bye.