Can't help you with that one then. I'd recommend bcp, but if you say they can't, I don't know what else to suggest. Maybe someone else can help.

Judging by the error, I'm going to hazard that another backup or file operation was already running on that log file.

Might need to set them up with an SSIS package that exports the tables they are looking for. Or with a bcp command for it.

David (6/9/2008)

---

Very good article but you should add trace files to your option for auditing. I'm currently using Idera's tool which uses this method and been pretty happy with...

I would...

Yes, you can do exactly what you're asking about.

Create a group, go to the Securables tab, use it to grant execution rights on the procs they should have access to,...

Take a look at this page and the discussion. It's got the scoop on generating massive amounts of data for testing, and a bunch of related subjects:

http://www.sqlservercentral.com/articles/TSQL/62867/

Yes, I would be surprised if that query ran very quickly at all.

I'd break the thing down into a few temp tables, based on the various cases and functions being...

Actually, when it comes to concatenating strings, you can do that with the coalesce funtion pretty easily. Doesn't require any UDF or loop.

That's probably mostly time spent rendering results.

My first question is why is W_PARAM_G even in that query? Let's ignore the mixed join criteria for a moment. It has no columns in the Select or...

Jinx!

I think when I saw someone run into this before, it was a matter of updating Management Studio on the MS Update site.

If I'm reading what you want correctly, this might do it:

select ID, Date, Time, Value

from dbo.Table

where

dateadd(minute, time%100, dateadd(hour, time/100, date)) >= getdate() - 7

and

dateadd(minute, time%100, dateadd(hour, time/100, date)) <...

Which begs the question of why you would run a load-testing batch process on a production database. (Running it on a test database wouldn't use up any IDs at...