One further question: Is it possible to identify the newest record of each group and delete the others automatically? One of the fields is a datestamp, but I...

That worked perfectly. Thanks!

Eugene Elutin (5/29/2013)

Mark Harley (5/29/2013)

These are the possible combinations:

[1-6][A-Z]

[1-6][A-Z][A-Z][A-Z]

[1-6] + [1-6][A-Z][1-6][A-Z]

I'm beginning to wonder if this is something that should be handled in the application, and then passed...

These are the possible combinations:

[1-6][A-Z]

[1-6][A-Z][A-Z][A-Z]

[1-6] + [1-6][A-Z][1-6][A-Z]

I'm beginning to wonder if this is something that should be handled in the application, and then passed through to the sp...

Also, the OraOLEDB provider was already set to 'Allow Inprocess,' so this isn't the problem. I've tried deselecting this option, selecting it again, and then restarting the instance, but...

Ya, we did try rebooting the server. No such luck, I'm afraid.

One more update: It seems that when I select only one or two tables, there are no problems. I'm going to try adding the tables one at a...

I manually changed the data types, and was able to get past that point in the wizard. When I try to run the job, though, I get the following...

It is not all columns, only those mentioned in the error. There are several that are not mentioned, so I'm assuming there is no problem with those. Many...

That worked perfectly. Thanks!

Got it. That's exactly what I needed! Thanks for the help!

Thanks for the replies George and Rob.

As George guessed, the users are sql authenticated and the restores are not on the same server. Do I have to exectute sp_help_revlogin...

SQL Server (and the Access db) are sitting on Windows Server 2008 (64 bit), and when I try to select from the linked server I get the following error message:

The...

Excellent! Thanks for all the help.

Thanks for the links. I think you're right in that full-text indexing may not fit the bill exactly. I'm not even sure if the MS Search Service is...