June 2009 Entries

WorldShip SQL2005 sp_Tables

If you're reading this post then you are probably looking for a way to limit the number of table/view records returned by sp_tables. For some reason each time Worldship opens an import/export mapping it runs exec sp_tables NULL,NULL,NULL,N'''TABLE''' exec sp_tables NULL,NULL,NULL,N'''VIEW''' to return a list of tables. This includes sys and INFORMATION_SCHEMA tables that won't be used. Then the columns from each of the tables is returned. Overall this can add lots of processing time overhead to a ......