1. Limit the return records
set rowcount #records_num#
2. view the table schema definition
sp_help #table_name#
3. view the stored procedure definition
sp_helptext #sp_name#
set rowcount #records_num#
2. view the table schema definition
sp_help #table_name#
3. view the stored procedure definition
sp_helptext #sp_name#