Viewing 4 posts - 1 through 4 (of 4 total)
Invalid Pseudocolumn refers to using a variable with the $ that is not one of the recognized pseudocolumns such as $rowguid, $identity or $partition.
And yes, it looks like a coding...
November 10, 2011 at 10:56 am
Yes, it's a problem. I submitted an item on Connect
and it was classified as "Won't Fix"
It's something we're going to have to live with.
SQL Server MVP
October 9, 2010 at 1:51 pm
This is pretty well done.
I do have a suggestion for an alternative that uses only one db.
You could do the ETL into different tables instead of different databases....
March 6, 2008 at 6:03 pm
There's no need to "cheat" and use the syscolumns and sysobjects tables. While INFORMATION_SCHEMA doesn't have the information on identity columns, they OBJECTPROPERTY(<objectid>, 'TableHasIdentity') function tells you which tables have...
April 2, 2006 at 6:54 am