Viewing 15 posts - 151 through 165 (of 9,244 total)
Aside what Fredrico stated, setup a credential and proxy for the agent job step exec type and run the job step under the proxy ensuring it has permissions granted where...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 2, 2024 at 10:49 am
Each product page lists the OS requirements and upgrade paths, compatibilities, etc. Example here
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 2, 2024 at 10:13 am
Which system databases did you copy?
all I can do is point out that SMKs and DMKs should not be restored across instances and if done correctly there’s actually no need...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 2, 2024 at 10:01 am
Comment out the if block and try printing the contents of the $Row var see what’s inside it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 2, 2024 at 9:46 am
If you cannot switch the sql server service to use a domain account, you'll have to grant the file share to the computer account.
OP confirmed that already, likely lack...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 2, 2024 at 5:32 am
Glad you got it resolved Brandie
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2024 at 6:29 pm
I believe the truncate needs to take a sch-m lock on the table, not just the partition. Even switching the partition into an empty holding table requires the same...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2024 at 6:21 pm
And the user just informed me that two of the four lines I found are "old" services. Which makes me wonder if this isn't the source of her testing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2024 at 6:18 pm
Run the tasks in series?
that too, but more overhead than required considering partitions can be slid out
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2024 at 4:51 pm
Why are you truncating partitions and loading them why not just use the partition sliding window to move partitions along and drop any you don’t need
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2024 at 4:33 pm
sqlserver service account is running under LocalSystem Account on the destination server
I guessed so if agent is running under that too, so have you checked the ACLs at the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2024 at 4:29 pm
there is an Auto_Stats ext event under the execution category, track the incremental and sample_percentage columns
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2024 at 4:24 pm
if (Test-Path -Path "$($Row)")
{
Throw "File exists"
}
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2024 at 3:45 pm
They should both support the same record set operations so change the connection providers and rebuild the project then test
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2024 at 3:09 pm
Path is not passed is it the intention to use a local drive as it’s not specified clearly in the 2nd script.
Bit more info on what it is you’re trying...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2024 at 3:04 pm
Viewing 15 posts - 151 through 165 (of 9,244 total)