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
Showing posts with label filegroup. Show all posts
Showing posts with label filegroup. Show all posts
Friday, March 9, 2012
Subscribe to:
Posts (Atom)