title: See what data is in what SQL Server data file?
body: <p>At one point my data drive on my SQL Server server was about to run out of space so I had to add a second file to the PRIMARY data group and put a limit on the growth of the first file.  That caused new data to go into the second file, which is good.  Now I'd like to know which tables have data in the first file so that I can know which tables will be locked when I migrate that data over to the second file.  Is there a way to view this?</p>