Never mind I figured it out.

The key is in the Restore Object ReadFileList method.

Thsi Ex. Worked for me, based on Andy Warrens code except added ReadFileList

Hope it helps.

--------------------------Code

Private Sub Form_Load()

Call...

The problem you are running into is you must include the logical file names of the original files and the path of the new files to get restore to work.

Ex....

Looks like an issue with network latency, what connections type are your using and have you tried PINGing the server from the box with the issue. Also make sure is...

I agree, you may also want to use Profiler to tarce both boxes to see if anything unusual is occurring.

"Don't roll your eyes at me. I will tape them in...

What happens when you do this from cmp prompt? How about QA?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

As you state this is merge replication and it could potentially be a timeout issue. I saw a statement in another thread about the rowguid column and that you should...

I have to agree with Andy, since this is set at the session level it makes it harder to see, and there is no direct variable that will give this...

I would think if you installed SQL 2000 with more than one processor that you have license for that and since AS is part of SQL 2000 you have the...

Likes are naturally slower anyway but do perform better if you can avoid doing LIKE '%something%' and instead doing LIKE 'something%'. The only faster thing but adds a lot of...

Check out http://support.microsoft.com/default.aspx?scid=kb;en-us;Q75191 this should still apply.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

I have never seen names quoted in cmd line like this

SET @TheCommand = 'dtsrun /S "W2KS-SQL" /E /N "ImportInfoHos"'

Try

SET @TheCommand = 'dtsrun /S W2KS-SQL /E /N ImportInfoHos'

This has always worked...

I am not sure I follow are you saying that your trigger fires and does not handle all the updates in a multirow UPDATE or does, can you explain better?...

When checks for a true statement. Case is more like a SELECT statement in VB. This will work for you.

CASE

WHEN @mv_int > 7 THEN 'Yes'

ELSE 'No'

END

"Don't roll your eyes at...

From SQL BOL

quote:

---

timestamp

The SQL Server timestamp data type has nothing to do with times or dates. SQL Server timestamps are binary...

Right you want dbo to own (preferably) all objects in the database so that the ownership chain is easy to work with and your not changing between owner schemas (which...