It says REPLICATION.

It is a...

I've just run a dbcc checkdb command across the command and all seems ok there:

CHECKDB found 0 allocation errors and 0 consistency errors in database 'Databasenameremoved'.

DBCC execution completed. If...

Hi Gail, thanks for responding.

The value is 6 for log_reuse_wait. What does that mean?

Thanks for that. I've attached what I see through the command you gave me. I see a heap of Status=2 rows.

The thing is, there's no users using the database right...

Any ideas anyone?

Back in here with a problem :(.

A database log file has grown to 26GB, and although the transaction log backups are running every 15 minutes, and differential backups every 3...

Thanks for the help Leo 🙂

Thanks for that, will have a look at that path 🙂

Why is it /3GB ? Does that tell Windows to basically use more than 3GB RAM where available? What does...

Goodness me, finally. It's working.

It's working with a "Operating System (cmdexec)" job with the following:

D:\Program Files\Microsoft SQL Server (x86)\90\DTS\Binn\DTExec.exe /f "D:\Import\CImport.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW

running...

I'm logged into the SQL Server as the same user who runs the sql agent service.

I can run the package fine through the file system, when again when I attach...

I've tried both yes, under my account, and under the account the agent service runs under and both work fine.

This is driving me absolutely crazy, spent the whole day trying to get my package to run through SQL Server Agent and still getting this damn "class not registered" problem...

Great solution Phil - worked a treat 🙂

Thanks guys 🙂

CozyRoc (4/27/2009)

---

JamesNZ (4/26/2009)

---

Thanks for that.

Based off those links you provided I've managed to create the attached (see screenshots).

I managed to get the Insert working just fine, but couldn't manage to...