Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server CMS Multiserver query issues. If statement. Expand / Collapse
Author
Message
Posted Wednesday, May 7, 2014 4:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 18, 2014 1:48 AM
Points: 17, Visits: 28
Hi,

I have recently added all of our SQL Servers to our CMS instance. Our environment is a mix of SQL Server from 2000 to 2012.

Running the simple query:

DECLARE @ver nvarchar(128)
SET @ver = CAST(serverproperty('ProductVersion') AS nvarchar)
SET @ver = SUBSTRING(@ver, 1, CHARINDEX('.', @ver) - 1)

IF ( @ver = '11' )
SELECT Name FROM SYS.DATABASES

Doesn't return any results unless I set the query window "merge results" option to false.

If I remove the "If" statement this query will work but because it is a mix environment I would very much like to say if version is 2012 run this query.

I have tried creating a simple stored procedure to call but this fails to return results, not sure if this is a different issue.

I'm currently reading through the Microsoft documentation but nothing has come up to suggest this would be a problem. Does any know why this is a problem? Or if I can get around it?

Kind Regards,

David.



Post #1568377
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse