ASP SQL Error Handling
- by J Harley
Hello,
I am using Classic asp and SQL Server 2005.
This is code that works (Provided by another member of Stack Overflow):
sqlStr = "USE "&databaseNameRecordSet.Fields.Item("name")&";SELECT permission_name FROM fn_my_permissions(null, 'database')"
This code checks what permissions I have on a given database - the problem being - if I dont have permission it throws an error and doesn't continue to draw the rest of my page.
Anyone got any ideas on remedying this?
Many Thanks,
Joel