Do you need to combine or merge two data files (MDF or NDF)? There are a number of complicated options available or you can use the two lines of code below to do the trick... It's up to you. This method works with both SQL Server 2005 and SQL Server 2008.