Not sure what I missed but I got it to finally work...

bcp "SELECT TextData FROM tb_PositivePayTextFileData" queryout c:\Authors.txt -c -Uxx -Pxxxx -Sxxxxxx

Probably a syntax issue I just missed...either that or...

That is exactly what I would want to happen but you are correct to the best of my knowledge...there is no ROW Terminator for the last record.

I guess I will...

I have tried everything in the properties, I have removed all the settings for row delimiter...I have changed it to be just {CR}, it still leaves the extra line at...

No Problem...glad to help

Google is your friend

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

OK I had something similar one time when re-creating a test enviornment, long story...but the end result was all we had room for was to zip and move the .MDF...

EDIT: OK either someone changed it, saw the error and then changed it back before I got in or I am a complete dumb a$$ and set the schedule...

Like my fathers famous two sayings "You can learn a lot from other peoples mistakes" & "Preventive Maintenance is the Best Maintenance"...

I seriously have a lot to learn...more so the...

Don't be sorry...I am new to the position and I am learning as fast as I can which is why I have asked a ton of questions.  I would rather...

You have a great point.  I did not mean to imply that was the case, that users simply say I need this access..ect and it is magically given without question.

In...

This is a production box and I am cleaning up accounts after a migration off of a previous system prior to me working in my current position.  I came across...

I will take a look at BOL for groups to get some more information...Thanks Guys.

Lee

good point, sounds like a case of 6 of one and half a dozen of the other   Personal preference I guess.

So it acts similar to a role you could create and assign people to the groups then...to me that would be easier to manage and figure out what access is...

OK I think I understand...

So basically if you have a group of (DOMAIN) users placed in a Domain group i.e. (DOMAIN\SQL_USERS), and then you give access the Doman GROUP to...