From: johansson.andersson@telia.com   
      
   I want to get the name of the columns, the primary key and foreign key and   
   the contents.   
   I want all this output to be stored in a file.   
   I can do select * but can I redirect the output to a file.   
      
   //Tony   
      
   "Erland Sommarskog"  skrev i meddelandet   
   news:XnsA092F33A6DD1CYazorman@127.0.0.1...   
   > Tony Johansson (johansson.andersson@telia.com) writes:   
   >> I need to extract a sql dump from several tables where I can see the   
   >> contens and primary key and foreign key   
   >   
   > SELECT *? Or do you want the "dump" in any special format? Can you   
   > be more specific?   
   >   
   > --   
   > Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
   >   
   > Links for SQL Server Books Online:   
   > SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   > SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)