IMHO your best option would be to design a client application for that task.

What exactly are you trying to do?

Would you like to install a named server instance? Specify the instance name during installation.

Would you like to rename a server instance? Take a...

I'm just glad I could help. 🙂

Frankly, I didn't think OPENQUERY would work. 🙂

Then again, I haven't even tried it.

Good on you!

Obviously, the relationships between the objects involved in the query are not as simple as you might have thought.

However, you do have several options:

1) Add restrictions to the JOIN conditions...

A table is an unordered set. Order is guaranteed only when the ORDER BY clause is used in the outer query and only in retrieval operations. If ORDER BY is...

Why have you decided on using dynamic SQL?

Please, post table DDL, sample data and expected results.

If you can live with some downtime, detach/attach is the simplest method.

Invoking built-in user-defined functions:

http://msdn.microsoft.com/en-us/library/aa213008(SQL.80).aspx

The GRANT/DENY/REVOKE statements:

http://msdn.microsoft.com/en-us/library/ms187965.aspx

http://msdn.microsoft.com/en-us/library/ms188338.aspx

http://msdn.microsoft.com/en-us/library/ms187728.aspx

Is that what you've been looking for?

Please, attach the XML sample to the post, and post the query again.

The query you posted does not seem to be the actual query. Perhaps it was mangled by the...

How is the full-text catalog populated (i.e. automatically or manually)?

How many rows should have been returned by the query?

Have you also checked the FTS crawl log?

Note that "C:\perfeed" refers to a folder located on the C: drive at the server.

Does that folder exist at the server? Does the file exist in that folder? Does the...

SQL Server 2005 does not support datetime values lower than 17530101 00:00:00.000.

- Clean up the data at the source; or

- Export the data from the access database (e.g. as CSV)...

I agree with Hugo. Unless someone (preferably the author of the QOD) can show how rows can be counted using sp_describe_cursor_columns, the correct answer should be sp_cursor_list, sp_describe_cursor and @@cursor_rows.

No problem. Just remember SSC! 🙂

However, if moving data between SQL Server and Excel is a regular requirement, you should also look into SSIS, linked servers, or perhaps even the...