Yes, the SQL Server 2000 and SQL Server 2005 Client tools can coexist on the same system.  I have had no issues with this on any of my systems.

Either that, or just run it at 6:00 AM to import the file created the previous day at 8:00 AM.

Would it be possible to get the DDL for the tables (including indexes) and the query in question?

Because NULL is not like @GL + '%'.  You are now filtering your result.  If you what all values to meet your filter or where GRPLDR.GLPerson is null, you need...

I concur, as SQL Mail can be flaky at times.

SELECT

'x'

FROM

MyDB1..table1 a

INNER JOIN MyDB2..table2 b ON

a.SubsidiaryNo = b.SubsidiaryNo

is your query, but I don't see a.SubsidiaryNo in any of the indexes for table 1.  This may be why it...

Interesting.  Of course, I've never had to do to what you needed, so I wouldn't have even thought of the NoResees.  something to keep in the back of mind (as...

Can you also post your DDL for the tables involved?

Because the DBCC CheckIdent is not modifying the metadata used to create the table, it is simply resetting the starting seed number to be used for future inserts into the...

How about the DDL for the table(s) and some sample data?

You need to install the ODBC driver on the server.

Try this :

where mb_membership.mbr_renew_date >= dateadd

(mm,datediff(mm,0,