 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
sqltogo
Joined: 02 Jul 2014 Posts: 38 Country: Netherlands |
|
Beta 7.0.141 - Code refactoring |
|
Testing the newly option to qualify stored procedure names I ran into some strange behavior
Using SQL test code with only a stored procedure works fine, so does with one table
But using a test script with both type of objects it works only partially
SELECT tr.RegionCode, froM T_Region AS tr
EXEC ip_gen_log
SELECT p.PartCode fROM t_part AS p
Depending on the arrangement of lines one or two objects are qualified, but never all three
All objects are in the 'dbo' schema
With thse two lines
EXEC ip_gen_log
EXEC IP_gen_Log
only the first line is qualified with the schema name.
I use Management Studio 2012 for this test sequence
|
|
Mon Jul 14, 2014 4:11 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Thank you. I will reopen the case.
|
|
Mon Jul 14, 2014 11:32 pm |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|