Here is a link that shows the use of sys.sql_expression_dependencies to list objects referencing a table.

http://blog.sqlauthority.com/2012/12/02/sql-server-find-referenced-or-referencing-object-in-sql-server-using-sys-sql_expression_dependencies/

erlend.miller 3298 - I love the simplicity of your approach! What if we add COALESCE(NULLIF()) to the calculation to take care of the potential divide by zero error if...

According to SQL Server Help these are the ranges:

BIGINT: -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)

INT: -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647)

SMALLINT: -2^15 (-32,768) to 2^15-1 (32,767)

For each of these data types...

Overall I like it. However, please put the "In this issue" or similar back at the top. I have received some excellent information from these e-mails, but not...