Please post your findings so that other members can benefit from you work.

I don't know what the requirements are but I know for sure that this is false representation.  The brain is way too big in that picture

Do you know that a timestamp column is NOT A DATE equivalent in any way?

CREATE TABLE #x (a int not null primary key clustered)

Insert into #x (a) values (1)

SELECT *...

That's because there's a default value in the column.

Or in insert trigger that update the rows.

Or a default value has been directly coded within the insert statement.

I must add that...

Have you tried something like this?

declare @date as varchar(255)

set @date = convert(varchar,getdate(),112)

declare @Path as varchar(255)

set @Path = 'G:\MS SQL\Backups\mydatabase\mydatabase_backup_'+@date+'.bak'

EXEC sp_addumpdevice 'disk', 'mydatabasebackup', @Path

BACKUP DATABASE mydatabase TO mydatabasebackup

Another solution would be to use a job to start the whole process.

The first job step would be in VBS to open the file using the FileSystemObject.  Add a line,...

Are you planning on changing job soon??

Anyhow I think that the skillset you posses is far more important than the job title (to a degree).  Also if you feel you...

No, if anything goes wrong, the whole transaction rolls back and that's the way it should be.

I suggest maybe having a job run every X minutes to handle that update. ...

You just can't do that (without going 1000 loops and workarounds which I would strongly advise against).  Why aren't you using the identity property of sql server?  This is by...

What if you backup / restore the rogue db to another server or even to the same server under a different name.

What is the collation of the server / database / column in the table?

Just to make sure I understand correctly : You want to remove the data in a particular column but without deleting the entire row and without dropping the column?

If those...

I'm not sure I'm following you.  Do you still need help with this problem??

If you do, where did you put the password and how did you try to import the...

Can you post the code you are using to arrive at those hex values so we both talk the same langage.

I'm gonna say the old adage :

If it ain't broke, don't fix it.

But I'm also gonna ask where do you remove the password from?