DBCC checkdb is executing dbcc cehcktable as this is a part of consistency checking opertaion. you can also run only dbcc checktable for checking on table level.

Welcome..:-)

Welcome:-)

You can not bring the database when there is a session on database. find out the spid who is using the database then kill that spid.

Select * from sys.sysprocesses where...

TeraByteMe (2/29/2012)

---

I am trying to update filename records in a temp table by using the REPLACE function. I can't think of how to do this all in one statement so...

Check any maintenance job might be running the dbcc check db . IF execution the time is fixed then run a trace findout which session is executing this.

Read this article

http://www.mssqltips.com/sqlservertip/1024/deploy-sql-2000-dts-package-vs-sql-server-2005-ssis-package/

You can create temp table and insert the all the database names. and Execute below statement to get the script of create database , copy the result in query analyzer...

I think you should check the execution plan for both queries and try figure out why it so.

Use the below Stored Procedure to find outh the details

EXEC master..sp_help_log_shipping_monitor

Check this link.

http://www.mssqltips.com/sqlservertip/1708/index-fragmentation-report-in-sql-server-2005-and-2008/

Increase the max server memory setting. Free caches by using one of the following commands: DBCC FREESYSTEMCACHE, DBCC FREESESSIONCACHE, or DBCC FREEPROCCACHE. If the problem reappears, reduce workload.

Try with using dynamic sql statements to do this.

Check this article.

http://www.mssqltips.com/sqlservertip/1593/granting-view-definition-permission-to-a-user-or-role-in-sql-server/

Backup strategy.

http://www.sqlservercentral.com/blogs/glennberry/2010/03/25/recovery-models-and-backup-strategies-for-sql-server-2008/