Javier Sobrans

ALTER TABLE FacturasLin ADD CONSTRAINT FK_LineasFra FOREIGN KEY (FK_Fra) REFERENCES Facturas(idFra);

regsvr32 nlsxbe.dll

use msdb EXECUTE sp_addrolemember @rolename = 'SQLAgentReaderRole', @membername = 'usuario' SQLAgentUserRole SQLAgentReaderRole SQLAgentOperatorRole

ALTER DATABASE basedatos SET EMERGENCY DBCC CHECKDB (basedatos) ALTER DATABASE basedatos SET SINGLE_USER DBCC CHECKDB (basedatos, REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE basedatos SET MULTI_USER

c:\sqlcmd -E -S (local) -Q "BACKUP DATABASE basedadatos TO DISK='C:\Seg\basededatosBACKUP.bak'"

SELECT name, size FROM sys.database_files; USE Base_datos GO CHECKPOINT GO CHECKPOINT GO CHECKPOINT GO BACKUP LOG Base_datos WITH TRUNCATE_ONLY GO DBCC SHRINKFILE (basedatos_db_log)

exec sp_configure 'show advanced options',1; reconfigure; exec sp_configure 'Ad Hoc Distributed Queries',1; reconfigure; SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0 Xml;HDR=YES;Database=C:\telefonos.xlsx', 'SELECT * FROM [Hoja1$]') Instalar: Microsoft Access Database Engine 2010 Redistributable