The '05 Instance has security, however I am not the reporting person I am the DBA, however seeing as our reporting person left 2 weeks ago...I have picked up a...

I don't see how redirection would come into play. Either users would be typing the new server name, or old server name when connecting. We do have a sharepoint site...

64 bit

😀

I just dropped and rebuilt the database. It is a staging database we pull from an AS400 so there are no clustered indexes on them. Plus through various bits of...

Yup that was the problem. After doing this for 10 years you would think I would no not to trust Microsoft's auto generating scripts by now 😀

It just occurred to me as you sent that. I scripted the tables from the "generate scripts" feature of a previous poorly built database. I forgot it automatically scripts the...

Thank you! These articles did the trick. That is strange that in 2005 they were logging right out of the box yet in 2008 you have to set it for...

Wow resurrection from the dead 🙂

Yes I am aware of the security risks which is why I locked the excel workbook down hard and passworded the code (eventhough no one...

There is an issue with the logic of this solution;

You said you don't want to stop the error but want the process to keep running if it does error. The...

That is amusing in the fact that I JUST got into work and thought of that right before I read this lol.

Thank you for the help, that did the...

Stephen,

Again a great article, but if I could throw in one little tiny technicality to this I would feel much better 😀

While I realize the emphasis of your article...

Good article Stephen I am going to write the points down of this article in some notes I am gathering.

I wish that they would design the inverse of the...

GilaMonster (1/13/2010)

---

Welsh Corgi (1/13/2010)

---

I believe all that I need is an outer and an inner sub query with a SELECT TOP and an Order by clause to get...

GilaMonster (1/13/2010)

---

shannonjk (1/13/2010)

---

If you only want to return one row of data per account number, then why return the address or phone number or any other data? It would be...

Paul, I giggled when I saw that 🙂

To the original poster, the logic in the where clause is a bit strange but then we don't know your data 🙂

a.id1=b.id1

and a.lid1=b.lid2

and...