Do any of the server roles have DENYs on them?

SELECT SUSER_NAME(grantee_principal_id), permission_name

FROM sys.server_permissions

WHERE state_desc = 'DENY'

John

Put PRINT @sql in your code and you'll see what the problem is. The path needs to be in quotes.

Don't forget the SQL injection thing.

John

I think you just need to put the @sql in brackets:

EXECUTE (@SQL)

I would strongly recommend you read about SQL injection before putting this live.

John

George

Have you tried CONVERTing to or CASTing as decimal?

Really, though, this is a job for the presentation layer, not the database layer. Where are you displaying the results?

John

As far as I know, there's not any way to specify the order in which a ForEach Loop processes. I think you'd need to use a Script Task to...

What are you using to load the files? BULK INSERT, bcp, SSIS, other?

John

I can't see why 507 is blocking, given that it's AWAITING COMMAND. This is where sp_whoisactive gives you more information - it tells you wait types, wait resources and...

OK, then use DBCC INPUTBUFFER to find out whether blocking or blocked process are doing anything on the PEP database. You'll need to resolve the blocking in order for...

Now i am confused! 18th October 2014? You need to disable DBCC TIMEWARP. Was that the full output of sp_who2 that you posted? You're mostly interested...

Karen

While that script is useful for identifying which are your most expensive and/or most used queries for tuning, it doesn't help with identifying what is running at the moment. ...

Karen

Don't change your log backup interval. The log backups won't stop your processes from completing, so just let them run as normal.

You can use sp_who2 or the Activity Monitor...

Karen

Your log won't be truncated until that transaction is complete. Do you have a long-running job or some other process that's been going for a while?

John

Karen

What does this return?

SELECT log_reuse_wait_desc

FROM sys.databases

WHERE name = 'PEP'

John

Not all spaces are created equal. Maybe they're tabs or something else that could look like a space. There's a function (ASCII or something like that) that will...

Yes, good point. Thanks Lynn.

John