I use PSPad as replacement of notepad. It is better than Notepad++ in my opinion. Works very well and supports incremental search, the feature I use a lot.

Piotr

Is that login set up in linked server properties? Does by any chance that login and password for Oracle match your SQL login?

Piotr

Are these objects created with SCHEMABINDING clause? You have to script them, drop them, change db collation and recreate them from script.

What is collation of the tempdb database? If it...

So it was a 64bit drivers issue.

Piotr

Open properties of the linked server and look on the Security tab. There on the bottom of dialog, there are four options related to connection credentials. If you have selected...

Then it seems that you have to compare them and look for differences. I had this kind of error when provider was not available for 64bit.

HTH

Piotr

Most likely you don't have 64bit drivers to that OLEDB source/destination.

Regards

Piotr

You can configure connection encryption, look for "encryption [SQL Server], connections" in BOL.

HTH

Piotr

Thanks Matt,

I couldn't shake off my head that this WHERE id IS NOT NULL is the right approach. I know about ansi_nulls off/on more that I'd wish 😉

Might be interesting...

I believe you have nulls in tblB. If not in encounters null, the whole WHERE is yielding UNKNOWN, thus no records are returned.

Look at this sample code:

create table tblA(id int)

create...

Hi,

You don't have to use cursor, there are better options.

Look at the OUTPUT clause in BOL.

Here's a small example I wrote. I assume that since you mentioned autogenerated field...

Do they have any SSMS plugins installed? They also tend to screw things sometimes.

Piotr

There should be some error code, severity state.. Please check them. Check SQL Server log files and application log.

Piotr

Check database collation. it is the collation that enforces you to use proper case.

I think the best way is to normalize data and put number of 4's 5's and 6's in a record referenced by foreign key (FID, PID). There should be only...