I am in same machine

Those configurations were set to 1 before as well, file is not open and it lets me make a copy of it and even with different name it gives the...

The create date just provided date when it was created but not when it completed with the bacpac import.

I needed this information to provide estimate of how long it would...

Thank you, I think the other factor is that there are more than 100 tables that have dependency on this table, so the delete might be looking into all those...

Thanks for the information.

Thank you for the reply, so does it mean it will be available for 7 days once it reaches it 1 GB limit before it gets cleaned up?

Everything in the table is being exported to text file, there is no indexes in the table just raw data\ dump from SQL Audit to a table.

SQL Audit file size...

To clarify I am using built in function to read from SQL Audit file but the other team has capability to read from .txt file only, that is the reason...

I have copied all data (except for BLOB) to the new database, now I need to copy all indexes, statistics, primary foreign keys from the original tables to these new...

Thank you Ant-Green for your response.

Basically whichever approach we take to update the column, importing data to new database, shrink db files there will be downtime to the application\need maintenance...

Yes, I think the same too, it might interrupt the process as the SQL job is using select statement that is reading from the database that is in sync with...

I got it using case statement.

declare @path varchar(100)= 'c:\images\A\'

declare @path1 varchar(100)= 'c:\images\B\'

SELECT [ThumbNailPhoto],[ThumbNailPhoto1]

,@path+[ThumbnailPhotoFileName] AS Path

,@path1+[ThumbnailPhotoFileName] AS Path1

FROM [AdventureWorks2012].[Production].[ProductPhoto]

If ThumbNailPhoto is null and ThumbNailPhoto1 has image in the extract it is doing this:

c:\images\A\Pic.jpg ( size 0...

I am trying to restore prod backup to test instance, so overwriting it should not be a problem.

Thank you guys, that worked.