Indeed, the select into is faster in the example

Select into: avg 1-2 seconds

Table 'Worktable'. Scan count 201, logical reads 6574, physical reads 0, read-ahead reads 0.

Table 'jbmTest'. Scan count 0,...

Can you modify the job to include some additional logging?

Like a ping/tracert log to a textfile before launching the small app?

Odd, perhaps a change in the executionplan? You can see the actual plan in the query analyzer.

I guess count(*) or avg(*) give an index scan when min,max use index seek(should...

The main problem SELECT INTO is that is locks sysobjects (especially in tempdb) when lots of procedures make use of temporary tables having to wait until the insert is finished....

Have you already converted your (var)char columns to n(var)char?

Wildly guessing:

UTF-8 isn't implemented in sql server 2000

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

Working of unicode in ODBC

http://www.datadirect.com/developer/odbc/unicode/index.ssp

Also try to replace SELECT INTO statements

into CREATE TABLE ... INSERT INTO.

Select Into holds some exclusive locks on system tables.

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1284087,00.html

RAISERROR severity 16 usually stops the processing. (no sysadmin permissions needed)

Instead of the option WITH LOG you can use another logtable?

Could also be datagrowth

Have you tried

sp_changedbowner [ @loginame = ] 'login'

[ , [ @map = ] remap_alias_flag ]

Arguments

[@loginame =] 'login'

Is the login ID of the new owner...

You have to restore a full backup with the option no recovery / standby as a base (so it doesn't rollback incomplete transactions and additional restores can be done). After...

have a look at

http://www.sqlservercentral.com/Forums/Topic225872-5-1.aspx#bm225893

there error there is also invalid switch

I would first try to find out what it does and why. Is the reasoning still valid or could be it done better or in another way. Document it and...

It could be that Access decides to pull the whole table in and than doing the find.

Usually it worth creating an extra "query" (on the linked table?) to search for...

You might be able to do that with "cross-database ownership chaining".

It is in the security tab of the server.

Beware of the security risk:

http://www.sqlservercentral.com/articles/Security/2633/

ericwilson54 (12/5/2007)

---

One of my maintenance plans is failing consistantly. The db in question is on a drive with 175 GB of free space. I have pasted the text...