Is there any single column that would work? While I realize the above was just sample data, if you have a single unique column that would work between the two...

Untested, but this should work for you:

SELECT

 Spanish

 ,English

FROM

 Tbl1

WHERE

 NOT EXISTS (

    SELECT

     1

    FROM

     Tbl2

    WHERE

     Tbl1.Spanish = Tbl2.Spanish

     AND Tbl1.English = Tbl2.English)

Before you go further, if you're not the dba, you really should have them involved, as the possible fixes change system tables.

If it were my box, I'd reapply the service...

Well, that's a bit problematic.

Are you the dba, and have you had any problems during service pack installs? Is the box one that you could reapply a service pack to,...

Are you running this from Query Analyzer, or from an app?

I'm a bit confused as to why SQL isn't finding the procedure, unless there was perhaps something like a...

It should be in your master database under "Extended Stored Procedures" in Enterprise Manager, and I'm pretty sure it should have EXEC privileges set to public.

Can you ensure that it...

The WHERE clause gets handled after the join, so the second query will only show those rows where the s.qty is greater then 50. The first query should return all...

Are you asking about just a straight query typed into Query Analyzer, or a stored procedure that will receive passed parameters for the filter?

I'm guessing the latter, in which case I...

If you know for a fact that they don't have INSERT privileges on the table, but can indeed insert records, another possibility, aside from the Role issue outlined above, is...

It still sounds like your requirements are what I posted about above. Both of the automated methods I outlined are DTS based, and you can pass global_variables to DTSRUN, which...

We usually make large moves like that by detaching, copying, and reattaching, but you could probably get it to work with the Copy SQL Server Objects task, copying everything. The...

Are you wanting to convert to or from EPOCH time? Other than leap second handling (which would probably require a small lookup table), it should be pretty easy if you...

If partitioned views don't meet your needs, then something like the following should work. You'd need to adapt a similar concept for the 12 month, etc. versions, but that should...

Based on this and the problems you are having in your other posts, I'd guess it's a network connectivity issue, and not a true SQL Server problem.

If the network admins...

I found a link documenting the problem to give you the official response.