*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 1 year, 1 month ago by  krypto69.
• This reply was modified 1 year, 1 month ago by  krypto69.
• This reply was modified 1 year, 1 month 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]...

Thanks guys! VERY MUCH !

Jeff you are always on point. Thanks for the lesson and Drew also.

Happy Holidays and good karma to you all!

Really good points here. Thanks again.

Ratbak I...

Thanks Guys. Gonna do some testing but most likely going with DNS alias (CNAME)

Thanks again.

Hey Lowell - I completely forgot about my logon trigger - it was giving me fits for hours! THANKS!