Author |
Message |
maxpesola
Joined: 26 Nov 2007 Posts: 51
|
|
Sql copy problem with 4.6.10.0 |
|
I've a problem when i copy from the "show store procedure code" window (with the ctrl key) , even if i select all and i copy (or i use the special button to copy), it's not copied everything but only some rows (for example , a sp of 705 rows , only 188 are copied).
Sql server management studio 2005 client sp3 on sql server 2000 , winxp sp3 , sql assistant updated by "automatic updates"
|
|
Tue Mar 10, 2009 9:47 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7966
|
|
|
|
Does this happen for all procedures or just one particular procedure?
|
|
Tue Mar 10, 2009 11:06 am |
|
 |
maxpesola
Joined: 26 Nov 2007 Posts: 51
|
|
|
|
 |
 |
Does this happen for all procedures or just one particular procedure? |
It does not happen with all the procedures but i've found , for now , two sps with this problem, an other one has 809 rows but sqla copied 490 rows only, it's difficult to understand why only some have the problem...
|
|
Tue Mar 10, 2009 1:20 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7966
|
|
|
|
We are looking into this. Here is our tracking number for this issue #3869
|
|
Tue Mar 10, 2009 11:41 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7966
|
|
|
|
One more thing, does it happen after you open those procedures in Sql Server Management Studio 2005 and recompile them?
|
|
Tue Mar 10, 2009 11:43 pm |
|
 |
maxpesola
Joined: 26 Nov 2007 Posts: 51
|
|
|
|
 |
 |
One more thing, does it happen after you open those procedures in Sql Server Management Studio 2005 and recompile them? |
It happens always with those sps, I tried a recompilation (and after the "refresh cache" of sqla) but the problem remains.
|
|
Wed Mar 11, 2009 5:57 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7966
|
|
|
|
This issue has been fixed in 4.6.12
|
|
Tue Mar 17, 2009 10:36 pm |
|
 |
|