Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
2523Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?
2 4725
Where can you find the error log information? : sql server database administration
What to perform pattern match with the like operator?
What is user-defined function?
Explain the use of containers in ssis?
How to get a list all databases on the sql server?
What are truncate options available in sql server? : sql server database administration
What is default constraint?
What are unicode character string data types in ms sql server?
Can select statements be used on views in ms sql server?
User wants only to display only pdf as export option in report manager. How to achieve this?
How to find the service pack installed? : sql server database administration
Explain the stored procedure?
What is RMS migrations?
What are subquery and its properties?
what is the sql equivaent of the dataset relation object ?