If it is Crystal or MS-Access, you should see it in the Application or ProgramName column of one of: EnterpriseMgr, sp_who2, sysprocesses.

Or you can also run Profiler to catch this...

When MSAccess links tables with ODBC DSN, some info is extracted from the DSN and stored in the 'table'(link) properties. If anything changes on the DSN, the table properties...

I believed (I dont deal with these issues a lot) that SQLServer should never have significant Memory:PageFaults -- because it should be managing the available physical memory with its own...

I have considered this some time ago, and basically concluded you cannot get stats on such functions (multi-statement table-valued functions).

If you do a "Show Query Plan" on something like

Select id...

I have had something similar with Desktop edition sql2000 with win2000. Several people had freezes up to 30sec. Our databases are about 6GB.

I hardly ever have EM open....

I was dissappointed that this article didn't touch on the sort of dramas I've experienced with moving DTS packages between servers.

Once you move a DTS package, you might have to...