Monday, March 28, 2016

Database Backup

Go
RESTORE DATABASE ERA
FROM DISK = 'D:\Rubol\ERA.bak'
WITH MOVE 'ermsadminsql1' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQLSERVER2012\MSSQL\DATA\ERA.mdf',

MOVE 'ermsadminsql1_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQLSERVER2012\MSSQL\DATA\ERA.ldf'



TWIN MODULE - Dyncraft

eBom vs mBom  SELECT distinct * FROM [DataStage].[dbo].[CUMEBOM_LOADING] as CL where CL.LineSeqNbr='T0890F0' and CL.ChassisNbr='...