Thanks Karl, I am almost there for the output.

But when I use xp_dirtree on c:\ drive it is giving so many rows which is unnecessary.

Can we exclude Program Files...

I need get the information  using T-sql programming and display all files with extension .BKP, .BAK, .TRN as a result set.

Database is in simple recovery mode.

I am trying to shrink the file using DBCC SHRINKFILE command on one of the datafiles , It runs and gives the result but actually datafile is not reduced.

But I...

other than taking the table to offline, does it effect anything else?

Can I set options in job step like

SET QUOTED_IDENTIFIER ON

SET ARITHABORT ON

Does this effect the database settings or server? As this is in the production server.

My trace doesn't have those things included. There are other tools through which I can know memory, disk and CPU utilization, which are looking fine.

Network Summary - Total_MB/Sec

Network Packet Rates...

In one of my server there is 32Gb of log file for a database. when I run DBCC SQLPERF (LOGSPACE) log space usage is 94% and the status is not...

Thanks..

I didnot understand  why it is showing negetive value,what actually is the meaning of that?

also do I need to truncate the log file before shrinking the log file?

Waht is...

>> What is the purpose of doing DBCC CHECKDB in all databases in the same server ?

I didn't get that.

I want to check whether the Indexes are...

Default is turn on,  but I counldn't set to off.

--> If you're moving several databases make sure you attach in the correct order to maintain the database id's.

I didnot get that. Like..

If I am moving DB1(DB1.mdf, DB1.log)

                    DB2(DB2.mdf, DB2_data.ndf,...

I just want to move only one database from that drive to other. other databases will be on the same drive.

Can I put the database in single user mode?

Source: .Net SqlClient Data Provider

Event Source: Web Service

We thought it was due to stored proc which is using some table and we rebuild some indexes on that table but...

Properly sized the database ,what is the meaning of that? How can we do that?