Link to home
Start Free TrialLog in
Avatar of blossompark
blossomparkFlag for Ireland

asked on

Altering layout of SQL Server query results file output

Hi,
I am running the following code against an instance of SQL Server using SSMS.
PRINT '2.2 Ensure ''CLR Enabled'' Server Configuration Option is set to ''0'' (Scored)';
PRINT 'NOTE: TEST AGAINST EACH DATABASE IN THE INSTANCE';
EXECUTE sys.sp_MSforeachdb 'SELECT ''?'' AS database_name, name,CAST(value as int) as value_configured,CAST(value_in_use as int) as value_in_use FROM   ?.sys.configurations  WHERE name = ''clr enabled '''; 

Open in new window


I output to file and below shows the results displayed in a browser window
User generated imageIs there someway I can display the results in a single table as opposed to what is currently happening, a new table for each database tested?
any guidance appreciated.
Thanks
ASKER CERTIFIED SOLUTION
Avatar of ste5an
ste5an
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of blossompark

ASKER

Thanks ste5an,
will try that out and update you later
Perfect ste5an as usual...Thank you so much :-)