Welsh Corgi (3/12/2012)

---

SQLKnowItAll (3/12/2012)

---

Welsh Corgi (3/12/2012)

---

Pam Brisjar (3/12/2012)

---

No problemo, Sean. But I do agree with you that we need to see the exact query that's producung the error. After all,...

GilaMonster (3/12/2012)

---

SQLKnowItAll (3/12/2012)

---

GilaMonster (3/12/2012)

---

It doesn't have to...

Lynn Pettis (3/12/2012)

---

From BOL:

C. Using the ESCAPE clause

The following example uses the ESCAPE clause and the escape character to find the exact character string 10-15% in column c1 of the...

GilaMonster (3/12/2012)

---

It doesn't have to be in...

Welsh Corgi (3/12/2012)

---

Pam Brisjar (3/12/2012)

---

No problemo, Sean. But I do agree with you that we need to see the exact query that's producung the error. After all, I could be...

That's true, but I would handle that from...

jcb (3/12/2012)

---

In addiction to input validation (maybe) you can put a TOP clause to prevent too many records to be fetched.

If its a web or web like app you can...

What happens when you run this query on the server directly?

SELECT * FROM Company WHERE EFF0YR = '112' AND EFF0MO = '09' AND EFF0DA BETWEEN '01' AND '09'

Welsh Corgi (3/12/2012)

---

The following works:

SELECT *

FROM OPENQUERY(LSCTLRDAT1, 'SELECT * FROM Company')

This does not work and I can't remember the systax to indude the WHERE CLause.

SELECT *

FROM OPENQUERY(LSCTLRDAT1, 'SELECT * FROM...

First, I would not be touching SQL services through services.msc. Only touch these services through SQL Server Configuration Manager. My immediate thought is that the service account was...

I don't think the question is how to pass SQL as a parameter. The question is why would you ever pass SQL as a parameter? What are you accomplishing...

You cannot use the MSSQLSERVER service account to login on SSMS unless that domain account has been added to logins on the instance.

ckelly 43038 (3/9/2012)

---

Thanks to everyone that has replied to me so far!

Today, during my workday, I created the attached create-table,insert-rows, and query-code TEXT file.

I've probably duplicated some of the...

Jeff Moden (3/8/2012)

---

jcb (3/6/2012)

---

Create a pattern, if your team mates can read it and understand it easy its a good pattern.

Returning two homonimal columns in a query is a nuisance,...

sqlfriends (3/8/2012)

---

SQLKnowItAll (3/8/2012)

---

sqlfriends (3/8/2012)

---

SQLKnowItAll (3/8/2012)

---

So, when you tell SSIS to use SQL Server Agent Account it is not using the domain account that you assigned to authenticate the service, it...