Thank you for your replies, the issue is that this script is from a third party software, there is no way to remove the select, are you aware of any...

hi is this possible with sql login as well? or is it only possible with windows logins?

Thanks gila!

hi , yes all subscribers were up to date. I rebooted distributor and that fixed my problem. 🙂

i understand.. Thank you!

i am sorry now i am confused why for both?, are the tcp port and dynamic port different?

it is a named instance

thanks for prompt answer, when i go to SQL Server Network Configuration , IP address Tab, under IPALL:

TCPDynamicPort 53244

TCP Port is blank

when i run...

thank you all, i had to restart service, the CPU and IOs kept increasing and we started having performance issues.

thanks Gila, i checked select * from master..sysprocesses

where status = 'runnable'

order by CPU

desc

and this spid is in the top cpu column utilizing 298787621.

also when i run SELECT *

FROM sys.dm_exec_requests

order...

i just checked running kill 55 with statusonly

and i get :

SPID 55: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.

but it has been...

thanks Gila, can this spid create any issues if it remains running for a couple of hours? blocking , high cpu , etc? or since it is in hung...

thanks again 🙂

thank you so much!, so once i specify that schema option, the column in my subscriber will still be replicated just without the sparse?

is this something that the sp_addarticle has a default in sql 2008? I did not specify that when adding the article, this is the script i executed:

exec sp_addarticle...