SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Script Table Data malfunction...

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Script Table Data malfunction...
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2109

Post Script Table Data malfunction... Reply with quote
It seems that scripting out data does not work properly when you have brackets in the selected table names (yes, I know, it's weird to have brackets in the table name but mssql 2k8 allows it, and I've got a database containing a bunch of such tables).

In the messages window I could see lines 'x rows fetched from database.schema.table' but the file that was created missed insert statements from tables that came before the tables with brackets in their name. The comment lines in the files were also placed incorrectly

Code:

/* Inserting database.schema.table_2 data... */
INSERT INTO database.schema.table_3
.
.
.

Tue May 18, 2010 7:02 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
Thank you for reporting this issue. I am going to log it to our internal issue tracking system. Your feedback is much appreciated!
Tue May 18, 2010 8:27 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.