mtassin (8/10/2009)

---

GilaMonster (8/10/2009)

---

mtassin (8/10/2009)

And who determines who should be in the group? If it's forum ranking alone, there are several people (who shall remain unnamed) with over 1000 points and...

Or something like this. Uploaded as an attachment as I am having problems posting it directly.

Are you inserting a new row or updating the existing row (ie there is only one row in the table)?

Totally different subject! I suddenly can't wait to get home tonight (not that I don't look forward to going home :-P)!

We just received some letters from Kassondra. Looking...

WebTechie38 (8/10/2009)

---

Hello,

I have a big database that needs to be backed up. The combination of the .mdf and the .ldf should be around 55 GB or so. The...

timothyawiseman (8/10/2009)

---

Andy DBA (8/10/2009)

---

I agree with Tim that many readers will assume endorsement by SSC and might not read any of the comments or even be aware of their presence....

John Paul (8/10/2009)

---

Updated code : and According to my understanding

returns one row per Country Code with three porttypes import type columns

For each class the ports import...

True, but we work with what we are given, wether here on SSC or at work. 😉

jacroberts (8/10/2009)

---

Lynn Pettis (8/10/2009)

---

LP (8/10/2009)

---

Absolutely agreed. Very dangerous article espesially...

Not only that, it looks like we could completely drop the #ProductDetail table, as it adds nothing to the query from what I can see.

I can't get the information for Panasonic from the data in your Product and ProductDetail tables, they don't exist. Also, Mark's code is very close to what you are...

LP (8/10/2009)

---

Absolutely agreed. Very dangerous article espesially for newbees. Better...

Bear with me, have you checked to see wha the system table says:

select * from sys.server_principals

I can't recreate your problem, so I am having to guess here.

How are the users connecting to the database? is this an application using ODBC/OLEDB, SSMS, something else?

Is it possible that there needs to be a change on the user...

steve_melchert (8/10/2009)

---

> It really is up to the authors to seek out peer reviews of their

> articles before publication. The editor chooses to publish submitted

> articles with...