Hello Everyone,

I will like to take this select statement and insert the results into a table called SQL_Version. can ecyon help?

select SERVERPROPERTY('productversion')As ProductVersion, SERVERPROPERTY ('productlevel')as ProductLevel, SERVERPROPERTY ('edition')as SQLEdition,@@SERVERName

this select statement will give me the SQL version information. What I want to eventually do is run this on every SQL server ang egt the results.

__________________
Jaime E. Maccou

INSERT SQL_Version
select SERVERPROPERTY('productversion')As ProductVersion, SERVERPROPERTY ('productlevel')as ProductLevel, SERVERPROPERTY ('edition')as SQLEdition,@@SERVERName

is that what you're looking for?

Thank you for your response

This is what I did

1.created a linked server on all my servers
2.created a view to capture result from select statement
2.created a store procedure to call results from view
4.used cast to change data type
3.schedule a job on all servers to insert to the linked server

create view sqlversion
as
SELECT SERVERPROPERTY('productversion')as ProductVersion, SERVERPROPERTY ('productlevel')as ProductLevel, SERVERPROPERTY ('edition')as Edition,@@servername as ServerName


CREATE procedure sp_sqlversions
as
INSERT INTO [SQL_versions].[database].[dbo].[sql_version]
SELECT CAST(ProductVersion AS varchar(50)) AS ProductVersion, CAST(ProductLevel AS varchar(50)) AS ProductLevel,
                     CAST(Edition AS varchar(50)) AS Edition,@@SERVERNAME AS ServerName
FROM dbo.SQLVersion