Here is a T-SQL Query to find if a Report Server Database is configured in Native or Sharepoint Integration mode.
USE ReportServer$SQL2008R2 --Change the Database Name GO IF EXISTS (SELECT * FROM sys.objects WHERE NAME = 'ConfigurationInfo') BEGIN DECLARE @Result nvarchar(max) SELECT @Result = Value FROM ConfigurationInfo WHERE NAME = 'SharePointIntegrated' PRINT CASE WHEN @Result= 'False' THEN 'The specified Report Server Database "'+ DB_NAME() + '" is configured in "NATIVE" mode' WHEN @Result = 'True' THEN 'The specified Report Server Database "'+ DB_NAME() + '" is configured in "SHAREPOINT INTEGRATION" mode' END END ELSE BEGIN DECLARE @DBName nvarchar(100) SELECT @DBName = DB_NAME() RAISERROR('The database %s is not a report server database',16,1,@DBName) END
No comments:
Post a Comment