How can I get SqlDependency to work with CLR Stored Procedures

=?Utf-8?B?Um9iZXJ0IFp1cmVy?=

Guest

Posts: n/a

19th Dec 2005

I set up a test application using SqlDependency. It worked very well as long
as I was using simple Stored Procedures entered via Sql Server Management
Studio.

When I wrote the same procedure in a Visual Studio 2005 Sql Server Project
and deployed it, CLR procedure executed successfully but the SqlDependency
did not work. The 'Enable CLR' option was checked and the client app had the
proper permissions.

Does SqlDependency support CLR Procedures?

« System.Transactions and SQL 2000 | DataSet.Merge() does not merge row and/or column errors in any cas »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Do TEMP tables in Stored Procedures not work with ADO Recordsets?	=?Utf-8?B?VG9ueV9WQkFDb2Rlcg==?=	Microsoft Access VBA Modules	1	6th Sep 2007 03:34 PM
how can i convert stored procedures in sql to stored queries in ac	=?Utf-8?B?YWRz?=	Microsoft Access Queries	1	28th Aug 2006 01:49 PM
Map Stored Procedure dependencies from ASP pages through methods to stored procedures	dwilliams@newportgroup.com	Microsoft Dot NET	6	18th Mar 2005 03:02 AM
Map Stored Procedure dependencies from ASP pages through methods to stored procedures	dwilliams@newportgroup.com	Microsoft ADO .NET	2	17th Mar 2005 12:47 PM
Error: Executing Stored Procedures-- Cannot Pass TimeStamp Values From sqlCommand Object Parameter to A SQL Stored Procedure	=?Utf-8?B?VGVjaE1E?=	Microsoft ADO .NET	3	17th Mar 2004 04:03 AM