Dissin' the Raider Nation...just not right!

Too early on a Monday for this.

This script appears to make short work of a problem we experience. However, I can not be sure since it calls '[dbo].[uf_AR_EndPrd_Date]())' which I do not have to make use...

Thank you both for your replies. I just had never seen an instance where this happened to occur, usually policy states 3 letter aliases. this user was recently brought in...

Thanks for the reply. upon reading it I realize my sample was not as complete or accurate as I had hoped. Here is the actual code:

SELECTDISTINCT

l.lgh_number,

o.mov_number

FROM orderheader o

INNER JOIN legheader...

Lynn-

I appreciate the advice and the help you offered on this topic, after further review it seems to be a known, old but known issue with the difference between the...

I have user databases numbered beginning at 5, system databases respectively are:

1- master

2- tempdb

3- model

4- msdb

5- starts user created dbs

so maybe dbid >4?

After exchanging questions with J.T. this morning I am including the information as additonal information...

Since the SID column is the SID of the db creator this column may not be useful...

Right-click a database, go to TASKS, to GENERATE SCRIPTS, this gets you the Script Wizard, click NEXT, choose a DB, NEXT, Script Behavior is about 6 or 7 rows down, click...

Could there be index hints forcing the plan to be built poorly that need removed? Statistics won't help a bad plan being built if the code is forcing a path...