Nope, that was one of the first things I tried. I just changed it and changed it back again, just for giggles, and still didn't help.

Thanks,

Chris

Nope, that didn't help. And the error remains an ambiuous "Access is Denied".

Thanks,

Chris

Finally stumbled across the solution. You have to connect the objects for with a workflow, something that the documentation on the MS page did not mention. Now to work through...

I can successfully connect to the Azure DB using a query window in SSMS with the same account I am trying to use for the linked server, and this is...

Thanks for the reply. Yes, it does appear to be an authentication problem, but since I have successfully connected using the necessary credentials, I have ruled out that as a...

Thanks for the info. I will look into that.

Thanks,

Chris

"Use DBName" is an excellent practice and will serve you well.

This, for instance, will fail at the Use statement if the DB doesn't exist and nothing else will execute.

Use MYDB

Create...

I will try this when I get back from vacation.

Thanks,
Chris

Code change was:
    Delete A
     From ACSLog.dbo.AuditLog A With (Rowlock)
     Inner Join ACSLog_Archive.dbo.AuditLog B On A.AuditLogID = B.AuditLogID OPTION (MAXDOP 1)

To:

This VM has 6 CPUs. I have at least two data files for TempDB on all servers. This server has 4 data files, of 3.2G, 3G, 36.8G, and 10G.

Well, learned something new. It is working and working very fast. 1000 records in 3 seconds or less, and 50,000 in, well, it started at 106 seconds vs. the previous...

If you look at the code I posted I was doing the delete with a join.
       Delete A
        From ACSLog.dbo.AuditLog A With (Rowlock)
        Inner Join ACSLog_Archive.dbo.AuditLog B...

Yes, sort of. The archive DB only has 90 days worth of history in it. Each quarter we back up the DB and store it offline in case it is...

Code:
Set NOCOUNT ON
declare @enddate datetime, @NumRecordsToGet int, @FirstDayOfQuarter datetime
Declare @NumRecords Int, @NumAffected Int
Declare @Err Int, @ErrMsg VarChar(255), @Body1 VarChar(500), @Email VarChar(2000)

select @enddate...

Adding the estimated query plans for two options, 1. Current design, with a join on delete, and 2. with mod to use Delete where not in(select from....
FYI, while I...