<< Material from my &quot;Making ORM applications more secure/Naredimo ORM aplikacije varnejše&quot; presentation | XNA Game Studio: I could play video but I'd rather not >>

Minimum database permissions for using SqlDependency with SQL Server 2005

by Miha Markič 8. October 2008 16:06

If you wonder what minimum permissions you need to use SqlDependency with SQL Server 2005 then look no further. This code project article definitely works and is the most complete one I've found. Note that setting minimum database permissions for notification isn't exactly the easiest task on the planet. Actually through experimenting I've managed to create a service_queue in sys.objects that I couldn't remove without restoring the database entirely (luckily I am using RedGate's SQL Backup 5 for backing up my databases - it makes the backup and restore process so easy, not to mention the encryption and compression capabilities).

Anyway, after restoring the database to the initial non-notification enabled point (clean state), I managed to apply proper minimum permissions following the mentioned article.

b0f43ed0-173f-43bc-96a5-683ae37d52e9|0|.0

Tags:

SQL | .net 3.5

Peculiar problem involving Windows 2003, VMWare Server, SQL Server 2005 and networkingOver the weekend I've built my new server - yes, the content you are reading right now is ...Importing Access database into Sql Server 2005Today I had a need to import an old Access database into Sql Server 2005. First I tried wi...New ADO.NET 2.0 book: Professional ADO.NET 2: Programming with SQL Server 2005, Oracle, and MySQL is outMy friend and a MVP Bill Ryan co-authored a brand new ADO.NET 2.0 book Professional ADO.NET 2: ...

Add comment

Name* Required Please choose another name

E-mail*

Country Country flag

b i u quote

Comment
Preview

Notify me when new comments are added

Miha Markic

INETA Country Leader for Slovenia

Miha currently works as a free lance consultant and software developer specialized in .net area.
He graduated in Computer and information science at the University of Ljubljana, Slovenia. He has accumulated experience in various programming languages such as Java, Visual Basic 3-6 (MCP), Visual C++, Delphi, C# and VB.Net through years.
He has experience in practically all (technical) stages of project development, including planning, framework development, user interface, business processes, as well as testing and documenting. He has worked on big and small projects in Slovenia and abroad (e.g. participated in completing level 3 IS for the Nucor steel plant, Hertford, USA).
Currently he enjoys programming in .net environment using C#. Since 2000 he has been active in Developer Express' DX Squad and has been ECDL trainer and tester. He also gives lectures on conferences and other events in Slovenia.