Is this a one time thing? Is this a stored procedure that's running every few minutes? I generally don't like to create linked servers for both security and performance issues.

Not sure what you mean by a huge amount of transactions. If it's growing a lot and your transaction log is set to say 20 GB you can either increase...

This is a bad idea. Depending on transactional load on the server, it could grow large even after a shrink. The best option would be to do a shrink to...

So will this also work,

if (select ars.role

from sys.dm_hadr_availability_replica_states ars

where ars.is_local = 1) = 2

begin

raiserror ('This is not the primary replica.',2,1)

end

Inherited, and I would like to change these.

Looks like in your tablix you are attempting to average, sum, etc. data that is not a numeric value. I.E. trying to sum a string.

I double checked that, it's not used currently. That variable...

This seems like a good solution, but still requires buy-in from dev. I'll see if I can get them to modify their code.

Thanks.

It's not a historical table so each table has only one value, that value is selected then updated so max is not used.

Here's the table,

CREATE TABLE [dbo].[key_table](

[alias] [char](25) NOT NULL,

[lastkey]...

Ah, ok, try rVadams recommendation.

This is also another option, it just seems a little weird to do it like this though.

If the server is linked, instead of doing an openquery you can use select .... from [server].[db].[schema].[table_name], i.e.

select * from server01.main_database.dbo.table

You're doing an insert with a variable, via the Select @TSQL statement. Why can't you strip out @TSQL, and modify your statement a little bit to just use a select?

Try this

set @sql= 'BULK INSERT ' + @TableName +

' FROM ' + '''' + @FilePath + '''' + ' WITH (

FIELDTERMINATOR = ''' + @delimiter +'''

,ROWTERMINATOR = ''''

);'

Execute (@sql);

I believe you can go to your replication monitor, right click on the agent and select properties. You can then disable the task. . . I think.