So Enterprise Manager can move the file to the recycling bin (and has done so) , but cannot delete it from the database?

I'm not questioning your statement, it matches what...

Here's the results of select * from sysfiles. Sorry, I can't find a way of making it format better, but bottom line, it shows my data file in the...

I'm just saying it would be nice. ...

This is a little off the immediate article and a little theoretical, but it applies to the issue of RBAR in the aggregating function.

Why doesn't SQL provide...

Never mind I see where it's going, I was trying to get to it from a query screen, it looks like if you start with the open table, then...

OK that was easy, but is there any way to limit the grid to a results of a simple query, I hate to have the whole table open for update,...

You comments about being less formal with the people you like, reminded me of a passage from "The Gulag Archipelago" by Solzhenitsyn. In it he stresses that "your friends...

Just an example of putting a literal into the layout. Lots of old fixed format specs have fixed values in particular positions. It goes back to...

If you know field1 is defined as a char(3) field then "select field1" is the same as "select left(field1,3)" The "+' '" simply pads spaces...

Yes they are crazy. You are now beyond technology and into interpersonal skills, (which my wife insists I don't have). My approach would be to point out that...

Sorry - The post has a typo, sample spec shows field1 to be 3 positions long. Example should read left(field1,3) not left(field1,2)

Also multiple blanks were suppressed...

assuming all fields are Char

if not you need to use cast or convert (sql functions see bol) to make them char

Sample spec

PosStart...

The best way I've found to control the exact layout is to write a select that formats each field as a fixed length character field using string manipulation functions and...

Yes it can. Using the export wizard just select destination type of text file, when you get to specifying the details, fixed width will be one of the choices....