July 1, 2008 at 4:50 am
Hi,
Can I restrict access to the database by using hostname or hostid?
July 1, 2008 at 5:46 am
[font="Verdana"]I'm not 100% sure about this, but you can try DDL triggers to do this.[/font]
Regards..Vidhya Sagar
SQL-Articles
July 1, 2008 at 5:52 am
Thanks vidhya.
July 1, 2008 at 6:29 am
bkrishnasamy (7/1/2008)
Hi,Can I restrict access to the database by using hostname or hostid?
Have a look at Logon triggers http://technet.microsoft.com/en-us/library/bb326598.aspx.
Note that you will need to have SP2 of SQL Server 2005.
Regards,
Andras
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply