Viewing 15 posts - 16 through 30 (of 13,422 total)
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
ok try this:
this returns only jobs whos last status was failed.
ignore the extra variables in there, it is an artifact of a process I run that gets the fully qualified...
June 4, 2021 at 2:22 pm
because of the forum, the two tags i added: < a > and < / a > must have the white space removed. with whitespace, it's not valid xml and...
June 4, 2021 at 2:17 pm
sure!
here's a handful of examples.
you can use the filter to search for exact or like statements, using asterisk as the like character multiple domains,
two of the examples have the examples...
June 4, 2021 at 2:11 pm
when you get really big strings like that, and want to visualize them in SSMS, you can TRY_CONVERT to xml; then when you click it , it opens in a...
June 3, 2021 at 3:18 pm
for the query below, the h.[run_status] is what determines what was successful/failed/inprogress.
add the filter to limit it to failed only, and change the date range.
--desc: gets job...
June 3, 2021 at 3:07 pm
definitely use PowerShell for this;
here are two examples I use constantly:
Get-ADGroupMember -Identity "CoolestGroup" | Out-GridView
Get-ADUser -Filter {(Name -eq 'steve.jones')} -ResultPageSize 50 -Properties * |
...
June 3, 2021 at 2:58 pm
i suspect you are missing two pieces of the puzzle.
to use database mail, any non-sysadmin active directory user (or more preferably, the AD group they belong to, have to be...
March 16, 2021 at 2:49 am
the issue is most definitely that the SQL service is running as a local account, and not a domain account.
SELECT * FROM sys.[dm_server_services]
when you run any TSQL that accesses a...
February 11, 2021 at 7:21 pm
a few things to check if polybase is not able to start;
on my developer edition box, I had to make sure TCPIP connections were enabled, which is not an issue...
December 21, 2020 at 4:58 pm
the stack overflow article mentions bugs in SSRS 2008R2(and maybe SSRS 2012), so the first part does not appear to apply if you are running SSRS 2014.
The second part, where...
December 21, 2020 at 2:26 pm
so if you use the report, it works, but when run as the automation account, it fails, right?
sounds like permissions.
check the data source for the sub report. it should be...
December 21, 2020 at 1:33 pm
i see your strategy, simply filter with a WHERE statement to process just the desired rows.
I suspect you just need a decent cursor model? here you go!
create...
December 20, 2020 at 1:13 pm
Viewing 15 posts - 16 through 30 (of 13,422 total)