Toad World® Forums

FW: Exportation Looping info [1 Attachment]


#1

[ Attachment(s) from Hank Freeman included below]

When cycling through a list of servers to determine the SQL Server property
information by running the below syntax, Toad-SS-Beta 5.0.0.217 faults by
hanging or looping. Had to Task manager kill process.

SELECT @@SERVERNAME as ‘@@SERVERNAME’ , — This value sometimes will not work
SOOO use the next

SERVERPROPERTY ( ‘servername’ ) as ‘servername’ ,

SERVERPROPERTY ( ‘productversion’ ) as ‘productversion’ ,

SERVERPROPERTY ( ‘productlevel’ ) as ‘productlevel’ ,

SERVERPROPERTY ( ‘edition’ ) as ‘edition’ ,

isnull ( SERVERPROPERTY ( ‘InstanceName’ ), ‘Default’ ) as ‘InstanceName’

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

image004.png

image001.gif

image003.jpeg