GilaMonster (11/14/2016)

---

Jeff Moden (11/13/2016)

---

Ask Steve to give you the...

Jeff, something tells me you had fun with this one. 😀

s0da9 (11/13/2016)

---

Adi Cohn-120898 (11/10/2016)

---

Can you check the server's error log? By default it is configured to write into the error log details about failed logins. You'll be able...

When you're writing your NOT EXISTS to check for duplicates, I'd test the performance of it against an EXCEPT. I've found that many times, the EXCEPT is faster. ...

TomThomson (11/12/2016)

---

Jeff Moden (11/3/2016)

---

The question now is, did they update the script generator to reflect this new capability? Probably not. I also think it's interesting that they'd spend...

Eirikur Eiriksson (11/12/2016)

---

Jeff Moden (11/12/2016)

---

Indeed it has been. I've personally hidden about 100 spam posts in the last 4 to 5 hours. ...

To build on what Jeff said, I'd at least hold each client to their own standard. The more clients adhere to your standard, the better. If you can't...

The Breaking Change is located at https://msdn.microsoft.com/en-us/library/ms143179.aspx. It also contains links to the same page for other versions, so you can go through them for SQL 2008, 2012 and...

Eirikur Eiriksson (11/12/2016)

---

To me it looks like a Maintenance Plan related error, strongly suggest to switch to Ola Hallengren's SQL Server Maintenance Solution[/url], much more robust.

😎

Question, what if any errors...

You might wants to select the number of absences and also handle the case where a student has more than 3 absences. According to your original post, students with...

Phil Parkin (11/12/2016)

---

And still you refuse to ask a question. Are you expecting people here to help you with the entire solution, from start to finish? I'm sorry, but that...

Faith

There are many different features introduced in later versions of the SQL language. A couple of very notable ones for me where the LEAD and LAG windowing functions introduced...

sgmunson (11/11/2016)

---

SunglassesAtNight (11/10/2016)

---

An excellent thought. I thought maybe the Service account on my local installation may have been different but alas, the service accounts for both my local installation...

Sean Lange (11/11/2016)

---

Phil Parkin (11/11/2016)

---

I'm not sure for how many...