It is Dev server that Im trying to install on, just wanted to know if anyone else has already done this before.

Yup did that, Thanks a lot. Im looking at the data.Will update if run into any other problems.

Thanks You Sean & Cold Coffee

Thanks Sean, that worked but now I get

Msg 5309, Level 16, State 1, Line 4

Windowed functions do not support constants as ORDER BY clause expressions.

ColdCoffee (8/24/2011)

---

You dont need a cursor to do this 🙂

some like

DECLARE @MaxIDVal BIGINT

SELECT @MaxIDVal = TOP 1(AcctID) FROM dbo.tableA ORDER BY AcctID DESC

; WITH CTE AS

(

SELECT RN =...

Hi Gail /Steve ,

Ive started on the transaction log backup and will keep you posted if I have any more issues,

I wanted more clarification as my manager has been insisting...

Steve Jones - SSC Editor (8/10/2011)

---

For databases in full or bulk logged modes, you need to run log backups. That is the only way to backup the log records and...

I executed DBCC LOGINFO(@dbname) on all the 30 databases's and I see lots of VLF with status =2 (In Use).Here are the questions that I have

1) Out of 30...

1st time for this specific database, nvr saw this before on others

Yup, This rollback is from a job that failed last week. Never looked like the rollback is actually happening.Its been going on since then.

Is there any other solution that I can try before restarting the service, as I have may more application database on this server ?

Any idea why this sould have happend...

Havent done that, as I have almost 20 database's on this server that are being backed up using the same tool as well but there has been no problem on...

Thanks Sean, I checked the character length and it is about 16,000 +.

hi sean, i did try your advise and copied over my query to a new window but still only see half of it.

Hi michael, thanks for your prompt response. can you show me how you use substring to accomplish this

Front end changes are difficult, I ve added NULLIF to my proc .Thanks Craig