Are the awe parameters setup correctly? (windows)

Have you set the memory for sql server to a fixed size (min & max)?

Sql server also needs the rights to lock pages in...

You can use ODBC linked tables in the mdb files as a short term workaround.

There could be some change of behaviour in record locking ...

Also have a look at

http://www.sqlservercentral.com/Forums/Topic247770-131-1.aspx

where...

Business Intelligence. Trying to get more usefull information out of your data.

Not that I'm aware of. Maybe if you make a new class (Querydef2) of it.

I would run it on the databases mentioned

in [Contributions]

and those mentioned in [SLXReporting].[dbo].[vw_SLX_ADDRESS],[SLXReporting].[dbo].[vw_SLX_ACCOUNT]

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).

Server: Msg 11, Level 16, State 1, Line 0

General network error. Check your network documentation.

is usually a sign of database corruption.

4-6 terabyte is quite large, but it mostly depends on business requirements. (response, recovery, load, ...)

As you are new to the area, can you contact a consultant?

You might look up...

Recordcount Ado:

Note: This property will return -1 for a forward-only cursor; the actual count for a static or keyset cursor; and -1 or the actual count for a dynamic cursor....

You are using the wrong event. Use ListSelection_SelectedIndexChanged event. But, be careful, because this event fires twice on each selection. Once to deselect the old selection and once to select...

What is the sqlserver version of the datasource?

I've gotten that error sometimes on sql server 7.

(fix, http://www.sqlservercentral.com/articles/Bugs/changingcolumn/618/)

I didn't have problems applying 2187. But is wasn't a cluster environment.

You can see the remaing issues >2187 on http://support.microsoft.com/kb/894905/

No clue why the stored procedure gives the error and the adhoc doesn't.

Is the backupserver on the same build as the prod server? There is a cumulative hotfix 2187

http://www.microsoft.com/downloads/details.aspx?familyid=9c9ab140-bdee-44df-b7a3-e6849297754a&displaylang=en

I personally wouldn't risk adding the index. Unless the documentation tells it never can exceed 900 bytes ( odd, when the fields are larger).

Glad to hear that the hotfix solves the problem.

Until I come up with a better one, it is "the problem has fixed itself"