How should I name my history tables ?

How should I name my history tables ?

• Richard Berg MSFT

  Tnaks Jens K. Suessmeyer ! !
  
  

• Dhaval-Patel

  Thanks, but how can I create a stored procedure which create a table with a name depending of the current month/day (or like TableName_YYYYMMDD). I would like to store the creation table date in its name.

  Is this possible

  Thx

  
  
  

• kcdclan

  I would only use the convention TableName_YYYYMMDD. As I guess that they will be not used that often, you should consider creating them on another filegroup and even schema (if you use SQL 2k5) than the productiv one to ease up the Backup of the objects.
  
  HTH, Jens K. Suessmeyer.
  
  ---
  http://www.sqlserver2005.de
  ---
  

• Flack

  Ok, thx.

  I'v written the stored procedure. My variable @command is correct. But how can I say to execute it

  exec @command doesn't work.

  I even tried to call the osql.exe through xp_cmdshell :)

  
  
  

• rpskumar

  EXEC(@Command)
  SP_EXECUTESQL @COMMAND
  
  HTH, Jens K. Suessmeyer.
  
  ---
  http://www.sqlserver2005.de
  ---
  

• MrBrilliant

  Hi,
  
  you will have to use dynamic SQL for that:
  
  
  SET @Command = 'CREATE TABLE ' + @Tablename + '_' + CONVERT(VARCHAR(8),GETDATE(),112) + (...Columnshere)
  
  

  HTH, Jens K. Suessmeyer.

  ---
  http://www.sqlserver2005.de
  ---

  
  
  
  
• How should I name my history tables ?