Jeff

the query is the slow part of a larger process.its not being posted to a screen - query is part of universe of claims process that needs to look at...

• This reply was modified 1 years, 11 months ago by krypto69.
• This reply was modified 1 years, 11 months ago by krypto69.

Thanks!

Thanks Ant-Green. Kinda figured that.

I have an A,B servers. Sys admins want to move the B server to the new location on one weekend and server A the following weekend.

Assuming...

*UPDATE*

Thank you all so much for taking the time to help with this issue.

It turned out to be a trigger that gets installed by default now in dbwarden. Once I disabled...

SO...still working on this nightmare..

I found that if I run this in master:

SELECT *

FROM sys.sql_modules

WHERE definition like '%usp_drop_temp_ingenix_codes%'

On the broke server I get these two records:

538484997 CREATE PROCEDURE [dbo].[usp_drop_temp_ingenix_codes] AS...

yeah guess they figure it works on all our other servers - the good old we dont know either must be permissions reply..

which i cant understand...feels like I'm missing something...

Thanks Jeffery

Yeah we contacted the vendor who said they feel the issue is permission related.

The error is not occurring in that code - or it is happening somewhere later in...

thanks Fredirico

dropped and recreated proc

This is the result from the sysmodules:

all servers - prod and dev

1615258704 CREATE PROCEDURE [dbo].[usp_drop_temp_ingenix_codes] AS if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[temp_ingenix_codes]')...

• This reply was modified 2 years, 2 months ago by krypto69.
• This reply was modified 2 years, 2 months ago by krypto69.
• This reply was modified 2 years, 2 months ago by krypto69.

Hi Dan

Yep checked access to file / share directory. Interesting that it works for many other files and it works fine when pointed to one of the dev/stage servers. So,...

Hi Frederico

Yeah checked for denied .

Thanks tho!

FWIW - Super old thread - but I see the exact blocking SQLBlimp is referring to all the time. Wondering it this has been addressed in newer SQL versions. Screen...

Hi Jeff

Yeah vendor is aware of this issue. But get where you are coming from for sure.It was caused by a crappy import tool they wrote.. Really the records should...

Thanks guys!

frederico_fonseca your answer worked perfect after a couple of minor tweaks! THANK YOU SO MUCH!!!!

Thanks Jeff!

Hey wait...So format not so great? Googling now...

Hi Jeff,

Sure! Thanks!

USE [PEC_PROD]
GO

/****** Object:  Table [dbo].[member]    Script Date: 2/13/2023 7:39:54 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[member](
[member_id] [int] IDENTITY(1,1) NOT NULL,
[last_name]...