You could use a SQLCLR procedure to access the external data source, or import the data into the database (e.g. using a scheduled SSIS package).

This may be a shot in the dark, because I don't know your data, but...

Have you tried creating an index using the descending order on the datedesc column?

As you've noticed, some characters are ignored when building the full-text index (e.g. punctuation marks) and it is not possible to change the behaviour of the indexing engine.

With MSSearch using...

The -N switch means that character data will be exported as Unicode (Unicode files begin with the declaration that you've noticed).

If you don't use any ANSI extended characters you can...

SQL Logins/Users do not exist outside the SQL Server instance, therefore have no access to the "outer world".

In order for SQL Users to access external resources they must use appropriate...

Do the objects still exist?

Have permissions been changed?

What do those two tables have in common?

E.g. considering the same key exists in both tables:

select<column list>

from<table 1>

inner joincontainstable(<arguments> ) t1ct

ont1ct. = <table 1>.<FTS key column>

<inner or outer> join<table 2>

on<table...

Partition switching is a schema-only operation - i.e. only the pointers to the actual physical location of data are changed, no data is actually moved.

However, indexes must be aligned with...

Have you read this article by Tony Rogerson:

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/07/25/sql-2000-yes-lots-of-vlf-s-are-bad-improve-the-performance-of-your-triggers-and-log-backups-on-2000.aspx

It seems the problem (based on Tony's experimentation) is not present in SQL 2005.

Here's another article on the subject, by Kimberly L. Tripp,...

Have you considered database mirroring?

AFAIK, you can blog at SQL Server Central (http://www.sqlservercentral.com/blogs/[/url]).

On the right side of the screen look for "Get Your Own Blog".

You can use the bcp utility (look it up in Books Online) invoked via xp_cmdshell (look it up in Books Online). T-SQL is powerful and can be used to solve...

This is a very common question in newsgroups/forums, and you've provided a very intuitive example.

Have you considered posting this in a blog? It would certainly be useful for quite a...

Use single quotes to delimit explicit character values.

Double quotes can be used to delimit object identifiers (e.g. if they contain special characters). Look up the QUOTED_IDENTIFIER option in Books Online.

Is there a special reason for using user instances?

If you cannot avoid using them, make sure the "user instance enabled" option is set for the SQL Server Express instance (look...