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 4727
What is change data capture (cdc) in sql server 2008?
Define Wed Edition in SQL Azure?
What do you understand by a stored procedure?
Your table has a large character field there are queries that use this field in their search clause what should you do?
How can change procedure in sql server?
How to convert binary strings into integers in ms sql server?
In which format does an image save in SQL Server database ?
Can sub report data source be different from that of the parent report?
Explain how dts is used to extract, transform and consolidate data?
What are the different types of backups avaialabe in sql server 2005?
explain databases and sql server databases architecture? : Sql server database administration
What is the significance of null value and why should we avoid permitting null values?
What is enhanced database mirroring in sql server 2008?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
Explain the purpose of indexes?