Viewing 15 posts - 1 through 15 (of 13,419 total)
if you are comfortable with PowerShell, this example command will get all end users, including those that are members via a group-within-a-group:
here i am assuming you found a group named...
March 21, 2024 at 1:42 pm
see if this script can help you visualize the actual blocker(s).
this is what I use, I am sure I picked it up here on SSC and further enhanced it. for...
February 24, 2024 at 3:19 pm
it's permissions.
you have permissions, but the account running the SQL service does not.
regardless of who is running the SQL command executing xp_cmdshell, once outside of SQL server, xp_cmdshell runs as...
February 18, 2024 at 6:49 pm
a piece of the puzzle here is connectivity. are you already using cnames to point to the server, so with a simple DNS change, you can say PRODSERVER points to...
February 18, 2024 at 11:07 am
the SQL2022 CU11 patch potentially covers SSRS and SSAS as well. as a result, I would recommend the following:
February 18, 2024 at 10:44 am
start at the basics: can we narrow it down to see if it could have been a DBA process or a Business process?
did you have a scheduled job for statistics,...
February 15, 2024 at 11:43 am
In my environment, i have a very similar need, but much more robust.
...
April 15, 2023 at 2:36 pm
On SQL2019, i get an error trying to compile the code.
Msg 13822, Level 16, State 1, Procedure MyOpenRowSetTest4, Line 4 [Batch Start Line 7]
File 'd:\downloadedfiles\filethatdoesntexist.txt' cannot be opened...
April 15, 2023 at 2:21 pm
Login failed for user 'brainiac' is the key.
EXECUTE xp_readerrorlog
and find out the specific reason why the login failed. it will tell you exactly the problem on the next line AFTER ...
January 31, 2023 at 11:39 am
if the SQL Service is stopped, one of the things it does is puts a pointer in thelog, to track what is committed or not committed as far as transactions...
November 8, 2022 at 12:09 pm
you'll want to change the definition of @VbCrLf from VARCHAR(2) to something larger, and like this, maybe?
and make sure it is not being re-assigned to CHAR(13) + CHAR(10) later.
you'll end...
September 15, 2022 at 5:47 pm
this is a typical permissions thing in SSRS. you want to connect from the server itself, and then add your domain group or domain logon to fix that.
it follows the...
June 6, 2021 at 12:08 pm
on the server that is running the SSRS Service, you should find the Reporting Services Configuration Manager.
run that, and there is a tab to show you the database it connects...
June 5, 2021 at 12:07 pm
it might not be obvious, but the query is assuming a monday thru friday work week.
so if today is monday, i want errors from Sat + Sun + so far...
June 5, 2021 at 12:00 pm
SQL will do the locking for you automatically, depending on what you update;
SQL will figure out if it needs to lock a few rows, pages or even the whole table,...
June 4, 2021 at 2:32 pm
Viewing 15 posts - 1 through 15 (of 13,419 total)