OBJECT_DEFINITION Function Not Supported

• 
  Hello Dave,

  Can you send us a screenshot of the issue as well as more details on how you run into it?

  
  

  We have tried replicating the issue using the following script, but we weren't successful in doing so:

  
  GO
  SELECT OBJECT_DEFINITION(OBJECT_ID(N'sys.sp_columns')) AS [Object Definition];
  GOUSE AdventureWorks2012;

  Thanks!
  

  
  

  squigley November 01, 2019 17:02

  - 0 +
• 
  The function call is part of a larger WHERE clause and looks like this:
  

  OR (
     [referenced].[referenced_minor_name] IS NULL
     AND [OBJECT_DEFINITION](OBJECT_ID(referencing_schema_name + '.' + referencing_entity_name)) LIKE '%' + @ColumnName + '%'
     )</code>OR (
     [referenced].[referenced_minor_name] IS NULL
     AND OBJECT_DEFINITION(OBJECT_ID(referencing_schema_name + '.' + referencing_entity_name)) LIKE '%' + @ColumnName + '%'
     )
  </pre><div>Because of this, code suggestions, etc. do not work in this file until I comment it out, or "Format Code" which turns it into this:<br><pre class="CodeBlock"><code>

  Note the brackets around the function name; this is obviously not correct either. The other erratic behavior I can't demonstrate in a forum post.
  

  Dave Pendleton November 01, 2019 22:55

  - 0 +
• 
  Hello Dave,

  Thanks for those additional details. I did some further testing on my end and I was only able to encounter issues, specifically with the square brackets, when running on an Azure SQL Database.

  
  

  Can you confirm if that's where you're running this on your end? It would make sense if you're running into issues then as we don't currently support SQL Prompt with Azure.
  

  squigley November 20, 2019 15:08

  - 0 +
• 
  OBJECT_DEFINITION is not an Azure-specific function.

  Dave Pendleton November 20, 2019 16:10

  - 0 +
• 
  Hello Dave,
  Can you confirm if you're running Azure SQL Database and if so, are you running into this issue on said Azure instance? Or is this on a standalone SQL Server Instance?
  

  squigley November 25, 2019 14:58

  - 0 +
• 
  Both.

  Dave Pendleton November 25, 2019 15:13

  - 0 +
• 
  Hello Dave,

  Can you let us know what version of SQL Server that you're encountering this issue under? We were only able to encounter this issue on Azure SQL Database from our end and couldn't replicate it with our initial tests on our standalone SQL Server instances.
  

  squigley November 28, 2019 10:22

  - 0 +

Add comment

Please sign in to leave a comment.