they dont appear to be doing the same thing. I've found that full outer joins are very intense.

You may want to beak it up into multiple querries. That's what i...

ok. thanks guys. i will have to play around w/ sp_executesql and pass in some params and see what happens.

Moring guys. I see this thread has been quite the topic. I thought about this last night and determined that i understand where your coming from Lynn. I've been doing...

Lynn I do apologize for my comment to Roy. I also apologize for making an improper assumption about you gender. It was not intentional even though it sounded that way.

Lynn,...

My recommendation, though I have a feeling you won't take it, would be to refrain from sarcastic remarks in the future.

-- Kit

===========================================================================

I will do my best to take your...

You're right, we are. And we also can decide who we will help and who we won't.

Bye.

Lynn Pettis

===========================================================================

Food for thought and I think this is something we should all think...

this was resolved....

=====================================================================

SELECT name

FROM sys.tables t

WHERE t.is_ms_shipped = 0

AND object_ID NOT IN ( SELECT ...

=====================================================================

SELECT name

FROM sys.tables t

WHERE t.is_ms_shipped = 0

AND object_ID NOT IN ( SELECT major_ID

...

i suppose everyone is entitled to their own opinion.

dont think that will work because they actually of table type "user"

WayneS that's actually how i initially implimented it. However it did not work in all instances. unfortunatly. I'm going to triple check and get back to you. Attached kinda gives...

Comment removed by the editor.

from what i can tell there's nothing in the sys.tables nor sysobjects that flags these tables.

=======================================================================

That's because they are classified user tables. Try

WHERE OBJECTPROPERTY(id, N'IsMSShipped') = 0

If that doesn't work, can you explain what tables you do what to see and what tables you don't...

So i had the whole proces built then found later that those unwanted tables are being returned and i'm having a bear of a time fionding a way to isolate...