Also, is your OS updated to SP2?

So, this is 2008, not 2008 R2?

Ok, you'll have to pick apart the joins. I, of course, probably made more than 1 mistake. Copy and paste this into an empty query window. Delete the...

There's your problem. Good luck to you.

That's why I think...

Yeah, it is a fairly generic script that you have to tailor to your needs. I would take that part out of the script. As far as removing it,...

siva 20997 (3/6/2012)

---

I am pursuing my methods and developing applications

The T SQL Logic which every one seems to want is effient code

What they dont seem to reaalise is that it...

skrilla99 (3/6/2012)

---

Hello,

I have two SQL Server 2008 R2 EE instances particpating in transactional replication. The setup is pretty vanilla, with no updating subscribers. However, when I re-deployed the...

Lynn Pettis (3/6/2012)

---

Just food for thought. If the procedure(s) have been working well for months (or longer) and then suddenly start having issues, it could be a result in...

adiehl (3/6/2012)

---

Thanks for all the help, if we have more issues maybe my company can hire Jared! The other consultant was specifically for Talend and I'm not sure that...

Sean Lange (3/6/2012)

---

adiehl (3/6/2012)

---

Funny thing is, a consultant did create that! I was hired to create reports based off that view. They have created a non-normalized table based off...

MR@SD (3/6/2012)

---

See, I would use TA_Id or something to shorten it even more. Some may say it is less descriptive and may confuse someone new to the code and...

mtillman-921105 (3/6/2012)

---

i wouldn't want to tackle this myself.

But, as sort of a hybrid approach, if you could at least provide a skeleton of the tables and add customizable...

Don't forget that a schedule can be created outside of SSMS to kick off a job. So disabling the schedule can give control to something else. Now take the case...

MR@SD (3/6/2012)

---

David, taking your example, TrailerActivityHeaderId and TrailerActivityHeaderTrailerNumber are not the names I would vote for. I would not name a table TrailerActivityHeader but TrailerActivity instead (Header is implied). Then...