I'm on the SQL cruise with limited internet, but i'll put together an article;

I tend to shy away from articles, hate getting criticism.

At my job, we just joined two AD...

in my case, I remove the users and logins from SQL Servers, but they stay forever in Active Directory.

I've got a nifty powershell i wrote that imports Active directory data...

there is a neat opportunity here to use the OUTPUT clause;

it allows you to capture things like new guids or identities into a table, and then consume it on a...

hlrx (1/25/2016)

---

GilaMonster (1/23/2016)

---

Yes...

vsamantha35 (1/25/2016)

---

Hi All,

Today came across an issue. Database mail alerts on job failures was not been sent. Checked the dbo.sysmail_faileditems and found that it was failing with authentication error.

Basically,...

if you added a table named Customer_Invoice, you would get the error

Luis hit the nail on the head: you...

untested, but this might give you an idea.

percentage is # ontime / Total,typically limited by a period of time (a month?)

due to integer division in SQL, you need to convert...

nice solution from Hugo, as always;

for me, i really hate running totals stored in the table itself; plus it's breaking some of those rules for normalization, of course.

eventually, the...

i'm betting Sean Lange's suggestion that your left join converted to inner is your core problem:

modify your join criteria like this, doe sthat solve the issue?

SELECT

ord.CustomerId,

...

User2 has to be created with the correct roles and permissions in the new database.; permissions in the old db would not make any difference;

sounds like he has rights...

i think this is an Oracle question ffor the psuedo column rownum that is materialized in that RDBMS:

https://docs.oracle.com/cd/B28359_01/server.111/b28286/pseudocolumns009.htm

Conditions testing for ROWNUM values greater than a positive integer are always false....

it is absolutely allowed, and works...

rownum would have to be a real column name, right?

if it is an alias for the row_number() functions's results, no results would occur if your table only had...

there is no alert for that specific condition(where a spid exists with value = -2.)

so you cannot use Alerts, specifically.

for specific events you can capture, you can have an event...

it looks like you've got a process, maybe a sql job or windows scheduled task, that runs every five minutes?

might also be an application or Service, installed on the...