Hmmm ... for MSSQL 2005, I cannot specifically say but for Sybase (which for our purposes is pretty much the same thing), you just call it like any other piece of SQL. The thing(s) to worry about:

• Parameters need to be escaped: $sth->prepare( "exec foo \@name = 'baz'" )
• Output parameters need to be handled differently (not sure if DBD::ODBC can handle that)
• Stored procs may return multiple (differing) resultsets (not sure if DBD::ODBC can handle that)
• Some stored procs have a tendency to not return resultsets (nor paramaters) but print to STDOUT - normally I catch these with a custom error handler (not sure if DBD::ODBC can handle that either)

that being said, if your stored proc does the normal case (returns a single resultset), you should be fine.