SQL Dependency

Hi!
Is there any way to use the sqldependency feature from ADO.NET with SQL Server Express editation ? I need this feature but I develop a shareware application and I can't buy Professional or higher SQL server for every downloaded copy.

Thanx.

[252 byte] By [LCoder] at [2008-1-27]

«« Shell32
»» How to put text in a listbox heads ?

# 1

Here is a MS article that includes info about the SQL Dependancy for 2005.
http://msdn2.microsoft.com/en-us/library/ms229862.aspx

JonM at 2007-9-8 >

top of Msdn Tech,SQL Server,Getting started with SQL Server...

# 2

It is very nice, but I want windows.forms application, not ASP.NET.

LCoder at 2007-9-8 >

# 3

I do not believe this is possible as SQL Server Express does not include SQL Server Service Broker. Can you tell us more what you are trying to do in your shareware application, and maybe we can provide ideas. Thanks, MJ

MarkJewett-MSFT at 2007-9-8 >

# 4

Express does include Service Broker. You can send messages within express SKUs, if a message passes a non-Express SKU though you will need a license for that particular SKU.

RobWalters at 2007-9-8 >

# 5

It is a very little business application with 1-20 user. I want to inform the user when the other user shell an item. But probably I can resolve this problem with a little server application.

LCoder at 2007-9-8 >

# 6

I have a similar issue. I want to use SqlDependency with Express. I have a sample app working against another SQL 2005 edition that works fine. But changing the connection string in the sample app to point to an Express edition causes it to stop working. I do have all required DB settings on (e.g., enabling of service broker and even CLR integration) in the Express database as well. I haven't been able to find an article on the Web that says that you cannot use SqlDependency against an Express edition database. Do you happen to know if this is possible? Thanks!

CHJ3 at 2007-9-8 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

it's Archive about 'SQL Dependency...'

SQL Dependency

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified