Microsoft has announced that Azure Data Studio (ADS) will be retired on February 28, 2026.

While it ADS works for now, Microsoft is moving to VS Code with the SQL Server...

Microsoft has announced that Azure Data Studio (ADS) will be retired on February 28, 2026.

While this will work for now. MSFT is migrating to VS Code, which is nearly the...

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...

Yes, it's a problem. I submitted an item on Connect

https://connect.microsoft.com/SQLServer/feedback/details/398203/sp-rename-doesnt-change-the-text-of-udfs-or-procs-sp-helptext-then-returns-a-script-with-the-old-name

and it was classified as "Won't Fix"

It's something we're going to have to live with.

Regards,

Andy

Andrew Novick

SQL Server MVP

http://www.NovickSoftware.com

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....

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...