online indexing enable for this table , if you use SORT_IN_TEMPDB online indexing it will eat up your tempdb database.

declare @dbname varchar(50),@objname varchar(20),@sql varchar(100)

set @dbname='master'

Set @objname='Ta'

Set @sql="Select * from "+@dbname+".sys.objects where name = '"+@objname+"'"

EXEC (@sql)

the error clearly says that you are comparing date and int value in your code. you need to convert your date into int and compare

you got the answer or you are still looking for the answer

check the setting in query designer it should not have much difference running the same code

--method 1

declare @qry nvarchar(500)

DECLARE @database_name varchar(50)

set @database_name = 'MASTER'

set @qry ='Select count(*) [count] from ' +@database_name+'..sysdatabases'

create table #temp (cnt int)

insert #temp

exec (@qry)

select * from #temp

drop table #temp

--Method 2

DECLARE...

where you kept the file in server particluar directory. and the path is stored in the database ?

if your size is bigger , how you are going compress

yes i have similar project , i used linked server and able to import huge records without any issue

when you do online indexing defiantly will take longer time to update the index and might lock the table, you can check locks SPID to find out more which process...

Hi

files your trying to remove from the database is part of your Alwayson Group ??