If I remember correctly, you should re-configure the connections which before the protection level changes, where using the users credentials.

If you are using a SSIS configuration settings, walk through...

Did you try to expand the Favorites (first on the list in the toolbox)?

😎

Looks like the protection level is set to "encrypt with user key", if moved to another scope, it will fail.

😎

It is a simple base36 to base10 number conversion.

01Z(base36) == 71 (base10)

😎

bugmesh (4/3/2014)

---

Woke up and sprained my brain this morning. That's the only reason I can think of as to why this popped into my head.

Has anyone used a Raspberry for...

One small change needed

<td><xsl:value-of select="sum(../../*/*/costs)" /></td>

😎

todor.belchev (4/3/2014)

---

Hi,

I want to use a third party component in my SSIS package but I don't want to install it on the SQL server. This component is installed on a...

Quick translation (Google Translate style 😀 )

;WITH NUMS(level) AS

(SELECT N FROM (VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10)) AS NM(N))

select sum(C.position_value) from

(

select

power(36,B.position-1)...

Jeff Moden (4/1/2014)

---

If you're going to tell people that, then you need to tell them...

Sean Lange (4/2/2014)

---

Ditto 😎

Using stored procedures is a good practice, a) how it retrieves the...

First thing that comes to mind is a disk space or (EDIT) VM max size config kind of problem.

MY_TWO_CENTS

Naming conventions are primarily to enforce consistency, readability and prevent ambiguity. A good solid naming convention is worth hundreds of pages of documentation on a large system.

😎

This should work on 2K5

DECLARE @XML XML = N'<DetailRows>

<DetailRow>

<MonthNumber>1</MonthNumber>

<Amount>1000</Amount>

</DetailRow>

<DetailRow>

<MonthNumber>11</MonthNumber>

...

Correct 😛 found everything about it on BOL under AFD....

Luis Cazares (4/1/2014)

---

I'm not sure that I agree with Eirikur about saying "it depends". I'm sure that cursors are always hard on servers, but some methods can be worse (e.g....