Wow, I just found this extended sproc tonight. I’m pretty estatic about it! xp_servicecontrol allows you to query the status of a windows service. In the past, I’ve used the ‘sc query ‘ via a cmdline. Now I can do it without having to open up a cmd prompt. xp_serviceControl querystate, MSSQLSERVER Other parameters are: [...]
Archive for April, 2008
snapshot error
I performed a snapshot of my publication today with compression turned on, you know, to save some disk space. But I ended up getting an error about: The uncompressed size of the file ‘item_detail_9.bcp’ has exceeded the size limit of ’2147418111′ bytes imposed by SQL Replication’s compression support. To resolved this error, turn off the [...]
Trans Replication :: -maxDeliveredTransactions
In my current environment, I have a push transactional replication and I wanted to find a way to help minimize performance. So came about the -maxDeliveredTransactions. I read the technet article which states: -MaxDeliveredTransactions number_of_transactions Is the maximum number of push or pull transactions applied to Subscribers in one synchronization. A value of 0 indicates [...]