Stored Procedure Properties
| Name | Value |
|---|---|
| Owner | dbo |
| Created | 2004-05-31 |
| Startup | False |
| Encrypted | False |
Creation Options
| Name | Value |
|---|---|
| QUOTED_IDENTIFIER | OFF |
| ANSI_NULLS | OFF |
Parameters
| Name | DataType | Length | Type |
|---|
Total: 0 parameter(s)
SQL
SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO create procedure forums_GetEmailList AS -- get all of the emails SELECT EmailID, Description, Subject, Importance, FromAddress, Message FROM Emails (nolock) ORDER BY Description GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO