question

what is the meaning?
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
and can i know the stored procedure create/modify date?joe
Have you read the explanation in the BOL?
"joe" <joe@.discussions.microsoft.com> wrote in message
news:5D11AFAF-D0F4-4B0D-9578-07E744A10955@.microsoft.com...
> what is the meaning?
> set ANSI_NULLS ON
> set QUOTED_IDENTIFIER ON
> and can i know the stored procedure create/modify date?|||First two questions, as Uri has pointed out, you can get the info from BOL
and for knowing the created and altered date.
use this query.
select ROUTINE_NAME,created,last_altered from information_schema.routines
where routine_type = 'procedure'
Hope this helps.