Walter setup a server side trace and schedule it to run during the period that you expierence your performance problem.

1) Use SQL Profiler to setup a trance based on the...

Download details: .NET Rocks! - Kimberly Tripp on SQL Server

http://www.microsoft.com/downloads/details.aspx?familyid=18D23441-A24E-4BA3-8594-D29CD4D32979&displaylang=en

This would be valid for SQL 2005 except I don't think there will be any mention of the DM Views...

Order by is the only way to be sure of the results.

Hi Walter,

I attended a seminar on SQL performance tuning by Kimberly Tripp last week and she had some interesting comments on DTA. It would seem that DTA attempts to tune...

I got this one wrong.

In the tests that I did whenever there is column and an alias with the same name the order...

Hi Mark,

Open the file with Query Analyzer, select the correct database and execute the stored procedure.

Rusty

Hi, I am getting the same error on a DTS package that copies DB's from production servers to a MIS server. I get

(Microsoft SQL-DMO (80004005): [SQL-DMO]CreateFile error on '<server>.<db>.DR2'. The...

Good point. Although I made the assumption that the question related to 2000 and therefore got it right. I think questions should state the version of SQL.

Shaun

Yip. Well spotted when I retried using suser_sname() it did change.

Thanks David, I think we should be awarded the point.

I tried this out and found that it only effected the user_name() in my session. suser_name returned nothing before and after I issued a setuser. I logged in using Windows...