it.web (5/20/2013)

---

What I was looking for was a visual interface much like visual studio is to .net. Sure I can write sql if I have to... but why do it...

Sean Lange (5/20/2013)

---

I don't think you need dynamic sql for this to work. You just need to get the right syntax. If you had posted the error message it would...

KoldCoffee (5/20/2013)

---

In that case I was trying to learn cursors, and there was no better way. I even prefaced and said something like, I don't want to be talked...

Sam -480699 (5/20/2013)

---

Bit of an old thread, but issue we have had looks to be a known SQL 2012 bug. I have found the blog:

http://www.travisgan.com/2013/05/sql-server-2012-simple-recovery-model.html

Seems this issue will...

KoldCoffee (5/19/2013)

---

Ah yes Lynn, I was wanting to learn cursors back then, not defend my use of them. Cursors are bad RBAR for the most part, but they have...

KoldCoffee (5/19/2013)

---

When the response from the poster becomes "I don't need that information just focus on the question I asked" when in reality that's what was being done, we all...

Like2SQL (5/17/2013)

---

Lynn Pettis (5/17/2013)

---

Like2SQL (5/17/2013)

---

I may be wrong but is there a trailing space in the name db10? Above in brackets it looks like this: [db10 ] indicating a...

Greg Snidow (5/17/2013)

---

it.web (5/15/2013)

---

What I would now like to know is if there exists for SQL server a visual tool to help me build my queries like there is with...

Like2SQL (5/17/2013)

---

I have a maintenance plan which is set to backup all databases on the server to a network path D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\SQLBackups. In this path, it creates a...

erikd (5/17/2013)

---

Hi,

I'm trying to follow the instructions for this article:

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/91665/

I got to the part where I'm setting up the script task. The article says to use MS C#, but like...

Denise McMillan (5/17/2013)

---

I think I can't get what I need because what is in the 3rd table is not related to any one item in the joined a and b...

Or...

Looks to me like database mail isn't properly configured under 2008 R2. Just a guess based on the error posted, but Gail is right, we need to see the...

Denise McMillan (5/17/2013)

---

I tried using the convert and distinct. It runs but still gives me all the duplicate records. I also tried putting the results of the join on...

Grant Fritchey (5/17/2013)

---

Lynn Pettis (5/17/2013)

---

I have had to turn of SQL Prompt here at work as it sometimes...