Adam Haines (3/27/2008)

---

There has to be some outstanding variables here. Compare the problematic column datatypes to working datatypes. You can also see if using substring returns the same...

I never found out what the issue was really, i just removed all the replication and started again, and now its fine. So my advice would be to do...

Cheers for the reply Adam, however it isnt the answer. The column has no spaces in it SLON0_TOTAL_FEES There are actually 16 characters, the legnth knows there are 16...

are the data files read only by any chance?

select * from msdb.dbo.sysjobhistory where message like '%failed%'

Ones that you need the full failure message on you could write a job to check this table every x minutes and do...

I have had this problem before and a simple restart of the agent service has solved it. Usually though when this happens the next scheduled date will still be...

Robert.concepcion (3/10/2008)

---

SQL Server Databases object Transaction/sec doesn't measure activity unless it's inside a transaction. SQL Server General Statistics Batch Requests/sec measures all batches you send to the server even if...

You need to do a couple of things.

1) Backup your transaction log, this will free up room within the log (not the physical size!)

2) shrink the log using...

use performance monitor. there is a counter for transactions/sec. its under the SQLServer:Databases objects

It could be because the jobs are trying to execute on a server where they were not designed and you need to amend the server id properties. you can...

have a look in BOL for sql agent database roles. there are 3 fixes roles (user, reader and operator), a user needs to be assigned one of these roles...

Peter - your a legend, i cant thank you enough!!

Thanks for your help and perseverance.

John

Hi Peter,

Thanks for your reply. I see now where i can enter my variables. It has however thrown up another issue where i have obviously gone wrong...

You are correct, it should not be a problem just updating the named instance. however make sure you take a full backup of all your databases on both instances...

use profiler in a test environment and look at the lock events. you will see when locks on objects are aquired and released. that way you will probably...