Any scheduled jobs?

If you know it happens every hour, you could set up a trace for it in sql profiler.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbcsql/od_odbc_c_99yd.asp

lngResult = SQLConfigDataSource(0, _

                                           ODBC_ADD_SYS_DSN, _

                                           "SQL Server", _

                                           "DSN=" & JDS_DSN_name & Chr(0) & _

                                           "Server=" & JDS_Server_name & Chr(0) & _

                                           "Database=SvCvMarketing" & Chr(0) & _

                                           "UseProcForPrepare=Yes"...

there is a setting ANSI_NULLS ON/OFF

ANSI_NULLS ON -> left join (NULL=NULL) =false

ANSI_NULLS OFF -> left join (NULL=NULL) =TRUE

RTRIM('ABCD ') strips off trailing whitespace

http://www.microsoft.com/technet/abouttn/subscriptions/flash/tips/tips_042705.mspx

Trace flag 2861 causes SQL Server to cache query plans for trivial queries that have a cost of zero or close to zero. SQL Server typically won't cache plans...

The restrict in the JOIN is preferred since it limits the amount of rows the where clause has to process. (like a virtual table)

They do give the same results at...

This is quite simple using the INSERTED (containing updated values) AND DELETED table (containing deleted values)

CREATE TRIGGER TR_UPDATE_ART_INSERT_TO on ARTTABLE

FOR UPDATE /*only updates*/

AS

SET NOCOUNT ON /*reduce unnecessary roundtrip to client*/

INSERT INTO...

SELECT CLASS_ROOM FROM CLASS MyCLASSES WHERE

EXISTS /*return every matching classroom if there is a related class that fullfills the condition; added CM.CLASS_ID=MyCLASSES.CLASS_ID*/

(

SELECT CLASS_ID FROM CLASS_MODULE CM WHERE YEAR = @YEAR AND...

A reason for sucking up additional nt extents instead of using the available place could be the original fillfactor of an index.

If you had an original table with an index...

After you moved you tables do sql server, you'll want to relink the linked tables to the ones on sql server. If you know some vba you can manage it...

My experience with Access:

I'm developing new projects in .NET after using Access 97  for more than 5 years as a frontend to SQL Server and now finally moving on to .NET.

History:

first:...

A wild guess, perhaps a default connection setting is conflicting like ANSI NULLS DEFAULT ON/OFF. Default collation (see the database model)

What is the patch level of sql server 2000? Sp3a...

just to make sure you have everything right on firewall settings http://support.microsoft.com/kb/839279

What is your current connectionstring? Does it use a name or an ip-address?

*outdated post

At work we currently differ the password the application uses to connect to the various servers. (sql authentication at the moment)

dev: login applicationX password applicationTesting

QA: login applicationX password applicationQA

Prod: ...

So...