How to test if AS400 linked server table exists in T-SQL?

• VA123

  SSCarpal Tunnel

  Points: 4272

  More actions

  October 2, 2008 at 9:02 am

  #191722

  I need to determine whether a table in a AS400 linked server exists before I attempt to select from the table. I need the equivalent of the code below that is written for a SQL Server linked server.

  IF EXISTS(SELECT 1 FROM myDatabase..sysobjects WHERE name = ''myTable_@date'' AND xtype = ''U'')

  Thanks.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  October 3, 2008 at 6:14 am

  #880414

  SQL Server 2005 provides a new stored procedure specifically for this:

  sp_testlinkedserver [ @servername ] = servername

  Returns 0 for success and 1 for failure.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question