SELECT = 8 * size FROM sys.database_files WHERE file_id = 1 IF EXISTS(SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.GetLogsDatabaseSize') AND type IN (N'FN', N'IF', N'TF', N'FS', N'FT'))ĮXECUTE dbo.sp_executesql = N'CREATE FUNCTION GetLogsDatabaseSize() SELECT ROW_NUMBER() OVER(ORDER BY Time DESC) RowN, Time IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'dbo.NumberedEventsTime')) WHERE object_id = OBJECT_ID(N'dbo.Events') AND name=N'ActivityName')ĪLTER TABLE Events ADD ActivityName nvarchar(100) WHERE object_id = OBJECT_ID(N'dbo.Events') AND name=N'ActivityType')ĪLTER TABLE Events ADD ActivityType uniqueidentifier IF NOT EXISTS(SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.Events') AND type IN (N'U')) Message: An error occurs while executing SQL command: USE acronis_cms_logs Does management server support SQL Server 2008 R2 or only support SQL server 2008? when I install the management server in SQL server 2008 r2 in windows 2008 R2, It shows some error message.Īcronis Backup & Recovery 11.5 Management Server
0 Comments
Leave a Reply. |