Grant Fritchey (8/4/2015)

---

xsevensinzx (8/3/2015)

---

In my years working in software development from a marketing perspective, the right way always seems a bit too subjective from the people who are advocating change....

Then you have a...

Alvin Ramard (8/3/2015)

---

Ed Wagner (8/3/2015)

---

Sean Lange (8/3/2015)

---

Again lots of complaining. Come on people get over it. The question of the day is intended to provoke some learning. Guess what, as...

I just left a position because I got tired of hearing "That's the way we always did it" AND 'We don't have time to do it right".

Together, those sentences said...

Ed Wagner (8/3/2015)

---

Jeff Moden (8/2/2015)

---

Switching gears, I submitted two sessions for the upcoming SQLSaturday in Pittsburgh. I really enjoyed the folks out there and hope I get selected. ...

Jeff Moden (8/17/2011)

---

Jayanth_Kurup (8/17/2011)

---

Probably not in production. While there are secure ways of using xp_cmdshell. I can't/won't trust everybody to use it the way its meant to be. I could...

bryan.holmstrom (7/30/2015)

---

HI,

I have added the update as follows:

WITH CTE_Concat AS

(

SELECT lb.ListID, lmb.EntityID,

STUFF((SELECT '; ' + lb.ListName

FROM ReznickGroup_MSCRM.dbo.ListMemberBase lmb

INNER JOIN ReznickGroup_MSCRM.dbo.ListBase lb ON lb.listid = lmb.listid

WHERE lmb.entityid =...

You need to do something with the CTE. Add the update after you create the CTE

WITH CTE_Concat AS (

SELECT lb.ListID, lmb.EntityID,

STUFF((SELECT '; ' + lb.ListName

FROM ReznickGroup_MSCRM.dbo.ListMemberBase lmb

INNER...

I'm not sure if this applies or not, but I had the same issue with SQL 2008 on a 6 node (5 active, one passive) cluster.

http://blogs.msdn.com/b/psssql/archive/2010/07/09/why-is-my-sql-clustered-instance-changing-authentication-modes.aspx

I have 6 questions and could grow, and since each question has its own comments box that is made visible based on user's response, how will just one comments field...

Ok, the questions table is not bad? What is qID? qText? Would Question_ID make more sense to someone? How about Question_Text?

In code, nobody but a programmer ever looks...

For starters, your names are HORRIBLE.

Please take a look at your tables and names. Spend a few minutes and make them meaningful. I mean meaningful to someone other than yourself....

Al.Pacca (7/15/2015)

---

Hello, thanks for the quick reply,

Is it the file tab only which need to edit - okay,

Is it okay if i safe the 2 files with a new (different)...

Not sure why this recommendation is being made by MS.

I have never granted sysadmin to the...

I've been down that road also!

If you keep going on this thread, as well as others, the "answer" is to drop the trigger, drop the publication and subscription, and re-do...