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,...

In my environment, i have a very similar need, but much more robust.

• I need to script out the current permissions from a development database
•  restore a database from prod,

...

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...

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 ...

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...

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...

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...

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...

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...

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,...

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...

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...

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...

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...

• This reply was modified 3 years, 5 months ago by  Lowell.

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...