问:
我想把每天数据库的大小自动保存到table中
但是exec sp_spaceused是返回2个表,执行下面的语句出错,如何解决?
drop table db_size go create table dbo.db_size ( database_name varchar(200), database_size varchar(200), unallocated_space varchar(200) ) go insert into db_size exec sp_spaceused
exec sp_spaceused始终返回两个结果集,导致报错:
--------------------------------------------------------- Server: Msg 213, Level 16, State 7, Procedure sp_spaceused, Line 196 Insert Error: Column name or number of supplied values does not match table definition.
答: