consolidate two data files

How can I combine two data files (i.e .mdf and .ndf). We had two data file in our old server due to disk limitation. In the new server we don't have such limitation so we like to consolidate the two file in one. What is the best way to accomplish that?
ThanksFollow this:
http://groups.google.com.au/group/microsoft.public.sqlserver.server/browse_thread/thread/d7fa8af9c5ca5ca/71636c29fdf2666c%2371636c29fdf2666csqlsql

Connection Thru Internet

Hello again pals, i meet you again to ask an old question i had, but no found answer.

Can i connect to a remote SQL Server thru Internet, lets say from a client like Query Analyzer?

I read to make it using a VPN, but i try to configure it and cant get connected.

I'm using a Win2000 Server or Win2003 Server,

Thanksfull!!!!

There is many people asking for that, i start to think it cant be done! :'(If you are using virtual private networking (VPN) to get onto the network where the SQL Server resides, yes you can access a SQL Server throught the internet. You need a router that allows for VPN, there is some configuration to do here and depending on your SQL authentication method, you are going to either have to setup accounts for the users NT logins(windows authentication) or setup user names and passwords for these users. Do'nt forget to assign them permissions within SQL as well.|||If you are using virtual private networking (VPN)

There is no other way to do it, without using VPN?, it has been a headache to try configure it!

Thanks for your help Thrasymachus, is well received|||This is the only way I can think of if you want use the QA to access the data. You can always create an online interface to do what your users need but it sounds like they need a lot of access.|||If you know how to Telnet and use OSQL you can query your database from the command line|||If you make the ports that your server is listening on open to the internet you could connect directly. If you are using QA though I'd think you were doing some administrative tasks. You really shouldn't open up access to your server to the internet unless it's absolutely neccessary. If you can use a VPN, do it.|||Another way would be to set up port forwarding. But again it's as unsecure as directly exposing the server.

connection string in the SQL Server Management Studio Express

i want to change the database from access to SQL Server Management Studio Express

the old connection string in the asp is
<%
Set strConn = Server.CreateObject("Adodb.Connection")
Provider="provider=microsoft.jet.oledb.4.0;"
dbpath="data source=" & Server.MapPath("../data.mdb")
Pwd = ";jet oledb:database password=dolunlimit"
strConn.open provider & dbpath & Pwd
%>

i have write the new connection in the SQL server, but it can not work

<%
Set conn=CreateObject ("adodb.connection")
strConn="driver={SQL Server};server=192.168.0.102;uid=sa;Pwd=sa;database=sadb"
conn.open strConn
Set rs=CreateObject("adodb.recordset")
%>

can someone tell me what wrong of my coding

Tryhttp://www.connectionstrings.com for connection string help. Also, these forums are for ASP.NET-related questions, not classic ASP.