Use a temp table (#tbl)

Truncate it and it'll reseed.

Windows admin tools, services.

Then what error are you getting on the insert when it fails?

For me I get this error :

Cannot bulk load because the file "D:\Mijn Documenten\Documents\DWCoureurLocaleData\Irfanview_26012011\1.jpg" could not be opened....

You can go in the list of services to find a second instance.

Next on the list is output the list of physical files for the dbs and see if it...

PS copy / run exactly as is, (I run in tempdb volontarely).

Do you get any errors, do you see the data in the table??

There's no place for "think it works" in sql server. You must RUN the code and see it work.

This works for me.

Do you get any errors?

USE [tempdb]

GO

BEGIN TRAN

SET ANSI_NULLS...

Reindexing job? That's usually culprit #2 right after not taking...

Have you tried removing the insert just to see if the select actually works?

Any big data load or reindexing?

Tx for the assist. Just pointing out the "correct" way to do it so the newbie can learn.

Besides it's just a matter of moving the cmdshell out of the...

Just for the sake of solving the issue here's a script I have built for "emergency" shrinks. The good thing is that you don't have to worry about the...

http://99designs.com/

Check the quotes there. Anything really basic is under, well under 500$. Cheaper than even 1 day of consulting. then you can always maintain.

The great thing there...

How big is the log "normally" and how much has it grown to?

Wow talk abot wasting time (perf wise).

Run the dir command ONCE at the begining of the code and put the right index on the table. Then just do the...

Do you have a 2nd instance of sql server running (or sql express).

Also keep in mind that the filename and db name can be different. So maybe it's not...