I see your concern, but what good is the list of procedures if they can't gain access to them?  I'd like to hear your thaughts on the process as a...

SELECT  CASE WHEN [Module] = 'Soarian Clinicals-Classroom Instruction'        then [Module]

         ELSE rtrim([Module])+'(Online Module)'

      END  as ModuleName

 FROM   [Module Name List SClinicals]

CREATE TRIGGER TR_Audit_TblName_A_U ON dbo.TblName

FOR UPDATE

AS

SET NOCOUNT ON

INSERT INTO dbo.AuditTbl (ColsList)

Select ColsList FROM dbo.Inserted

This would send the new data inserted in the table.  Change Inserted to Deleted to have the...

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...