Can you check if any connections are left open? Maybe there is one with a transaction left open/select pending. (last batchtime in the weeked)

For a custom temporary db, perhaps you...

Make sure the bit-field doesn't allow nulls

Not sure if it may help. I've created a querydef that called a stored procedure. The access-reports recordsource would be then that querydef. Not sure if I've layered another querydef...

Naming in Oracle is a little different.

Try

select count(*) from [linked_servername]..[OracleSchemaName].[Viewname].

Buran Kumar Tiwari,

Can you make a seperate topic of the issue with CSV-Excel, eventually with a link to this post? The logdates showing as 00.00.0, are they displayed as real-dates...

a word-document how to set up an oracle linked server:

http://www.ed.uiuc.edu/datamasters/Documents/GEN_SQLServerOracleLinkedServer.doc

the microsoft way:

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

seems sql 2000 comparision got replaced with the 2005 version

from the books online (2000)

Features Supported by the Editions of SQL Server 2000

This topic summarizes the features that the different editions...

DELETE ABCD

FROM ABCD

INNER JOIN

(

SELECT ACCTNO,MAX(LOTDATE)  AS MAX_DATE

FROM ABCD

GROUP BY ACCTNO

) AS MOST_RECENT

ON MOST_RECENT.ACCTNO=ABCD.ACCTNO

AND ABCD.LOTDATE<MOST_RECENT.MAX_DATE

should do it

Normally you can't remove a login when it owns some objects. (Test it first.)

You will need to install the oracle drivers on the sql server machine. A restart of sql server is than necessary.

Can't find the microsoft page immediately.

a list of performance differences:

http://www.sql-server-performance.com/q&a98.asp

Enterprise edition is required for clustering, built-in logshipping, access to more cpu & memory.

Under what account is sqlagent running? Local system account (no network) or another? Does it work if you give the command instead of the job?

Why are you resorting to administrative...

Were the test performed straight on the server (to eliminate network congestions)? Can you conduct some more tests ( about 1000...).Were there any caches freed (DBCC FREEPROCCACHE)? Statistics are up...

I'm lately facing locking too. For one particulary table it was solved by changing the clustered index.

There is an option hidden in outlook to automatically wrap lines longer than ... for unformatted email.

Can be found at extra->options->email-layout->message layout->internet layout->Options for unformatted text->automatically wrap when line is...