Is there any easy way to see those events in SQL Server 2008 for which permission was denied on a query (along with the text of the query and the specific object that permission was denied to)? I ...
(Using SQL Server 2005 or later) When I create a new user in a database, I must grant the VIEW DEFINITION right in order for that user to be able to execute sp_columns and get results. However, if ...
I have a database backup located in my Windows 7 Documents folder (C:\Users\Aaron\Documents...), and I'm trying to restore it using SQL Server Management Studio. However, the program is unable to ...
I'd like to set up an Access (2007) project that contains queries on a database (actually in MS SQL Server 2005), but I don't want to allow any direct writing to the database. How can I make it ...