Ok, so let me make sure I understand.

1. Using UNC but direct references (ie: F:\dir\file.trc) also fail.

2. Opens ok in profiler.

3. SQL/Agent login as domain account.

4. File and directory have...

I think P Jones has a point, people who abuse this might get away with it once or twice but most of us have a formal process that we can...

32 or 64-bit SQL? If 64 I don't think you can get this to work..

CEWII

You want to keep in mind how SQL agent logs in.. so you might not want to absolutely deny all windows logins but deny all BUT a limited list..

CEWII

I generally start with the "yes" position. If I have some hard boundary I usually tell the requestor that I will try but I have another commitment that I...

Uh, what temp file?

CEWII

That is a good idea, the only issue I see is that it is not easy to truly guess it. But if you grow it big enough it wouldn't...

I guess a lot depends on what you are trying to prevent. I don't like to use tools like Access because they generate queries that I don't like. ...

You could try re-applying the service pack..

Hold on.. Are you using Query Analyzer to connect to SQL 2005 or SSMS? It just occurred to me that the title...

Gosta Munktell (12/8/2009)

---

"I need to do it with T-SQL because my customers first upload a XLS, then press a button that loads the data in a SQL Table."

If it is...

Does this work from another machine?

CEWII

Excellent point, shrinking can be useful if you had a large transaction or other issue but if the file will normally grow to that large size over a day then...

No, within a dataflow you can use either an OLEDB destination or a SQL server destination. To get to the property we are looking for on the SQL Server...

No, it would be lost.

They are the NO_LOG more or less marks all the log entries and backed up and the truncate clears them.

CEWII

Is the database configured for full or simple recovery. I'm guessing full..

You could do:

DUMP TRANSACTION databasename WITH NO_LOG

GO

DUMP TRANSACTION databasename WITH TRUNCATE_ONLY

GO

That should clear up the log..

CEWII