Hello,
A brief history of the problem...
I work for a computer games company that uses databases to build their games, What we are needing to do is to be able,at the click of a button, to backup data from certain tables in SQL Server 2000 to a specified directory, so that the programmers can back up the data in a specific table and then try out a new setting etc. and if it doesn't work how they want, put the original data back into the table again.
Is there any way to do this via a VB Script or a TSQL script?
I am not a SQL person really, so appologies if this is a little vague.
thanks in advance
John Hilton
A brief history of the problem...
I work for a computer games company that uses databases to build their games, What we are needing to do is to be able,at the click of a button, to backup data from certain tables in SQL Server 2000 to a specified directory, so that the programmers can back up the data in a specific table and then try out a new setting etc. and if it doesn't work how they want, put the original data back into the table again.
Is there any way to do this via a VB Script or a TSQL script?
I am not a SQL person really, so appologies if this is a little vague.
thanks in advance
John Hilton