If this is not a "one-time" backup... then I agree with Simon on this. Create a new filegroup (Properties tab of the database) and a new file (.NDF). ...

Yeah, I could ping the server and even ping to resolve the DNS. It just wasn't passing the port. For some reason... this goofy thing did not set...

Unfortunately no... the SysAdmin-types don't want to change the port number.

Thanks for the response Patrick. Yes, I am very sure. The DB was set up prior to my life here. No matter... it does work quite well...

Here is what I have done so far.

/*

This code creates a cursor for the specific data_ob where rec_type = 'F'.

It also create a nested cursor of the fiscal_month to check...

Actually, there are no records to insert from the source. I am creating the records with the next available 'Month' number (i.e. Month 05 has activity, Month 06...

Thank you for your response. Are you having any issues with the SQL Server BI Dev tool (for SSIS package creation)?

Steve... it never ceases to amaze me the lengths that you go to provide us every bit of information needed to keep our 'sanity' and the information needed for us...

All,

     Thanks for the responces... I'll try to answer (or give more info) within this one reply.

      ALL of the triggers MUST be replicated.  This environment is an extreme case...

Have you checked the obvious tools yet (i.e. Event Logs, SQL Error Log, etc.) on both servers to see if maybe you are having NIC issues?

Scottye

Thanks... you were right.  Not to mention the fact that I had a whole plethora of other issues with trying to sum that one copmun based on spedific criteria.  I...

Greg,

    Since SQL Mail and SQL Agent Mail are MAPI bound, the only thing that I could suggest is researching another MAPI driven mail client and using it.  You aren't...