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)

Fashion Catalog Similarity Search using Datastax AstraDB Vector Database

DataStax Astra DB's vector database capabilities can be leveraged to build an efficient fashion catalog similarity search, enabling user...

  • 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...