May be this needs another topic. I am just wondering since the row size is 8060. What is the point in having a column with 8000 unless it...

Well it IS!! -- from performance stand point

The problem comes when you give someone the power to delete all child records from all...

A word of caution here:

If you plan to modify in anyway that data try to see if you really need more than 8000 because you can learn the hard way...

Don't worry I have had my Lack of caffeine more than once too as...

govinn,

Vasc is correct!!

When you perform a left outer join and  the table column where the join can't  the two tables you get a null  if you then specify the IS NULL...

Make sure you have indexes on : [Baseball65K50].[Col007]  and  [Baseball65K24].[Col005]

By the way I hope you are just testing and that those are not final column names!!!

I don't like about open row sets is the login information

You could use integrated security instead of SQL and then you don't need to embed loging info!!!

select * from openrowset('SQLOLEDB','Trusted_connection=yes;Data...

I really admire your consistency and modesty!

I have seen very good suggestions coming from you and I am not afraid to tell you

I would think that at these times you will probably be the only guru around 

Do I need to do this on both SQL Servers? Or is putting it on one enough?

Linked server needs to be present on the server where you are going to submit...

SUSHILA!!!

What are you doing in SSC at these hours?

Jacob,

Sorry I got back a little late but I tend to finish everything that I start

Take a look a this part of...

it comes very handy in Inventory control systems but you have to be really careful and make sure all DML access is through SP because it can get ugly very...

Still missing Categories

I did but it takes time be patient!