Can you provide the schema for the audit table?

By the looks of it you are trying to insert the JOB_POSTING_NUM column into the audit table and I imagine...

How are you creating your profiles and accounts, using the GUI or scripts?

If you are using scripts can you post them please?

Cheers

Chris

Hi,

What context is the SSIS package run under?

Cheers

Chris

Some additional info;

I also noticed that the subscriber server had a collation of SQL_LATIN1_GENERAL_CP1_CI_AS whereas the publisher is LATIN1_GENERAL_CI_AS I changed the subscriber database to LATIN1_GENERAL_CI_AS but still get...

sweet question ant.

You can use the below link to help with DBCC MEMORYSTATUS

http://support.microsoft.com/kb/907877

You could also look at any of the below quieries and modify them to suit.

-- Listing System memory usage.

SELECT ...

Using them as a "cobbled together" audit process would surely invalidate the license terms?

Thansk

Chris

Are thier resources avaiable on both source and destination servers?

Sounds like something might be delaying log truncation. Search Transaction Log Truncation in BOL.

Thanks

Chris

I disagree, this shoulds like you would be in breach of the licensing terms. I would try to seek an answer from Microsoft just in case.

Thanks

Chris

There are many way's of becoming a DBA as there are many different types of DBA (development, production,accidental, architect etc etc). Have a look at the below link.

http://www.brentozar.com/sql/becoming-a-dba/

Thanks

Chris

Build your scripts dynamically by querying system catalog views etc. That way you are not executing scripts for a pre-defined list of databases and you can make them re-runnable.

Thanks

Chris

You could use DBCC MEMORYSTATUS.

Thanks

Chris

Can you provide some more information please?

Package configuration / properties?

Thanks

Chris

Looks like the restore of the full backup is being done WITH RECOVERY. In order to restore your transaction logs the full backup needs to be restored WITH NORECOVERY....