Hi GM, thanks for reading and replying.

About the blog, that's something I thought of, but since I don't really work much on SQL I wouldn't have many topics to discuss...

also, take a look here first: http://support.microsoft.com/kb/306212

As first step I'd check the instructions detailed in the link i've posted earlier on.

Also, I'm not 100% sure, but I would look at security issues between the two linked...

was it previously working fine or is it a brand new setup?

have you checked this post? http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/7172223f-acbe-4472-8cdf-feec80fd2e64

I'd use a 4 level naming convention:

slect *

from [LinkedServerName].[Database].[Owner].[Table]

Where [...]

that should do. You can only use the LinkedServerName if you have registered the server.

Hope this helps

Cheers,

Matt

EDIT: sorry, I didn't read the first two lines properly and the forum won't let me delete the post -_-

anyway, trivial question, have you tried doing as follows?

- sp_fulltext_service 'load_os_resources',...

I know this might be a trivial question, but it's worth asking... is SQL Server a 2005 version?

If you are lucky enought to have a SQL 2008 environment, I reckon...

take a look here http://www.mssqltips.com/tip.asp?tip=1346

cheers,

Matt

I'd assume that the number of words you look for are variable (?), therefore it would become really complicated (and to some extend unsafe if you create sql expressions) to...

Sounds like you are looking for Full-Text indexes?

see if this helps: http://msdn.microsoft.com/en-us/library/ms142571.aspx

more than websites, that could become confusing if you don't know exactly what you're looking for, I'd recommend the following books (in order of preference):

Microsoft® SQL Server® 2008 T-SQL...

try escaping the special characters. my guess is that the exception is thrown because the "&" is in first position, if somewhere eles it would problably be ignored.

check here...

would this be of any help?

Ref: http://blog.lab49.com/?p=196

Tips for reading Excel spreadsheets using ADO.NET

Microsoft ADO.NET provides a handy, if quirky way to access Excel spreadsheets from Windows applications....

linhdkl (5/13/2009)

---

Dear All,

I have a problems in my application, there are 30 million users in database and i don't have any idea for this problem. And now i'm finding an...