Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Security

sp_denylogin

Hi,

Should references to sp_denylogin be replaced with:

DENY CONNECT SQL

June CTP BOL makes no reference to sp_denylogin being
deprecated.

Thanks,

Joe

[198 byte] By [JosephSack] at [2008-1-13]
«« VS 2005 & .Net Compact Framework
»» Date picker not showing...
# 1
Yes, DENY CONNECT SQL is the preferred approach. A deprecation notice is added to the sp_denylogin article but it didn't appear yet in recent builds of BOL.

Thanks
Laurentiu

LaurentiuCristofor at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Security...
# 2
Thank you, and sorry for my double post.
JosephSack at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Security...
SQL Server
SQL Server Security

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified