Great. Thanks a lot.

xp_fixeddrives can only give out the free space of each drive. How to get the drives' capacity(total space)?. I know using sp_OACreate 'Scripting.FileSystemObject' can get that info, but I don't...

The dynamic SQL couldn't see the variables declared in your current session. Think of it running in a different session.

Try using sp_executesql. Check BOL. It has an example to...

When SQL 2k5 is installed, it uses the folders of MSSQL.1, MSSQL.2 (.3, .4...etc) for different service and instances. In a normal installation, if you chosen to install every service,...

Make sure to choose as fewer events as possible. Too many events tracing, expecially those for performance (show plan etc.),  generates a large volumn of network traffic that could prevent...