use master
go
exec sp_configure 'show advanced options', 1 --显示高级配置信息
go
reconfigure --重新配置
go
exec sp_configure 'xp_cmdshell', 1 --打开xp_cmdshell选项
go
reconfigure --重新配置
go
exec xp_cmdshell 'mkdir D:\bank', NO_OUTPUT --创建文件夹D:\bank
--创建数据库bankDB
if exists(select * from sysdatabases where name = 'bankDB')
drop database bankDB
go
create database bankDB
ON
(
name ='bankDB_data',
filename='D:\bank\bankDB_data.mdf',
size=3md,
filegrowth=15%
)
log on
(
name ='bankDB_log',
filename='D:\bank\bankDB_log.mdf',
size=3md,
filegrowth=15%
)
go
exec xp_cmdshell 'dir D:\bank\' --查看文件
go
exec sp_configure 'show advanced options', 1 --显示高级配置信息
go
reconfigure --重新配置
go
exec sp_configure 'xp_cmdshell', 1 --打开xp_cmdshell选项
go
reconfigure --重新配置
go
exec xp_cmdshell 'mkdir D:\bank', NO_OUTPUT --创建文件夹D:\bank
--创建数据库bankDB
if exists(select * from sysdatabases where name = 'bankDB')
drop database bankDB
go
create database bankDB
ON
(
name ='bankDB_data',
filename='D:\bank\bankDB_data.mdf',
size=3md,
filegrowth=15%
)
log on
(
name ='bankDB_log',
filename='D:\bank\bankDB_log.mdf',
size=3md,
filegrowth=15%
)
go
exec xp_cmdshell 'dir D:\bank\' --查看文件