Viewing 15 posts - 106 through 120 (of 9,725 total)
Let's start off with what I think the answer was: Stop & resume data movement.
With a large 40 TB database, yes, I could see this scenario RARELY. They don't want...
May 17, 2024 at 11:28 am
I have found it difficult to use the search functions here, actually. I often find myself trying to find a post or, more likely, an article I know I read...
May 13, 2024 at 11:45 am
And when I click on an email post alert (just now did it), it took me approximately 7 pages back on this thread instead of to the post directly.
I've gotten...
May 8, 2024 at 11:12 am
I really hope the OP got the problem resolved or called in an expert. If I were the client, I'd be steaming by now if my stuff was still down....
May 3, 2024 at 6:38 pm
Just to add my two cents in, I have seen a similar error many years ago with an older version of SQL and it was a certificate issue. The certificate...
May 3, 2024 at 11:44 am
Does the problem persist when using SQL Native Client instead of the OLEDB?
I've noticed the OLEDB for SQL Server in the wizard does funny things and stopped using it quite...
May 3, 2024 at 11:38 am
This is an availability group or a clustered instance?
May 3, 2024 at 11:32 am
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 pain.
May 1, 2024 at 5:21 pm
EXCELLENT. That gave me exactly what I needed. Vended solution services somehow set up inside of SQL Server.
Now I just need to figure out how to fix the problem, which...
May 1, 2024 at 5:17 pm
Big shop or small shop?
I was just reflecting this morning that the employer I currently work for has both. One small unit that has its own collection of DBAs, about...
April 26, 2024 at 1:52 pm
That did not come up in Google. I just looked at it, and the principal ID for all lines is dbo, not the SQL login in question.
Is "name" in that...
April 19, 2024 at 4:21 pm
And now the non-obsolete version that appears to work as well (possibly better?).
$IPAddys = Import-Csv C:\TEMP\FailedSQLLoginSearch_AllSvrs.csv | Select-Object -Property ServerName, LoginName, HostName -Unique
$results=@()
Foreach ($ips in $IPAddys)
{
...
April 5, 2024 at 3:01 pm
WHOO HOO! Figured it out. Needed to throw a hash table in there...
Thank you, Frederico. Without your code I never would have reached this. Now I'm just fiddling with user-friendly...
April 5, 2024 at 2:45 pm
Frederico, the expressions line you gave me isn't working for me. The information writing to the screen is " is unreachable." as if $n.NAME is null or empty and the...
April 5, 2024 at 2:10 pm
Viewing 15 posts - 106 through 120 (of 9,725 total)