Viewing 15 posts - 1 through 15 (of 232 total)
Thank you for the reply, Phil!
It was a minor adjustment on the networking folks, and it is fixed now.
thx
September 6, 2022 at 2:05 pm
September 2, 2022 at 4:39 pm
Not exists is much atomic than sets.
Use Not Exists.
August 2, 2021 at 5:20 pm
Nice piece to read.
Well, gurus, I have decided to trash that instance and have created another one. It was a new dev box that did not work well.
I will chalk...
April 6, 2021 at 8:00 pm
Yes, agree. I have used the advanced option to write out the error / message / etc. but it does not get there.. and there is no history, here is...
April 6, 2021 at 2:47 pm
The _Sandbox exists in other servers without any issues. That's correct.
April 6, 2021 at 2:23 pm
Here is the definition.
It is a simple 1 liner. The perfmon show that there are several retries before it crashes.
The services are running.
USE [msdb]
GO
/****** Object: Job...
April 5, 2021 at 4:52 pm
I have a similar issue.
select 1 this is all I have in a test SQL Agent job and runs forever.
This is an enterprise 2019 on a datacenter server.
on top of...
March 31, 2021 at 4:58 pm
Some minor fix is required.
Originally, the AvgHighTempC is set to "not null", by default.
To make the "update table" work, the table constructor needs the "null" for the said column.
CREATE TABLE...
October 23, 2020 at 6:11 am
use "distinct" at the bottom of your CTE, right after "select" on the line where you have the "windowing" (over.. partition..)
I am not 100% sure, but, give it a shot
June 24, 2019 at 12:12 am
How about having a shared location, sort of a DMZ, since the DEV cannot see the PROD by design.
A scheduled agent task / job at the destination can run an...
June 23, 2019 at 5:15 pm
The AD group should have "connect" privilege by modifying the properties of the database (for each DB). Then, you would need to create role(s) and assign read/write/view definition/etc. for the...
June 23, 2019 at 4:49 pm
If this column is not acting as a foreign key to another DB object(s) then perhaps my suggestion may raise eye-brows.
Add a new col, put the values that you wish...
June 23, 2019 at 12:55 am
I came too late into this conversation and I hope I make sense.
Option 2 is not bad. However, if I had to take that route then I would first create...
June 22, 2019 at 5:14 pm
Have you tried using client provider 10 to connect to your 2008 sql server?
That could be the problem.
June 22, 2019 at 5:01 pm
Viewing 15 posts - 1 through 15 (of 232 total)