Service Broker to SQL CLR should work OK too. IIRC, reading from a Web Service is one of the first SQL CLR examples in BOL.

Somebody has that Excel file open, or has a dangling lock left on it. My guess would be that its you, since you just changed it. So do...

You should be aware that although no City in the U.S. that I know of crosses state lines, some may effectively cross county lines, and many cover more than one...

Unfortunately, it can take a while for AD changes to propagate to whatever SQL Server is using to Cache it. It have seen it take up to 24 hours...

That depends. Do you want to be able to read the SQL CLR assemblies that the developers are going to want to put on your databases or not? ...

Please read this Article: Example of Safely Using Dynamic SQL with User Selected Table Name. Just do what it says, except for your column name instead of the table...

I agree with Welsh, I couldn't understand what you were asking us for.

Also, the design of your tables looks very non-relational. "No repeating columns" is a very important relational...

Your crawl is probably still running, how long it takes depends on how much data it has to cover. I am no expert on FTS, but I have had...

Since you're on SQL 2008, pass the IDs in as a TVP (table-valued parameter) and receive the results back as a datatable. SQL CAT's test have generally shown this...

Has this table been TRUNCATEd?

IIRC, this is a known bugfeature of truncating a table with an Identity column.

It may sound crazy, but I think that your function would work better as an in-line TVF.

GilaMonster (3/8/2010)

---

There are downsides. I've just spent 3 weeks writing documentation and reports (til...

Great Hrubaru, I'm glad it worked out! 🙂

Paul White (3/7/2010)

---

A few constructive criticisms, Barry:

Running a full-text search with a variable as a parameter can be problematic. You might have noticed that the full-text engine can provide...

Well I think I've got it. You can call the following procedure from your code, it should do what you need:

CREATE PROCEDURE FTSearchProducts(@strPhrase as VARCHAR(MAX), @AreaID as Int =...