Try specificying the table as: SERVER.Dbname.dbo.Tablename

I would consider having a middle tier for this. The clients would always hit this tier and the logic will handle all the fetching/pre-fetching and caching data as needed to...

I would opt for solution number 2. If done correctly, and insuring your disk situation is adequate you should be able to effect minimal impact.

oh well, at least you can get another gmail account. lol

Query script is on the way.

yes, I can do that if you provide me an email address.

yes, we do this every day (have to in the banking industry to comply with regs)

I set up a .net service the downloads the OFAC database everyday and bulk inserts...

are you using the same login that the report uses when you are testing with tsql?

what is M: drive? When you log in as the mssqlserver user can you navigate to to that location and see that file? - sorry you already specified...

edit the service startup parameters (in services applet) to add the -m switch then start the service.

yes, based on that many users and DB size I would triple the size of RAM from what you have. Of course, the more the merrier, as you can never...

Or, if you are in...

How much RAM you need is directly proportional to the number of users and/or database connections and inversely proportional to the quality of the database design.

As far as allocating DB...

Yup. We do constant logshipping and DB restores to local warm standby servers and also to a DR site. Any failure to restore a log or a database sets off...

I agree with setting a domain account for these backup jobs, or you could set up a local server windows account to do it also.

If you do use SQL Server...

I think I would create a new view that does not have that character in it.

The '?' means it is a unicode character that can't be displayed in the current...