SQLRNNR (9/30/2015)

---

Ed Wagner (9/30/2015)

---

Brandie Tarvin (9/30/2015)

---

SQLRNNR (9/30/2015)

---

Eirikur Eiriksson (9/30/2015)

---

WayneS (9/30/2015)

---

Luis Cazares (9/30/2015)

---

ChrisM@Work (9/30/2015)

---

Brandie Tarvin (9/30/2015)

---

ChrisM@Work (9/30/2015)

---

An unsolicited email has just dropped into my Hotmail inbox from a recruitment agency touting...

Eric M Russell (9/24/2015)

---

As a side note, it appears that SQL Server does take at least some measures to respect the intent of stored procedure compiled using the "with encryption"...

Steve Jones - SSC Editor (9/23/2015)

---

With the obfuscation easily bypassed (SQL Compare Pro[/url] does it), what is the protection? What do you think clients will do with the intellectual property?...

Rod,

That's a great job summing up the...

Without knowing all the requirements and what exactly you need to do it is hard to say how I would do it. Typically when I write an SSIS package...

Okay, I'm going to give the instructor the benefit of the doubt. Maybe lesson 1 is cursor and lesson 2 is set-based and there will be a discussion of...

Luis Cazares (9/18/2015)

---

The correct way of getting points 1 to 3 would be like this:

CREATE PROCEDURE [dbo].[ap_CalcGrade2]

-- Add the parameters for the stored procedure here

@studId...

I don't necessarily agree with those who say don't use an offer as leverage or say don't accept a counter. I think it depends on the situation. If...

Ha ha. I replied to that one as well. I...

It wants to know what database to execute the command in. If you have USE in your script then you can just provide -d master

It would be helpful if you were to provide the DDL for the tables involved, along with some test data.

There are 2 reasons you are getting the first pair of...

Are you trying to set the Connection property of the Execute SQL Task or the ConnectionString property of the Connection Manager?

What I believe you want to do is...

The key part is the clustering. A lot of people don't realize that you have to have a windows cluster for AlwaysOn.

Based on your code it looks like this procedure is part of a series of actions that are all part of the same transaction. This could be part of...

Would a comma delimited list of decline reasons be an acceptable solution? If it isn't then Gazareth's suggestion(s) are the best ones. If the decline list is basically...