SQL Server also creates a row in the sysobjects table, as it does for most database objects. The problem arises when you rename the object in Enterprise Manager or with the sp_rename stored procedure.

Built on the .Net platform, xSQL Object 1.5 supports SQL Server 2000 and requires .Net Framework 1.1 or later. Pricing starts at $199 for a single-user license; $499 for a 5-user license; and $999 ...

In a previous Practical .NET column I showed how to retrieve rows that hold JSON objects by querying on values in those objects’ properties. However, sometimes you’ll want to work with the complete ...

Converting JSON Objects to Relational Tables: Flattening the Object. Here's how you can use SQL Server's OpenJson function to dismantle JSON structures into relational tables targeting either ...