Are these users developers? Or the end users drawing from the cubes for reporting?

Note that xp_dirtree is an undocumented stored procedure.

To find the newest file added to a folder using SSIS a Script Task might be the simplest way.

Some sample pseudo code

Dim latestFile...

Check your report data sources and how they're configured on the server. Make sure they are using SQL Authentication.

Where is the database server you'll be selecting from? The date needs to be from the perspective of the data in that database. You could always change it to a...

Just to drive the point home, consider what would need to be tracked at the database level if a query were issued that joined tables from multiple databases.

Trace can...

Yes. Lookup BACKUP DATABASE and RESTORE DATABASE statements in Books Online.

The one time I have seen someone use one scheme and function for many tables they inevitably regretted doing so when it came time when they needed to change how...

You could also be experiencing blocking. Run one proc now and a statement within it might be blocked for some reason and the proc could take 30 seconds. Run that...

Just to add to what Lowell said, float has a higher data type precedence than varchar so when you compare, or join as you are doing, two columns with different...

Maybe not stop, try clearing the trace, that will definitely force a flush to disk.

No, not natively. SQL Server supports UCS-2 which is a subset of UTF-16 for Unicode data. In 2012 there is...

Trace results are buffered so yes, sometimes there will be captured results that have not yet been written to the file. Check the column "event count" in sys.traces to see...

Cheers

Tab Alleman (6/7/2013)

---

I am dealing with a similar issue, and found this exerpt in the article referenced below. Check and see if it applies to you:

•Truncated text. When...

Snipes