General information
Forum:
Microsoft SQL Server
Category:
Database management
Check the sysfiles system table and sysobjects.
The below query lists all objects on a particular file group.
select name from sysobjects
where id in (select id from sysindexes
where name = 'data file name')
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only