Tagged Questions

0
votes
1answer
66 views

SQL Server: Audit permission denied

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 ...
0
votes
0answers
38 views

What rights are needed to get results from sp_columns_rowset?

(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 ...
0
votes
1answer
320 views

Why Can't SQL Server Management Studio Access The “My Documents” Folder in Windows 7?

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 ...
1
vote
3answers
385 views

Is there a way to restrict direct write access to the database in Microsoft Access 2007?

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 ...