That's odd. usually the login shouldn't be slowing it down, especially in SQL 2000. There must be something that's not happening in sa, but can't think about it.

If you can,...

The only thing that seems off is the GameTeam table. Why do you just not have two teams in the Game table thet FK back to the Team table? There...

I use CTRL+R to whack the results in demos and quickly get back to the coding window.

You'd also have to store passwords as characters, likely plain text or ever so slightly obfuscated. If you do any conversion to binary, you can't have case insensitivity.

A big security...

Ugh, my apologies. In the copy/paste, I lost C somehow.

The option was supposed to be c) get me out of here ASAP

Strange. If you give another login, perhaps a db_owner, but not sysadmin, is there a change?

Any chance of client side tracing through ADO?

Revenant (5/31/2012)

---

jarick 15608 (5/31/2012)

---

It's like a mechanic says, "Pay me a little now or a lot later." Companies are overly concerned with the next quarter's profit statements at the...

In addition to Sean and Lynn's advice, buy a book. Work through it page by page. You'll learn a lot.

Pick a few problems to solve. For example, read the SSIS forums, find a question on scripting and try to solve it. Or re-implement it on your system, using someone...

Fat Tire is my current favorite, but I do enjoy an Avalanche Ale as well. Mostly looking for Amber ales when I'm out of CO

For cooking, I'll boil brats in...

Honestly, I'm not sure. We started the site with the idea of sharing knowledge, of writing about things we'd solved (Andy, Brian, myself) and helping others. We found quickly that...

That's 50 Australian Sheep Dollars. Known in the US as monopoly money.

It depends on where the block is. If you have this:

data data data data data bad block (free space) (free space)

you could be fine. If you have...

jerry-621596 (5/31/2012)

---

That completely depends on what you want SQL Server to do should it stop running for some reason. I have mine set to attempt to restart every time...

As Lynn wrote, you need an ORDER BY clause. There is no guarantee of ordering at all, from one execution to the next, of the rows returned without that clause.