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

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

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

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

• This reply was modified 4 years, 6 months ago by Lowell.

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

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

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

• This reply was modified 4 years, 8 months ago by Lowell.
• This reply was modified 4 years, 8 months ago by Lowell.

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

To leverage the Alias, I think you would need to either use a common Table Expression or a sub query to expose the alias to the next statements.

Alais's are evaluated...

I think what you want to do is to use a CASE statement to evaluate the b.score: if it's less than zero use zero, else use the b.score

            
December 20, 2020 at 12:38 pm
            
#3822562

            
            
                                                
        

I cannot think of something out of the box that does this, third part or not.

i think you have to do this manually, and it will be a bit of...

if the database is in SIMPLE recovery mode, it goes back to whether the database is currently accessible or not.

you could restore last nights backup as a new database name,...

so SQL server has a lock on the mdf/ndf/ldf files because they are in use, so are you really, really sure the mdf was encrypted?

is the database currently up and...

no help for the specific error, but structure wise, here's some help.

If you are using SUM,MIN,MAX,AVG you need a GROUP BY statement, and a column to group by.

All columns in...

• This reply was modified 4 years, 12 months ago by Lowell.
• This reply was modified 4 years, 12 months ago by Lowell.

i think sp_helprev_login has been the go to solution for years for logins.

database permissions are stored in the databases themselves, and those are scriptable from SSMS , and if you...

• This reply was modified 5 years, 1 month ago by Lowell.
• This reply was modified 5 years, 1 month ago by Lowell.