Thank you, I did end up getting this to work and thought I removed my post. Thanks for the post!!

Thank you, Luke. I'll take a look.

Perfect, thanks!

I believe I have this figured out. I had to find the right combination to access the schema on the source.

Now for the second part of my challenge. How should I be able to INSERT into a table associated with the Linked Server?

Again, I can get this to work...

Thank you Sergiy. I came to post my resolution as using OPENQUERY and saw your post. Thanks a lot!

I attempted to apply SP4, but before the wizard start, it pops a message saying the SQL Server is not installed. I have no idea how this was installed,...

Got it, thanks. I just wasnt sure if RTM implied some restrictions around its license agreement.

I appreciate the info.

Thank you very much, I got this working!

Perfect, thank you!

Thanks for the post

Although the actual size of the database is small, the system is growing in both records and users. Peak hours register about 600 - 700 batch...

Thanks for all the info. I appreciate it very much!

Excellent, thank you much!!

Thanks for the response!

I can rearrange so that I only have one Index drive, and three data drives.

I have done some performance monitoring for IO. The difficulty is the...

The initial XML load is RBAR as follows:

CREATE TABLE #tmpXML(PK INT NOT NULL IDENTITY(1,1), ThisLine VARCHAR(500))

...