Does the batch file on computer B work using the same credentials you are logging on to Computer A with?

yes this is possible, the update could block any other query on that table, it would all depend on where the data is held and what lock your update has...

look at monitoring tools such as redgate

Lead by example, set a good example get a good result, its like bringing up kids 🙂 

Plus get them on this site

ooch, a bit of over processing, i guess your are looping through and passing different parameters into @SQL_TempTable_Insert
thats going to be really slow.

I would take a look...

If your DB server is not capable of taking the through put then you need to up the spec of the DB server. alternatively you need to go back to...

I think based of your description it would be hard for anyone to offer any advice, i can ready your explanation in a few ways and give different answers for...

whats the purpose of database B? 

you mention Database B  has a different schema to database A, is this by design or do you modify the schema before your...

when updating information based on an external source be it CSV, BCP or whatever I always like to keep an audit trail of say last 6 months of updates. 

im not 100 sure exactly what you want but if the second line is always blank then start at the 3rd 

 BULK  INSERT Table_name  FROM  path_filename  WITH  (FIRSTROW = 3,FIELDTERMINATOR = '','',ROWTERMINATOR =...

depending on your datefirst settings you could try incorporate weekday 
select datepart(WEEKDAY,getdate())  -- if select @@DATEFIRST = 7 (default) then today would be 2 

alternatlivly

look at setting...

In my current role i deal with Data in one way or another, day in, day out and I think its important  to have a good understanding of the laws...

for beginners may i recommend Sams tech yourself SQL in 10 minutes 🙂 10 minutes later you will be able to write the SQL to answer these questions yourself 🙂

If you want to find a column that has a specific character you can use pat index

EG

Select * from mytable 
where patindex('%["]%',my_column)>0