[ReneG]

Is there anyway to automatically dump an SQL table to a text file daily like as to back up data?

[Roel]

You can use a query like this to backup tables:

Код:

 SELECT * INTO Persons_Backup FROM Persons

for example.
I think you cannot use the export command inside a query, because query's are only able to deal with data inside a table, they cannot really read or write textfiles.
But I'm sure that there are scripts or tools for your windows or linux server that can make a backup(export) of your database each x time. You should ****** for that.