RE: Steve... I think the key words you're looking for are in your last sentence. Those being... "when they were first released". In time Vista adoption will advance...

Are you declaring rtnval anywhere in your code?  Also, Try declaring it as an output variable.  That should do the trick for you.

Ahh gotcha, It seemed from your post that all of this was occurring on the same machine.  Not 2 separate ones...

I'm guessing you've already gone through the configuration, making sure...

I suppose it could take that long depending on your hardware, how busy your db is and if there are any indexes involved...  Also, are both of your zipcode columns...

I don't have a whole lot of info on this, but hopefully this will point you in the right direction.  I vaguely remember when I was playing with SQL Server...

Yeah, that's true.  I didnt' really think about the scope aspects of it.  As for not using them, unfortunately the individual who designed the database I must now support liked...

Thanks for the vote of confidence.  I guess it just seemed sort of strange to me to be referencing the same table by 3 diferent names... t1,t2,t3.  Obviously with no...

Yes, that should work.

OK, the domain username and password that the SQL service is just that.  It's just a username and password.  Like any other process, when the SQL service(and sQL agent and...

Sure as long as your change the domain password as well.  I wouldn't see why you wouldn't.  In other words, once you change the domain password then make the changes...

not really, no.  You don't have to do anything with the control panel/services bit...  You can, but it's really not advised, only make the change there if you plan on...

Using either SSCM or Enterprise Manager are the preferred ways.  That way you don't need to do all of the extra steps from the KB that Jo gave you.

Just my $.02...

Michael Valentine Jones was correct about the bug, and that's typically how i'd write my code.

As to Raymond, that would work,...

Hey Colin, thanks for the response.  So far I have it configured with just the /3GB switch and I'm not really seeing what I was expecting to.  Originally the max...

Perfect, the first link helps a lot.  Unfortunately, I beleive that I'm running the standard ed of windows server.  and since I'm only using 4 GB of RAM I don't...