August 7, 2003 at 8:14 am
Hi Everyone,
Here's an odd one...I am running a simple select query (in a sproc):
SELECT RTRIM(tblTable.client) as r2tblTable5,
RTRIM(tblTable5.r_clnt) as client,
RTRIM(tblTable.loanno) as loanno,
RTRIM(tblTable.site) as site,
CONVERT(CHAR(10), tblTable.drecord, 101) as drecord,
RTRIM(tblTable.loankey) as loankey,
RTRIM(tblTable2.propstate) as propstate,
CONVERT(CHAR(10),tblTable.dpayoff,101) as dpayoff,
CONVERT(CHAR(10), tblTable.denter, 101) as denter,
CONVERT(CHAR(10), tblTable.dprint, 101) as dprint,
CONVERT(CHAR(10), tblTable.dsigs, 101) as dsigs,
ISNULL(CONVERT(CHAR(10), ISNULL(tblTable.dunlock,tblTable.dpayoff) + tblTable3.days2cmp, 101), ' ') as compdate,
CONVERT(CHAR(10), tblTable.dlock, 101) as dlock,
CONVERT(CHAR(10), tblTable.dunlock, 101) as dunlock,
RTRIM(tblTable.investno) as investno,
CONVERT(CHAR(10), tblTable.dreview, 101) as dreview,
RTRIM(tblTable2.nametag) as nametag,
RTRIM(FFF_download.ibmcode) as countycode,
tblTable3.days2research as days2research,
tblTable3.days2cmp as days2cmp,
CONVERT(CHAR(10),tblTable.dcustom1,101) as ready,
CONVERT(CHAR(10), tblTable.dcustom2, 101) as DOCXmailout,
CONVERT(CHAR(10), tblTable2.dateadded, 101) as dateadded,
CONVERT(decimal(15,2),tblTable2.loanamount) as loanamount,
RTRIM(tblTable2.propaddr) as propaddr,
RTRIM(tblTable2.propcity) as propcity,
RTRIM(tblTable2.propzip) as propzip,
RTRIM(tblTable2.BorrowerVesting) as BorrowerVesting,
RTRIM(tblTable2.lendloanno) as lendloanno,
CONVERT(CHAR(10), tblTable2.ddocdate, 101) as Orig,
RTRIM(tblTable2.taxid) as taxid,
RTRIM(tblTable2.mersid) as mersid,
RTRIM(FFF_Download.slid) as slid,
RTRIM(FFF_Download.custodian) as cuscode,
tblTable.comment as comment,
RTRIM(specialinvestors.processor) as processor,
RTRIM(specialinvestors.invname) as invname,
Convert(CHAR(10), tblTable4.drecord, 101) as RKrecord,
CONVERT(CHAR(10), tblTable4.ddocdate, 101) as ddocdate,
RTRIM(tblTable4.instrument) as instrument,
RTRIM(tblTable4.book) as book,
RTRIM(tblTable4.page) as page
FROM tblTable WITH (NOLOCK)
INNER JOIN tblTable2 WITH (NOLOCK)
ON tblTable.client = tblTable2.client
AND tblTable.loanno = tblTable2.loanno
LEFT OUTER JOIN FFF_download WITH (NOLOCK)
ON tblTable.loankey = FFF_download.loankey
LEFT OUTER JOIN cuslog WITH (NOLOCK)
ON tblTable.loankey = cuslog.loankey
LEFT OUTER JOIN tblTable4 WITH (NOLOCK)
ON tblTable.loankey = tblTable4.loankey
LEFT OUTER JOIN tblTable3 WITH (NOLOCK)
ON tblTable2.propstate = tblTable3.state
AND tblTable2.client = tblTable3.client
LEFT OUTER JOIN tblTable5 WITH (NOLOCK)
ON tblTable.client = tblTable5.client
LEFT OUTER JOIN specialinvestors WITH (NOLOCK)
ON tblTable.client = specialinvestors.client
AND tblTable.investno = specialinvestors.investno
WHERE
(RTRIM(tblTable5.r_clnt) = @RQClientNum
AND RTRIM(tblTable.loanno) = @RQLoanNum)
OPTION (LOOP JOIN);
For some odd reason when executed it makes a call to the master dB and tries to execute sp_sdidebug, which in turn returns a permissions denied error.
Anyone know why this is happening?
Aurora
August 7, 2003 at 8:48 am
Could it debug be turned on?
http://support.microsoft.com/default.aspx?scid=kb;en-us;328151
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply