Based on the...

vicki.k.noble (6/12/2012)

---

Hello,

I need to change a calculation of a metric I have to do a three month average in a stored procedure. However, the other metrics in this SP are...

Okay, blind. Didn't see that the first time I read your post....

Siva Ramasamy (6/12/2012)

---

Hi,

Thanks for looking into my question.

I am getting this error in the SQL Server logs.

06/12/2012 10:00:37,Logon,Unknown,Login failed for user 'sa'. Reason: Password validation failed with an...

You should look at setting up a table constraint.

Koen Verbeeck (6/12/2012)

---

Lynn Pettis (6/12/2012)

---

Why would I use a script component when I can...

Duplicate post, more answers here.

Have to agree, clear as the Hudson River.

What the heck are all the X's? There is nothing to say what they mean.

Please, following the instructions in the article in...

I have a question, what answer did you give in the interview? To be honest, I personally...

Lowell (6/12/2012)

---

i would create a role like this example, and then add your user dtAdmin to that role:

Create LOGIN [dtAdmin] WITH PASSWORD='NotTheRealPassword'

USE [WHATEVER]

Create USER [dtAdmin] FOR LOGIN [dtAdmin]

CREATE ROLE...

polkadot (6/12/2012)

---

The problem is complicated by this: the values I need to retain (before the first backslash) also have a prefix that needs to be removed.

So two things need...

Koen Verbeeck (6/8/2012)

---

Because once in a while, you get replies like these:

Koen,

You rock! It worked for me! The solution I have found by following the link you provided, http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/65112/, totally...

It is going to be something simple, pretty sure of that.

Can you post the steps (code included) that you used. Sanitize it as necessary, but it should still be...

Just a little quibble. CTE's don't start with a statement terminator (;). Here is the code you posted slightly modified.

exec sp_executesql N'

DECLARE @d datetime;

SET @d = @MinDate;

WITH MainServices...

sonia.burns (6/12/2012)

---

No joy unfortunately, I started over recreated the security and the endpoints (there is no encryption btw). Ensured that the endpoints had started, ran the grant on both servers...