Global Variable data type for varbinary(16)

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  October 4, 2007 at 7:42 am

  #70132

  When defining a Global Variable that will be populated from a table column that is varbinary(16), what Global Variable datatype should be used?

  The reason for this request is amusing: The Auditors have a tool for SQL Server but they need a SQL Server login with the same password on all instances. The security department added the login but did not take into account different collations, so the passwords do not work uniformly. I have written a DTS package that drops the old login and creates a new login but the login SID must have the same value on all SQL Servers. There are 685 SQL Servers.

  SQL = Scarcely Qualifies as a Language

• Loner

  SSC-Insane

  Points: 21279

  More actions

  October 4, 2007 at 11:08 am

  #739228

  I usually don't put the length in. I just defined as varchar, INT ....in the global variable field.