Comandos Sql Server

Comandos Sql Server

-----**************************************************
-----**********COLUNAS*** ********** ********** ******
-----**************************************************
     exec  sp_columns 'XXXXXXXXX'
-----**************************************************
-----**********sp_password ********** ********** ******
-----***** *********************************************
exec sp_password NULL,'','SA'

--Adiciona ou altera a senha de um login do SQL Server. Os argumentos so: senha atual, nova senha e login. Para um novo usurio senha atual deve ser nulo

-----**************************************************
-----**********INFORMA TODOS OS PROCESSOS **********
-----**************************************************
select * from master..sysprocesses where dbid = db_id ('XXXXXXXXX')

-----**************************************************
-----********** --SP-- *****************************
-----**********
****************************************
sp_helpdb
sp_help
sp_columns
sp_who

exec Sp_helptext 'PROCEDURE'
SELECT * FROM syscomments --> Listar Procedures.

-----**************************************************
-----********** --SHRINKDATABASE-- *****************
-----**************************************************
 DBCC SHRINKDATABASE
 (Nome_BancodeDados ,porcentagem_final
[, {NOTRUNCATE | TRUNCATEONLY}] )
---**************************************************
-----****** --Restore Full e Diferencial-- *********
-----**************************************************
Use master
ALTER DATABASE XXXXXX
SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE--ALTER DATABASE XXXXXX SET RECOVERY SIMPLE;
--Full
RESTORE
DATABASE XXXXXX
FROMDISK = 'XXXXXX'
WITH NORECOVERY
--Diferencial

RESTORE DATABASE XXXXXX FROM DISK = 'XXXXXX' WITH  RECOVERY

-----**************************************************
-----****** --Derrubar usurios-- *********
-----****** *******************************************USE MASTER
ALTER DATABASE XXXXXX
SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE XXXXXX
SET MULTI_USER WITH NO_WAIT
ALTER DATABASE XXXXXX SET OFFLINE WITH NO_WAIT
 

Att,
Leonardo Rocha.