I haven't worked with Access in a while but I seem to recall you could set up a linked-table, where the data lives on a different database but is accessible...

Let me start with good luck and props to you for asking the question as well as taking this on. Working on stuff that might be out of your...

If I am understanding you correctly, re-presenting the storage should work, just reattach the databases. Also script out your users beforehand.

Regardless, have good backups of everything. If all else...

Please look at

http://support.microsoft.com/kb/293422

Are you trying to send an attachment? Can you send a test mail? Also just want to confirm this SQL 2008 (older versions had a bug that could...

Yep I realized both...

I used to work on the product that the poster mentioned and was partially giving them a hard time about trying to do it....

🙂

Jean, I guess the first question is why do you want to force case and accent sensitivity? It will ignore the index on the field and hurt performance.

So working with Interaction eh?...

You could look at doing a sub-select I guess or perhaps even a pivot.

Considering what you have said, go ahead with the different databases assuming it does not make the coding more of a pain. I don't see a huge enough advantage...

It depends....

Are you going to need to take different downtimes depending on counrty?

Is the database going to get really, really huge if you include all countries in one database?

Would country...

The BOL entry reads a bit like a car rental agreement and to be blunt is some ways is useless

The values for each column are set to zero whenever the...

In a single sentence.

A covering index is an index that contains everything a query needs to complete without going to the actual physical table.

Tried that, the problem is the public role has wide access and I can't take the specific user out of public and I can't modify the public rights.

Or are you talking about changing the recovery/logging model when doing large index operations?

Also keep in mind SQL Server will likely not have stats on the table in the linked server, so any join performance with a linked table is impacted by that....