Home Forums SQL Server 2008 SQL Server Newbies table sizes for all d/b on the server RE: table sizes for all d/b on the server
RightOnTarget
Hall of Fame
Points: 3041
More actions
August 23, 2012 at 3:22 pm
#1529476
so it only needs to exist in master?
because at the moment it's in master and in one of other d/bs
use [master]
go
select *
from sys.objects
where name = 'sp_spaceused2'