February 03, 2011

SQL server DBA Frequently used Checklists

1. how to check msdtc status on sql server 2005 server

i) Go to Services.msc and start Distributed Transaction Coordinator

ii)Go to Dcomcnfg.exe
My Computer -> Properties -> MSDTC Tab -> Security Configuration
Network DTC Access is checked
Network Administration is checked
Network Transactions is checked
Network Clients is checked
XA Transactions is checked

2.
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Stop Memorizing SQL Part 3 : A Practical SQL Cheat Sheet for Beginners

 A Practical SQL Cheat Sheet for Beginners When learning SQL, students often struggle to remember the correct syntax during exams or practic...

  • Oracle Scheduled Jobs
    1. To change the scheduled time of oracle job and force it to run at certain time, use the set_scheduler_attribute procedure.e.g. To start j...
  • Move distribution database to another drive
    Move distribution database to another drive: There are scenarios in SQL server Replication that we need to move datafiles and logfiles of di...
  • Pros and Cons of stored procedures
    * Stored procedures generally result in improved performance because the database can optimize the data access plan used by the procedure an...