Explain some DBCC commands?

Answer Posted / varun

dbcc opentran,dbcc inputbuffer,dbcc outputbuffer.

Is This Answer Correct ?    9 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How retrieve field names from the table in SQL through JAVA code?

1403


What is extended stored procedures?

571


Explain log shipping?

589


How to drop an existing stored procedure in ms sql server?

548


How do I manually uninstall an instance of sql server 2016?

550






You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1726


What is transaction server distributed transaction?

561


What is difference between materialized view and view?

492


Where do you find the default Index fill factor and how to change it?

606


What are the advantages of using third-party tools?

556


What sql server means?

564


How to add a new column to an existing table with "alter table ... Add" in ms sql server?

578


What command do we use to rename a db, a table and a column?

506


How to find the service pack installed? : sql server database administration

554


What is raid, and how it can influence database performance?

580