Can I capture the version of SQLBackup being used via t-sql?

• 
  Hi Jim,
  
  You can... Hopefully this information doesn't change as it's undocumented!

  declare @CurrentSQBVersion NVARCHAR(50)
  execute master..sqbutility 1030, @CurrentSQBVersion OUTPUT
  SELECT @CurrentSQBVersion As [SQB Version]
  

  The version is returned in @CurrentSQBVersion.

  Brian Donahue August 24, 2007 17:49

  - 0 +
• 
  Perfect. Thank you.

  jim.wilson August 24, 2007 17:55

  - 0 +
• 
  I need to eliminate a result set from your code. Below returns empty result set from call to sqbutility, and since I am not super VB programmer, I don't know how to get around that.
  
  Can I get it to not return empty result set?
  

  DECLARE
  	@CurrentSQBVersion 	NVARCHAR(50) 
  
  BEGIN
  	SET NOCOUNT ON
  	
  	EXECUTE master..sqbutility 1030, @CurrentSQBVersion OUTPUT 
  
  	SELECT @CurrentSQBVersion AS [RedGate_Version] 
  	/*  The version is returned in @CurrentSQBVersion. */
  
  END
  

  
  results

  result
  ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  
  RedGate_Version
  --------------------------------------------------
  4.6.0.815
  

  mdgraves October 05, 2007 11:39

  - 0 +
• 
  It may not be the best solution, but this seems to work:

  declare @CurrentSQBVersion NVARCHAR(50) 
  CREATE TABLE #temp (
  trash CHAR(1)
  )
  INSERT #temp EXEC master..sqbutility 1030, @CurrentSQBVersion OUTPUT
  SELECT @CurrentSQBVersion As [SQB Version]
  DROP TABLE #temp
  

  Brian Donahue October 07, 2007 14:54

  - 0 +
• 
  Brian,
  I thought about trying this but hadn't done it. This solution works. Thanks for feedback.

  mdgraves October 08, 2007 12:44

  - 0 +

Add comment

Please sign in to leave a comment.