Thanks Gail: I was able to return the query to normal operations removing the "NOT IN (SELECT..." and changing the CTE to include the matching IDs, so I am just...

Hi and thanks for helping out.

I'm not mapping any local-to-remote logins.

I have "For a login not defined above..." set to the last option, with a SQL login/pwd that's valid for...

tfifield (2/28/2011)

---

Thanks everyone for your comments. I should have mentioned in the article about Full Text searches in SQL Server.

As one poster mentioned, it's kind of a pain in...

alen teplitsky (2/28/2011)

---

thx

going to have to play with this. i have a huge database on a SQL 2005 server with full text indexing enabled and it can really be a...

KermitTheRock (2/28/2011)

---

Actually, I wrote of this just a week ago. The Contains function is often not sufficient for end user search. It doesn't handle misspellings, suggested search, implied "AND", and...

I've been using FTS on a view composed of several tables, and this method works pretty well, as I can return ranked results using "contains table". Not sure if the...

Craig Farrell (1/3/2011)

---

Sounds...

[moved to http://www.sqlservercentral.com/Forums/Topic1039170-146-1.aspx%5D

Hi: I'm having the same problem...SQL Agent won't start. I've tried a domain user account, the domain administrator account, and the local system account, but none of those works.

I was...