Incorrect field attributes v7.0.0.52

• 
  Hi Jeff,
  
  What version of SQL Server are you running this against? Is the data warehouse running a specific edition of SQL Server?
  
  Best regards,
  
  David

  David Priddle October 22, 2015 05:15

  - 0 +
• 
  It is SQL Server 2014 running SSMS 12.0.2000.8
  
  Edit: Sorry I was mistaken. It is Windows 2008 R2 Running SQL Server 2012 Standard Edition Version 11.0.5556.

  Jeff Newswanger October 22, 2015 08:05

  - 0 +
• 
  Hi Jeff,
  
  Does this happen before you execute the creation script? Is it incorrect for all of the non-nullable columns in that table?
  
  And just to make sure, does the tooltip look like this:
  
  
  
  Best regards,
  
  David

  David Priddle October 23, 2015 02:55

  - 0 +
• 
  Hi David,
  
  Yes the tool tip does look like that. I have been unable to recreate this since the original. I only saw it for the one column but since I haven't been able to recreate, I cannot tell when it is happening and whether or not it is the entire table or just that column.
  
  It isn't actually happening when I create the tables, this is our ERP tables so they are already created.
  
  I'm just wondering if this was a freak thing.
  
  Top one is looking at table, second is query
  
  
  
  
  
  Thanks
  Jeff

  Jeff Newswanger November 02, 2015 08:32

  - 0 +
• 
  Hi Jeff,
  
  Very strange. If SQL Prompt isn't guessing the nullability from CREATE statements in the same script, it gets the data straight out of SQL Server.
  
  Could there be a chance that you refreshed SQL Prompt's cache after someone had made a nullability change on that column, but not refreshed SSMS's object explorer, so that there was a difference?
  
  Best regards,
  
  David

  David Priddle November 02, 2015 08:46

  - 0 +

Add comment

Please sign in to leave a comment.