It will / may return NULLs if any of following is NULL:

@PersistenceSourceId

@EntityType

@NativeUniqueIdentifier

RETURN HASHBYTES(

'SHA1',

CAST(@PersistenceSourceId AS VARBINARY)...

Actually it’s not that difficult. You just need a loop / cursor (suggesting loops because it’s one time solution probably :unsure:) that will loop through all tables in the database.

For...

What’s confusing in it? The INSERT statement is calling a function that returns hash bytes (varbinary value). :Whistling:

Then you should rebuild / reorganize your index. Its fragmentation is consuming 30 GB of space (however not visible in query results :unsure:).

Full Restore will replace everything on target server with...

You took FULL backups, right?...

Most Welcome! 🙂

I believe its exported csv (or tab limited) file. So by default it will have row terminator, you don’t need to force it.

Else you can put following case with explanations...

I am not very sure how ‘sys.dm_db_index_physical_stats’ gets its data & how you retrieved 36 GB on Index space. But it’s very common that a file’s actual size & file’s...

Try following on notepad...

Insert some text (any text) and hit enter key (new line). What’s the output?

Until you hit enter key, line can go till EOF. But it’s not...

Did you conclude anything based on this output?

It’s as expected error files.

It indicates error in row#3 with complete row...

File 2...

Can you try your code with following data?

--- Data in Sample.text

1,James,

2,BK,

3,

------- End of data----

frankcastle509 (1/2/2012)

---

Well sir, I am not blaming anyone in this community but always trying to learn something which is knowledgeable and could be of great value to me.

Yes, experience...

It will create error files if it rejects any row for inconsistency. If your data is clean it won’t create it. Verify it with scenarios where you lose some of...

Please consider it a lesson and backup your databases regularly. I should add verification of backups is equally important so verify your backups with proper restoration scenarios at regular interval...