Here's a good summary as well: http://msdn.microsoft.com/en-us/library/dd535534%28SQL.100%29.aspx

If you explain what you don't understand, we can help you, but your question is so general right now that a reference is the...

Sean is correct. SQL Server only has the information about which account logs into it. If the application proxies other users, then you would need to modify that application to...

Sean's idea of distinct is good, but you also shouldn't write joins like that. It's easy to implement a cross join somewhere.

Move to an ANSI standard, like this:

select DISTINCT

...

OK, here are the current top posters:

SQLRNNR - 2567

GilaMonster - 1957

Lynn Pettis - 1775

Alvin Ramard - 1745

Steve Jones - SSC Editor - 1434

Grant Fritchey - 1427

Jeff Moden - 1258

GSquared -...

It's lightweight and long battery. If you're not the go, it's a handy tool for making quick notes.

However it's mostly a consumption tool. I've used mine to browse web sites...

This usually happens with upgrades from 2000 into a newer version. Correcting it is just setting the fields/rows to a valid value

http://support.microsoft.com/kb/923247

Set up accounts: http://msdn.microsoft.com/en-us/library/ms143504.aspx

Verify permissions: http://msdn.microsoft.com/en-US/library/ms144238%28v=SQL.90%29.aspx

I completely agree with Brian. don't grant domain admin. Use the Config manager to set the rights.

Brandie Tarvin (6/15/2011)

---

Roy Ernest (6/15/2011)

---

Our user group is planning to have a SQL Saturday in our tiny island. We are aiming for 25th of February, 2012. It is the week...

MVPs require a nomination. I guess you could nominate yourself, but typically it comes from someone else.

MVPs have the easiest route to nominate others, but no idea if that...

Ha! I can't just add points. Though maybe a Question of the day worth 3,000 points 😉

Actually it will be at least into July. Jeter went on the DL for...

For the record, I never do

SELECT *

It's always

SELECT top 10 *

😉

Trey Staker (6/15/2011)

---

It would also be interesting to see the post that has the most previous quotes in it. This one I think has 7 so far... I bet...

Brandie Tarvin (6/15/2011)

---

Yes way.

For example: If you haven't figured it...

For the first one, it would help to get some more context on what the question is based on. There are some diagrams on the overall architecture, like this one,...

Servers Alive is a nice tool for this

http://www.woodstone.nu/salive/