I would not do this. I would look at using Windows groups and assigning appropriate permissions to each of the groups. This leaves the administration of users with...

Evil Kraig F (3/26/2012)

---

GilaMonster (3/23/2012)

---

SQLRNNR (3/23/2012)

---

GilaMonster (3/23/2012)

---

You say that like it should be obvious it's a bad idea. I got so...

Do you have a DBA where you work? If you do, try getting some time to talk to him (or her). Let him know you are interested in...

Solon (2/21/2012)

---

What about restores to the primary database? I implemented log shipping on our reporting database, mainly just for testing purposes. This database gets restored nightly from our...

It also depends if you can identify the previous updates. For instance, the columns in the second table you are updating are null.

I think the UI would be the better place for this then, I don't see doing the conversion in the query being better for performance.

This means the package does not have the password to connect. Are you passing this in via a package configuration?

I will ask again, why can't this be handled by the UI? Why do you have to do it in the select statement?

xRafo (3/26/2012)

---

That data r results from a dynamic query,

well that result i input to a temporary table, and then i made a update.

my test query:

DECLARE @sql NVARCHAR(MAX)

DECLARE @colCampoREPLACE VARCHAR(MAX)

DECLARE...

Need details on how you deployed the package, specifically what type of security you used.

Looks like the password was not saved with the package.

xRafo (3/26/2012)

---

That data r results from a dynamic query,

well that result i input to a temporary table, and then i made a update.

my test query:

DECLARE @sql NVARCHAR(MAX)

DECLARE @colCampoREPLACE VARCHAR(MAX)

DECLARE...

Is there a similar build list for SQL Server 2008R2?

opc.three (3/26/2012)

---

Brandie Tarvin (3/26/2012)

---

Opc, you do realize I'm not the OP, right?...

One question for now, how is this function used in the calling SQL? Can you provide an example?

Not sure what you mean, could you please provide more detail?