Is this for a specific user or every user on the instance?

Another option would be to run an update statement to set the column to null and then drop the column.

When looking at the database with the taskpad view in Enterprise Manager it was still saying the data in use size was the same as before.

Just to clarify. After dropping...

I completely agree. For example i now know to use parsename instead of CHARINDEX AND SUBSTRING to sort out the octets. 🙂

declare @ip varchar(15)

select @ip='1.10.20.30'

select substring(@ip,(charindex('.',@ip)+1),(len(@ip)-(CHARINDEX ('.',@ip) + CHARINDEX ('.',REVERSE(@ip)))))

When you execute the job manually it is running under your user context. When scheduled it is running in the SQL Service account user context. Does the SQL Service account...

select a.* from customera a

join customerb b on (a.company+a.zipcode<>b.company+b.zipcode)

That would be dependent on the application error checking routines.

0 to 10 informational messages

11 to 16 user problems example, error message returned invalid update query

17 ...

Are you adding all the files at once under the restore "From Device" radio button?

This should do it.

ISNULL([CHECK EXPRESSION],[REPLACE STRING])

How about this. Might be a bit long winded though. This will pull out 742.0 of the following strings

'On 742.0 Evergreen Terrace'

'The number is at the end 742.0'

' 742.0 Evergreen...

Suppress the backup software from backing up the temp directory. That may stop your issue.

Is this third party tool for SQL or for the OS?

For example litespeed uses a number of volume shadow copies and then compresses these together in a single compressed file....

You will only be able to see current processes with this. If you setup a trace you will capture all the events from start to the finish of the trace.