Well, the issue is mostly one of maintenance and how much work you're planning to put into it. The two most important questions I see are:

Do you really want your...

Awwww. :blush:

Thank you, Jeff.

The backup commands of T-SQL do not have a place for user name and password for the folder level. Only for the backup access.

Sorry, but you can't implement that kind...

Oksana,

I just realized no one told you what RBAR stands for. @=)

Jeff coined the phrase. It's an acronym for "Row by Agonizing Row". That's what cursors do. They process information...

Most of my training...

Oksana,

Most DBAs actually have a big hate for cursors. There are very few good things that come out of them because, for the most part, they eat up processing power,...

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...