MSSQLSERVER 存储过程
来源:互联网 发布:淘宝买家信誉钻石 编辑:程序博客网 时间:2024/06/14 07:16
- 系统存储过程
-
- sp_databases
-
- sp_server_info
-
- sp_stored_procedures
-
- sp_tables
- select * from sysobjects
-
- sp_password @new=null,@loginame='sa'
-
- EXEC sp_password NULL, 'ok', 'Victoria'
-
- EXEC sp_password 'ok', 'coffee'
-
- use master
- go
- exec sp_configure 'recovery interval','3'
- reconfigure with override
- go
-
- sp_helpdb tmp
- use tmp
- go
- sp_helpfile
- go
-
- use master
- go
- sp_detach_db tmp
- go
-
-
-
- sp_attach_db tmp,@filename1='E:/DB/tmp_dat.mdf',@filename2='E:/DB/tmp_log.ldf'
- go
- sp_helpdb tmp
- go
-
- use master
- go
- exec sp_addumpdevice 'disk','mydiskdump','E:/DB/dump1.bak'
- go
- select * from sysdevices
- go
-
-
-
- backup database tmp to mydiskdump
- go
-
- exec sp_addumpdevice 'disk','dump2','E:/DB/dump2.bak'
-
- backup log tmp to dump2
-
- restore database tmp from mydiskdump with norecovery
-
- restore log tmp from dump2 with norecovery
-
- use master
- go
- EXEC sp_addumpdevice 'tape', 'tapedump1','//./tape0'
- go
-
- sp_dropdevice 'dump2'
-
- restore database tmp from mydiskdump
- go
- sp_dboption 'tmp','read only',true
- go
-
- sp_dboption 'tmp','read only',false
- go
-
- use tmp
- go
- sp_rename sa,SA
- select * from SA
-
- exec sp_dboption 'tmp',autoshrink,true
- go
-
- exec sp_dboption 'tmp','single user'
- go
- exec sp_dboption 'tmp','single user',false
- go
-
- dbcc shrinkdatabase(pubs,10)
- go
-
- exec sp_addtype City,'nvarchar(15)',null
- go
-
- exec sp_droptype City
- go