Here's an article that might help with the decision process:

http://www.sqlservercentral.com/articles/Career/61543/

And just an FYI, if anyone wants to reply to my post on the cursor issue, PM me and I'll start a new thread so we don't get completely off...

Jeff Moden (12/5/2008)

One situation was / is...

Yeah, Jeff'll never hire me. @=)

Actually, I must point out that I've run into one or two...

Opps! I didn't realize there was a page 2 to this thread until after I posted. My bad. :blush:

Sorry, Guys. Didn't mean to reply to replies that were already made.

The issue is that the SQL login is just that: a SQL (non-windows/non-network) login. Because SQL Logins aren't mapped to domain accounts, they aren't able to see network drives.

Change your...

SP2 isn't necessarily an all-or-nothing process. It has patches for all the possible components, which means some could get installed while others might not have gotten installed at all.

Further point,...

Interview question?

Well the answer depends on what job you're interviewing for. Employers will consider their needs first when looking at the answers provided by the interviewees.

Personally, I think it is easier to start off as a Production DBA and move into the development. At least, that's how it was with me and I started off...

DOH! Good catch, Jerry. I was so busy trying to make sure I didn't post code w/o permission that I must have accidently dropped that declare statement.

My bad. :blush:

Seggarman,

Even following your suggestion, Gail's point is still valid. Just because the data is stored in a table in a certain physical or logical order does not mean that's how...

Did you install the client tools for SQL Server 2008? Perhaps this is what the message is referencing.

Glad we could help. @=)

Okay, this code is officially going to be my new best friend. @=)

Thanks, Ggraber! Cookies for you!

Aha. Didn't realize it was a paren. Thanks, Jeff. @=)