Is there anyway to find out what tables are in a particular filegroup in SQL2000 apart from running sp_help {tblnm}?You could use undocumented stored procedure...
declare @.id int
set @.i = object_id('mytb')
exec sp_objectfilegroup @.i
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment