Comments
                          
                            Sort by recent activity
                          
                          
                        
                      
                      
                        They were running it manually from a text file and not through the application.  
Also they were running it in it's entirety not in segments through management studio.  
In terms of the size, it was 160mb .sql file (ascii encoding), 500 tables with 100mb of the data in 2 tables. / comments
                        
                        
                        
                      
                      
                      
                  
                    They were running it manually from a text file and not through the application.
Also they were running it in it's entirety not in segments through management studio.
In terms of the size, it was 16...
                      
                    
                      
                        
Andras wrote: 
Stefano Paparesta wrote: 
You can release a free utility to create a database snapshot for synchronization with SqlCompare 7. 
Many thanks  
Stefano 
 
Hi Stefano,  
this is a very good idea. We will certainly consider including it in our tool. 
Many thanks, 
Andras 
  
I consider this almost essential. Often the live databases that are being compared are either sitting behind a firewall in the data centre (accessed only by a local IP), or sitting internally in a client's environment.  
Releasing a tool that purely connects to a database and creates a snapshot (which has a licence that is available to distribute to any number of sites) would make the task a lot easier. / comments
                        
                        
                        
                      
                      
                      
                  
                    
Andras wrote:
Stefano Paparesta wrote:
You can release a free utility to create a database snapshot for synchronization with SqlCompare 7.
Many thanks
Stefano
Hi Stefano,
this is a very goo...
                      
                    
                      
                        Thanks for that update, appreciate you taking some time out to write that.  
And personally i think the main idea of intellisense is to be productive but for you to forget it's there.  
It has to not take over so much that it becomes annoying and a hindrance, but do enough so it is productive and that is the fine line you spoke about.  
Look forward to seeing the RC when it becomes available. / comments
                        
                        
                        
                      
                      
                      
                  
                    Thanks for that update, appreciate you taking some time out to write that.
And personally i think the main idea of intellisense is to be productive but for you to forget it's there.
It has to not t...
                      
                    
                      
                        Sorry to be a pain, is there an update on progress?  
Cheers / comments
                        
                        
                        
                      
                      
                      
                  
                    Sorry to be a pain, is there an update on progress?
Cheers
                      
                    
                      
                        I've found this annoying too. I get the expiry exception happening everytime i open a new window, even though i have set it to "off". / comments
                        
                        
                        
                      
                      
                      
                  
                    I've found this annoying too. I get the expiry exception happening everytime i open a new window, even though i have set it to "off".
                      
                    
                      
                        Picture tells a thousand words.  [image]  / comments
                        
                        
                        
                      
                      
                      
                  
                    Picture tells a thousand words.
                      
                    
                      
                        Create the following table:  
CREATE TABLE TestCase (UpdateCustomer bit, UpdateMember bit)  
Refresh cache..    
Case 1 works correctly: UPDATE TestCase SET
	Upda[ctrl-space]
 
Case 2 works incorrectly: UPDATE TestCase SET
	UpdateCustomer = 1,
	Update[ctrl-space]
 / comments
                        
                        
                        
                      
                      
                      
                  
                    Create the following table:
CREATE TABLE TestCase (UpdateCustomer bit, UpdateMember bit)
Refresh cache..
Case 1 works correctly:UPDATE TestCase SET
	Upda[ctrl-space]
Case 2 works incorrec...
                      
                    
                      
                        I personally would like to see it turned on.  
Its especially useful for parts where you'd always use the auto-completion.  
Eg.  
INNER JOIN[space]  
or 
INNER JOIN Table T ON[space]  
But this would depend on the candidate list showing up only when its needed. If it shows up othertimes i can see an argument for turning it off. / comments
                        
                        
                        
                      
                      
                      
                  
                    I personally would like to see it turned on.
Its especially useful for parts where you'd always use the auto-completion.
Eg.
INNER JOIN[space]
or
INNER JOIN Table T ON[space]
But this would depend ...
                      
                    
                      
                        Ok, i think i have been able to reproduce this using AW. SELECT *
FROM HumanResources.Department A
INNER JOIN HumanResources.vEmployee V on vEm
 
The list shows 3 items, the 2nd one clicks ok, the first doesnt click.  
Can someone please confirm this? / comments
                        
                        
                        
                      
                      
                      
                  
                    Ok, i think i have been able to reproduce this using AW.SELECT *
FROM HumanResources.Department A
INNER JOIN HumanResources.vEmployee V on vEm
The list shows 3 items, the 2nd one clicks ok, the f...
                      
                    
                      
                        I was using SSMS.  
What happened is after i pressed enter the candidate box just disappeared. I could press control-space and get it to show up again and then enter would just leave it incomplete.  
I'll have a play around and see if i can replicate it. / comments
                        
                        
                        
                      
                      
                      
                  
                  
                I was using SSMS.
What happened is after i pressed enter the candidate box just disappeared. I could press control-space and get it to show up again and then enter would just leave it incomplete.
I...