Viewing 8 posts - 1 through 8 (of 8 total)
Tara Kizer (7/9/2010)
I guess I assumed that the dynamic SQL was being used for something that the OP wasn't showing us.
dynamic SQL effected!
thanks a lot!
The detail is like this:
declare @sql...
July 11, 2010 at 9:43 pm
Tara Kizer (7/8/2010)
You need to use a temp table instead of a table variable.
temp table and table variable will cause the same error.
thanks for your reply!
July 8, 2010 at 8:03 pm
Kendal's last answer is what I after!
Thanks to you ,thanks to all .
July 8, 2010 at 1:19 am
Now,I use system SP :sp_replmonitorhelppublication,that seems work ,but another question comes,this three column is all 'NULL':
worst_latencybest_latencyaverage_latency
NULL ...
July 7, 2010 at 8:21 pm
may be related to the number of rows in the table ?when rows is small,it will not affect,but ,when rows is much ,it will affect.
November 17, 2009 at 7:52 pm
Now ,i think ,it is the program of client caused this problem :because ,I have 3 DBserver with the same configuration ,
only one will occur which client program is different...
May 3, 2009 at 8:33 pm
my sp is sp3.thank you.
April 28, 2009 at 6:19 am
Viewing 8 posts - 1 through 8 (of 8 total)