Viewing 15 posts - 16 through 30 (of 595 total)
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...
October 4, 2023 at 12:10 pm
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]')...
October 3, 2023 at 1:38 pm
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,...
October 3, 2023 at 12:20 pm
Hi Frederico
Yeah checked for denied .
Thanks tho!
October 3, 2023 at 11:27 am
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...
April 12, 2023 at 2:19 pm
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...
April 4, 2023 at 11:16 pm
Thanks guys!
frederico_fonseca your answer worked perfect after a couple of minor tweaks! THANK YOU SO MUCH!!!!
April 4, 2023 at 7:27 pm
Thanks Jeff!
Hey wait...So format not so great? Googling now...
February 16, 2023 at 3:00 am
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]...
February 14, 2023 at 12:47 am
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...
December 22, 2022 at 8:34 pm
Thanks Guys. Gonna do some testing but most likely going with DNS alias (CNAME)
Thanks again.
November 30, 2022 at 6:49 pm
Hey Lowell - I completely forgot about my logon trigger - it was giving me fits for hours! THANKS!
September 15, 2022 at 2:46 pm
lol..yeah I've heard bad things about current logic
googles ' DelimitedSplitN4K'....oh cool. Thanks Jeff!
June 24, 2022 at 7:28 pm
HI Jeffery
I feel pretty dumb for not trying the disable. I did remove the DB's from the user on the primary and noticed that then they were removed from secondary....
June 8, 2022 at 12:03 pm
Viewing 15 posts - 16 through 30 (of 595 total)