USE master;
EXEC sp_dboption mydb,'select into/bulkcopy/pllsort',true;
USE mydb;
-- ALTER TABLE goes here
USE master;
EXEC sp_dboption mydb,'select into/bulkcopy/pllsort',false;
mydb is a database name, should be properly selected.
S/W development aspects
USE master;
EXEC sp_dboption mydb,'select into/bulkcopy/pllsort',true;
USE mydb;
-- ALTER TABLE goes here
USE master;
EXEC sp_dboption mydb,'select into/bulkcopy/pllsort',false;
No comments:
Post a Comment