GO USE [ESM5_2] GO DECLARE @Server nvarchar (255), @Archiveipaddressordnsname nvarchar (255), @Managementipaddressordnsname nvarchar (255) SET @Server = 'New Archive Server Description' SET @Archiveipaddressordnsname = '192.168.1.2' SET @Managementipaddressordnsname = '192.168.1.1' INSERT INTO [dbo].[tServer] ([ServerDescription] ,[ServerDnsName] ,[CentralDnsName] ,[ServerIP] ,[ServerLicense] ,[ServerActive] ,[StorageDays] ,[StorageGB] ,[LibraryStorage] ,[SmtpServer] ,[SmtpPort] ,[SmtpUser] ,[SmtpPassword] ,[SmtpFrom] ,[SmtpSsl] ,[AlertRecipients] ,[CreateDate] ,[CreateUser] ,[LastUpdtDate] ,[LastUpdtUser] ,[NtpHost]) VALUES (@Server, @Archiveipaddressordnsname, 'http://' + @Managementipaddressordnsname, @Archiveipaddressordnsname, NULL, 'Y', '7', '100', '100', '', '', '', '', '', 0, NULL, CURRENT_TIMESTAMP, SYSTEM_USER, CURRENT_TIMESTAMP, SYSTEM_USER, @Archiveipaddressordnsname) GO