xp_instance_regread

• Chris Scott-371584

  Right there with Babe

  Points: 717

  More actions

  May 19, 2010 at 8:15 am

  #221778

  I am running the following SQL script against my SQL Server 2008 installation:

  DECLARE @SQLErrorLogs VARCHAR(512)

  EXEC master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQLServer',N'NumErrorLogs',@SQLErrorLogs OUTPUT

  PRINT 'Number of SQL Error Logs: ' + @SQLErrorLogs

  Strangely the following output is generated:

  Number of SQL Error Logs: c

  As I had set this value to 99, I wasn't expecting 'c' as a result.

  Any ideas?

  Thanks in advance.

• wz700

  SSCertifiable

  Points: 7133

  More actions

  May 21, 2010 at 12:33 am

  #1170604

  Try to create NumErrorLogs as String Value.