blossompark
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.
I output to file and below shows the results displayed in a browser window
Is 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
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 ''';
I output to file and below shows the results displayed in a browser window
Is 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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect ste5an as usual...Thank you so much :-)
ASKER
will try that out and update you later