Get table row size

[soumyamathewmca]

How can we get the newly inserted row's size from a SQL Server table?

[deepuv04]

How can we get the newly inserted row's size from a SQL Server table?

select
sys.objects.[name],
sys.objects.[object_id],
count(sys.colum ns.[name]) As ColumnCount,
sum(sys.columns .max_length) As MaxLength
from
sys.objects
inner join sys.columns on sys.objects.obj ect_id = sys.columns.obj ect_id
where
sys.objects.[name] = Table_Name
group by
sys.objects.[name],
sys.objects.[object_id]