Been on PTO for a week, so didn't catch up to this thread until now...

Regarding the app that doesn't prompt for SQL password changes, depending on how big your company...

psc032802 (12/1/2014)

---

the end users in this scenario are people wanting to run the data profiling features. my original question was what needs to be installed and where does it...

This is getting seriously annoying. I tried switching out to a Script Task and again, this works in BIDS without an issue, but the SQL job seems to hate me...

Markus (11/21/2014)

---

Our main system was just upgraded from SQL2000 to 2008R2 in May. There was no way to have the user change their password in SQL2000 and/or make it...

Yikes! What kind of application spawns its own databases? And how many databases...

It is fair to say the concern that started this thread terrifies me.

In our environment, we don't give users SQL logins. We use windows authentication. SQL Logins are reserved for...

Koen Verbeeck (11/21/2014)

---

I'll repeat it again:

if you want to use...

A few thoughts.

1) Ask him what the primary purpose of his program is. He should be able to tell you this in one sentence. If he can't, then he hasn't...

If you don't have the Integration Services components set up on the machine in question, then SSIS won't work. Just because the Client Tools give you the option of logging...

Thanks, everyone. I appreciate all this information.

The argument appears to be won without the expected inkshed and tantrums. The Dev in question has fixes for the issue.

YAY!

Kevin, thanks for the links. Now I have more questions.

Is Primary Replica the database of origin or just the first replica that was set up?

Per the above link:

As soon...

Perry Whittle (11/13/2014)

---

Yes, both technologies require a functional Windows Server Failover Cluster.

Note that you may also use...

Shawn Melton (11/12/2014)

---

I will say that PASS Summit 2014 aired a quick start to AlwaysOn that I found very useful to fill in these types of gaps, check it out...

Steve Jones - SSC Editor (11/12/2014)

---

I've got limited knowledge here, but AFAIK, the Windows Cluster moves over those items that are clustered in Windows, which could be SQL Server. If...