I am not sure if i understand the question right. But I like the power of "case" when it works with "group by". pls see below sql:

create table test_tab

(item  int

,color...

let me try to answer this:

say the table name is A

update t1

from A t1 join A t2 on (

t1.column1=t2.column1 and

t1.column2=t2.column2 and

......... and

t1.identity_column<t2.identity_column

)

The key point is you treat one physical table...

I am in the same situation to use Veritas instead of going to disk using SQL Maintenance Plans and then to tape.

But I am not familiar with Veritas very much, I...

Hi

You need to use the column "type" in table msdb..backupset to differentiate full and diff backup. Pls refer BOL about this column

Once I was told that Veritas Backup use sql server backup engine ("native" backup method) to do database backup on SQL Server, so I was pretty comfortable with veritas backup. I did several...