you could automate this. I'd create a new table to store the data you need (or tables) and include a datetime field in this table as well. Do this in...

Jeff handled that well and got a nice reason.

No issues. These get cancelled. You could even restart the server and you'd be OK as if you never ran it.

Adi is correct, it's valid in 2000. http://msdn.microsoft.com/en-us/library/aa259185(SQL.80).aspx

Can you post the code you're using?

Also, double check the instance you are on is SQL 2000. Select @@version. And look at the...

No, the release on 2010 is slated for 2010 1H, or first half (Q1 or Q2).

2011 is the guess for SQL 11 (SQL server 2008 is SQL v10)

Good list of new benefits.

I worry about profit sharing since how much contribution does each person make, and how many others have on that idea. That can fragment a team...

This will insert based on the result set, which will start from 1.

Also, please note your name and the poster's name are in the same position relative to the post....

For those of you that have asked questions of Jonathan (the author), be aware that he went to Marine Corps Boot Camp last week as part of his Reserve commitments...

I'll answer for myself, but interesting comments above.

I started in this business by reading a lot and asking questions on the MS public Usenet back in the mid 90s. I...

Jonathan's at boot camp, be back in a couple weeks, so we'll see if he gets this.

I definitely felt the "ego" in that thread, someone that wanted to drive the...

2010 is supposed to be first half (1H) of 2010 and it's a Data Warehouse, point release. Not a full upgrade, at least not now.

The first PASS Summit in 1999...

I thought this might go sideways. 😉

I'm torn on the union issue. They've been done poorly, but they have brought about changes and benefits that we wouldn't have. Don't forget,...

I think I'm about to spew coffee on the desk. C'mon, Friday morning, really did we need that image :hehe:

Grant Fritchey (3/6/2009)

---

It's the dumbest thing in the world that I'm expected to bring my happy shining face into the office so that I can spend the entire day with...

continue, we must.

write, we continue.

Sorry, had Yoda in my head this morning.

Nice catch on the plagiarism, though there is an acknowledgement in there for another post.