Search Result

Is there a more efficient way to write something like this? I have a text field that is updated by Sales people who will write, as an example, "This is opp 1" or "Call is Opportunity 12" or "opportunit y 5 - left message". It's totally free form. Reps have been instrusted to enter info a certain way, and simply will not receive the credit if they don't, but I do have to count data based on lower '%Opp%#%' in some way...

I'm looking for some alternative methods to replace Query Notifications in a current application I am working on. I have so far been searching for Alternatives to Query Notifications, but I can't seem to find the results I need.

The reason is that my Application has grown to over 15 users while still needing to keep each clients synchronized with changes made to the server. I currently have a custom data layer performing caching...

I would like to connect to a remote sql server using a stored procedure. I had planned on using OPENQUERY( linked_server ,'query' ) to pull data from the remote server but this command does not accept variables for its arguments. Is there another way to open a connection using Transact-SQL?

Thanks for your help!