Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alejo46
Posting Yak Master
157 Posts |
 Posted - 2010-04-10 : 16:59:09
|
| Good afternoonI need your help.In SQL_SERVER for query Analizer, is there any store procedure system that given any table(s) name returns the filegroup that/those table(s) belongs? OR i have to script.I know that in Enterprise Manager or using SSMO (SQLSERVER 2008) i could find what i want, but it woul be interesting to know if threre is a sp o T-SQL command.Thanks four your support |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
sto. proced. to find a filegroup for a given table