I ment what happened if the server abruptly lost its power, not the workstation.
>Something smells fishy about that statement. I hope that if a SQL statement is not properly formed, SQL Server won't do anything with it.
>
>lcName = "Something"
>sqlexec(gnConnection,"insert into table sometable (name) values (?lcName)")
>
>If the power should fail on my PC while the statement is being sent...
>
>SQL would receive
>
>"insert into sometable (nam"
>
>and an error would be generated.
>
>If there is some kind of delimiter expected on both ends of the statement, then upon failing to receive a terminating delimiter, SQL would do nothing at all.
>
>I guess I'm asking for someone to please demonstrate how SQL Server could lose data due to a PC power failure.
>
>Thanks