yeah i realized after i posted this that i included row delimiters in the example but there really aren't in the file i'm talking about. it's to the same...

I'm not sure that works because it's not a fixed width file, it's a chunk of text that may not have any delimiters in it at all and BCP still...

Is it possible to use SSIS to import this same flat file if it doesn't have a ROW delimiter?

I get these files which are basically text streams and they are...

There is nothing more important than a DBA taking responsibility for the protection of a company's data and I really like the part about confidence as well.

Many times I've been...

i appreciate your responses.

it's not difficult for us to prove that the database has been stolen.

what is difficult to prove, and should not be, is that the database is protected...

as the previous poster mentioned, typically users can only see those databases that they have been granted access to.   it does depend on the tool you're using though.  for instance...

just for fun, though completely illogical...

Select s.studentID

From Student s

Inner Join StudentCourse sc On s.StudentID = sc.StudentID

group by s.studentid

having sum(case when sc.courseid = 1 then 1 else 2...

you can specify IDENTITY INSERT ON for the target table.

i'll use an example to illustrate what "they" did, but this is by no means an indicator as to what companies are involved in the dispute.

arcserve developed a backup product...