var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: About Database Purge Script?
What is Database Purge Script and how can i wirte that script with VB6?
With kind regards . . . . . SQL Server 2000/2005/2012
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages
yes, it's SQL Sever 2005 .export data from table and store at CSV file and then delete that table using VBScript.That is what i want to do.
waiting your reply,
You can write the lot using nothing but SQL if you want.
Cursor over the tables in sys.tables
BCP out the data and then DROP the object.
Give it a try and post back your efforts if you need a hand
We're proud of your typing skills, but that doesn't really address the OP's problem...
Originally Posted by Wim
I would extract the table ddl as well as indexes on top of that, so you have a current definition to match the bcp file.
Originally Posted by gvee