Posts
                          
                            Sort by recent activity
                          
                          
                        
                      
                      
                        Enhancement Requests
                        
                        
                        
                        
                      
                      
                      
                  
                    Sometimes a command such as sp_msForEachTable spreads the results across multiple result sets.  It would be nice to be able to merge the result sets.
Include a way to have a script identified the "...
                      
                    
                      
                        Backup job failing after working for a long time
                        
                        
                        
                        
                      
                      
                      
                  
                    Date		2/25/2011 10:57:26 AM
Log		Job History (SQL Backup full job created 10/6/2009 12:39:15 PM)
Step ID		1
Server		TFS-2008
Job Name		SQL Backup full job created 10/6/2009 12:39:15 PM
Step Name		e...
                      
                    
                      
                        SQLNCLI error from synchronizing script
                        
                        
                        
                        
                      
                      
                      
                  
                    I have two databases on my reporting server (SSRS). They contain stored procedures that our reports use.  One is ReportingStoredProcedures. The other is ReportingStoredProcedures_DEV.  I just creat...
                      
                    
                      
                        VDI error 1010
                        
                        
                        
                        
                      
                      
                      
                  
                    I am getting the following error when I attempt to backup and compress a 300GB database across our network.
VDI error 1010: Failed to get the configuration from the server because the timeout inter...
                      
                    
                      
                        Restore error VDI error 1010
                        
                        
                        
                        
                      
                      
                      
                  
                    I run the following command and get the following message.
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [ATS_Barclays] FROM DISK = ''E:\Backups\ATS_Barclays_db_20100507_004006.sqb'' WITH RECOV...
                      
                    
                      
                        Interactive HTML works differently
                        
                        
                        
                        
                      
                      
                      
                  
                    I prefer the prior method for Interactive HTML file saving.
In prior versions, after running SQL Compare, I used to save the report as an Interactive HTML.  In those versions, the Interactive HTML ...
                      
                    
                      
                        Deactivate did not to work on SQL 2008 with Server 2008 OS
                        
                        
                        
                        
                      
                      
                      
                  
                    Deactivate did not to work on SQL 2008 with Server 2008 OS
                      
                    
                      
                        Automatically enter the second quote
                        
                        
                        
                        
                      
                      
                      
                  
                    I think I set this up with ver 3.  When I type a ' I would like SQL Prompt to enter '', then let me enter the text between them.
                      
                    
                      
                        Job for sp_delete_backuphistory?
                        
                        
                        
                        
                      
                      
                      
                  
                    When I look at the "SQL Server backup history" section of the File Management Options, I selected to delete old backup history older than 60 days.  My question is does this create a job on the serv...
                      
                    
                      
                        Can not get the /includeIdentical to not show identical item
                        
                        
                        
                        
                      
                      
                      
                  
                  
                SQLCompare /S1:ATLAS /db1:DB1 /S2:SQL01 /db2:DB2 /includeIdentical:False
SQL Compare Command Line V7.1.0.197
========================================================================================...