Jeff, thank you for all the info and your time it's greatly appreciated!

1. plans attached as xml, sqlplan is not allowed
2. will start looking at that, that's a lot of...

• This reply was modified 6 years, 3 months ago by TangoVictor.
• This reply was modified 6 years, 3 months ago by TangoVictor.

thanks Jeff, this is actually a linq query from the app i think the parms are relative to the current date so they do change daily but return a similar...

• This reply was modified 6 years, 3 months ago by TangoVictor.

I've never used Phil's suggestion, that sounds like a good route, i know using parameters in a lookup has pretty bad performance at least it has the times i've tried...

I restored the DB from yesterday and also from the time we were having the problem this morning into the test environment which is running the same version of SQL.

In...

I have not really used them but this seems like maybe a case for using checkpoints. I'm not sure how that would work with no constraints. If the checkpoints could...

You running this interactively?

Can you run it interactively?

I've had some very odd behavior, where the agent appeared to start the job but nothing would happen.

I usually confirm i can run...

Morning Steve, yeah a popup would be great, anything to see what it looks like before pulling the trigger. I find myself posting then editing. Whatever is easy to implement.

This has to do with how SQL Server processes errors on remote procedure calls.  The error message bubbles up but not the actual exception, you could do something like...

Thanks for creating this, just saved me a bunch of time creating a new SSIS server.

As the last poster mentioned the string data is not showing up like the example:

@String...

Nevermind i got it. The following is what i was looking for:

SELECT
sp2.name AS LoginName
,sp.permission_name AS PermType
,sp3.name AS PermTarget
 FROM sys.server_permissions sp
LEFT JOIN sys.server_principals sp2
on sp2.principal_id = sp.grantee_principal_id
LEFT...

i went into services and disabled the Telemetry CEIP service. It was trying to login every 5 minutes. Try that and see if the login errors stop. Also look above...

if there are no SPNs it will always be NTLM regardless of how you connect, local or remote.

You only get a kerb connection if a valid SPN exists.

Right now when...

I've been running setspn -q and -l to see what we have.

I'll install the kerberos config mgr.

Thanks for the info!

Thanks Sue i really appreciate the help. The deeper i get with this the more confused i get.

I've created a new post in 2016 administration now that i'm seeing connection...

I was using dbatools powershell command update-dbaserviceaccount

            
April 12, 2019 at 3:05 pm
            
#3159844