Archives: December 2009
Following steps happened when sql server starts… we can see that in error log::
1. Build of sql server and platform as Microsoft Sql server 2005 version. Edition on OS.
2. Windows process ID (kid):
3. Error log file location.
4. when last time sql was down and what spid…
Its quite some time that I blog… but good news is I have some good stuff to blog on… so could be you will see some good blog in pipeline soon.
Everyone who wants to know about how transaction replication works and how to improve the performance of transaction replication must read a great blog :
log reader read the transactions(Changes) with sp_replcmds, for xp_replcmds.
then log reader writes into distributor database using sp_MSadd_replcmds
Distributor reads commands using sp_MSget_repl_commands… Read more