Hi Perry - the version is 5.0.2.1030 however this is working on other servers with the same version of LITESPEED

Hi thanks for the reply, I will check out what out app is using.

We are looking at building a 2012 test environment so fingers crossed.

wow thats great I will check it out, thanks very much.

Ok I found the answer here

http://stackoverflow.com/questions/2723061/sql-server-2008-replication-failing-with-process-could-not-execute-sp-replcmds

However my owners were not null in my case but had my account as an owner. I had already used sp_changedbowner previously in trying...

Hi yes, it dawned...

Hello

If I do that though it converts it to a varchar where as I want to keep it as a datetime. The reason is that this is to be...

Hi - Seems the log reader agent had been stopped, I did a re-initialise and was then able to shrink the log.

Thanks

No I just broke down the large transaction into smaller ones, ran them individually and kept an eye on log space and tempdb space, it was all fine in the...

Will do

Ahh no worries at least its not me going mad, its been a long day 😛

How is that? Have I just explicitly stated what it was implicitly doing? None of them are nested

Hello all - The code is as follows, plus the code I have wrapped in transactions.

SET XACT_ABORT on

BEGIN TRANSACTION

update fastquote.dbo.FQ4_Project_Lines set RepresentativeQuoteId = 0, RepresentativeQuantity = 0, RepresentativeUnitPrice = 0

update...

Sorry why doesn't smaller transactions have a benefit in full recovery, surely smaller transactions followed by a log backup will surely allow me to keep the log in check during...

Hi

I don't believe the UDF is actually using a linked server, for some reason the 4 part naming convention is being used when all the code I have posted is...