Does this work on SQL 2008?

I am getting the following error.

Any help is appreciated.

Thanks

Msg 451, Level 16, State 1, Procedure sp_DBA_spaceused_AllTables2, Line 49

Cannot resolve collation conflict for column 2 in...

I suppose this Seq column is a logical column. How ever I would love to see answers to both logical and physical since I am experimenting.

Oh I got your point. Sorry I was dumb not figuring out this is 2005. Any way would it prevent you posting the answer? or should I post the question...

Well the back end is SQL 2000 not SQL 2005

thanks!

I think I figured out from your hint

Following modification is working

Please let me know if I am wrong --thanks

SELECT

UserRole.UserID,

UserRole.RoleID

FROM UserRole

LEFT OUTER JOIN (SELECT...

Hi Lowel,

Thanks for the quick response.

I think you are very close,

You query resulting two recods

11

45

Role 5 is associated to user 4 so it should be eliminated

Any Idea?

Hey andyj93

How did you get rid of the three part naming in the tranformation?

I have the source from ODBC AS400 and destination...

I was able to do this.

Have two cards with different IPs(each from seperate switches) and two DNS entires. One for Main server name point to first address and the other alias...