I was interested to learn more on how tables are structured in accounting system. Googling around got me this: Method The Standard Accounting method in not-so-primitive countries is this. The “best practice”, if you will, in others. This method applies to any system that has similar operations; needs; historic monthly figures vs current-month requirements, such
SELECT sys.objects.object_id, sys.schemas.name AS [Schema], sys.objects.name AS Object_Name, sys.objects.type_desc AS [Type] FROM sys.sql_modules (NOLOCK) INNER JOIN sys.objects (NOLOCK) ON sys.sql_modules.object_id = sys.objects.object_id INNER JOIN sys.schemas (NOLOCK) ON sys.objects.schema_id = sys.schemas.schema_id WHERE sys.sql_modules.definition COLLATE SQL_Latin1_General_CP1_CI_AS LIKE ‘%Column_Name%’ ESCAPE ‘\’ ORDER BY sys.objects.type_desc, sys.schemas.name, sys.objects.name Replace Column_Name with intended search string.