Oct 28, 2010 | Permissions, Scripts, Security, SQLServerPedia Syndication |
In order to be able to execute bulk operations you need to certain level of privilege both on the database (table) you are performing the operation against and the instance you are performing the operation on.If you don’t have the necessary permissions you will...
Feb 28, 2010 | Permissions, Security, SQLServerPedia Syndication |
There are some new database roles in the MSDB database in SQL Server 2005 that allow you to grant more granular permission to non-sa users in the SQL Server agent. If you work in an environment similar to the one i support, application and database code will...
Feb 21, 2010 | Permissions, Security |
I recently restored a SQL Server 2005 database to a testing environment. The database contained several CLR assemblies, when the tester tried to execute one of the CLR’s SQL returned the following error: An error occurred in the Microsoft .NET Framework while trying...
