Comments
Sort by recent activity
Hi Chris
Sorry you cannot ignore the column, or the identity property, with SQL Compare. If you want to use SQL Compare you will have to manually remove the identity value after the synchronisation.
Regards
Dan / comments
Hi Chris
Sorry you cannot ignore the column, or the identity property, with SQL Compare. If you want to use SQL Compare you will have to manually remove the identity value after the synchronisation...
Hi Chris
If you want the target table to have the column but to remove the identity property you will have to ignore the column and create it yourself. This cannot be currently accomplished using any of the options in SQL Compare.
Regards
Dan / comments
Hi Chris
If you want the target table to have the column but to remove the identity property you will have to ignore the column and create it yourself. This cannot be currently accomplished using a...
Hi Gary
Can you let us know exactly the steps you are performing to get the error, and when it occurs.
It may be worth running SQL Profiler to see what command are being sent to SQL when the error occurs.
Can you send the results to support@red-gate.com
Regards
Dan / comments
Hi Gary
Can you let us know exactly the steps you are performing to get the error, and when it occurs.
It may be worth running SQL Profiler to see what command are being sent to SQL when the error ...
Hi Gary
The problem is probably due to the text in row value being larger than the page size. If you don't have any entries who’s length is greater than 5193 you will still receive the error.
Here is a statement to execute on the database to check the text in row value.
exec sp_MsForEachTable "SELECT OBJECTPROPERTY(object_id('?'),'TableTextInRowLimit') AS '?'"
Once you have found the problem you can use the store procedure sp_tableoption and change the option value 'text in row' to less than 8108.
Regards
Dan / comments
Hi Gary
The problem is probably due to the text in row value being larger than the page size. If you don't have any entries who’s length is greater than 5193 you will still receive the error.
Her...
Can you run profiler at the same time and record the commands that are being passed that are causing the problem.
Then send this over to support@red-gate.com with information about the server versions, patches and OS.
Thanks
Dan / comments
Can you run profiler at the same time and record the commands that are being passed that are causing the problem.
Then send this over to support@red-gate.com with information about the server versi...
Hi Jim
Can you clarify whether you are retrieving the data to compare offline, or you have finished the comparison, have selected objects and are synchronising.
Also are you running the tools on the server or from a workstation.
Regards
Dan / comments
Hi Jim
Can you clarify whether you are retrieving the data to compare offline, or you have finished the comparison, have selected objects and are synchronising.
Also are you running the tools on th...
Hi Shane
The latest version is 3.2 and can be downloaded from our web site.
Before you upgrade please uninstall the extended store procedure from the sql server. This is just a precaution as the latest version copies the xp in the sql\binn directory.
Regards
Dan / comments
Hi Shane
The latest version is 3.2 and can be downloaded from our web site.
Before you upgrade please uninstall the extended store procedure from the sql server. This is just a precaution as the la...
Hi
You have a different problem because the error message you have received relates to "Failed to recognize the SQL Server instance name".
Can you check that the server name / instance you have chosen is correct and that the file location has been changed to the blank database.
You may want to look at the vdi.log file which is found in the mssql\log directory.
Regards
Dan / comments
Hi
You have a different problem because the error message you have received relates to "Failed to recognize the SQL Server instance name".
Can you check that the server name / instance you have cho...
Can you try and run the backup sequencially rather than concurrently ?
Dan / comments
Can you try and run the backup sequencially rather than concurrently ?
Dan
Hi Bern
The error code relates to the message "Failed to create security environment" while trying to initiate the backup.
Can you try using the full command rather than saved settings. If you are running as a scheduled task please ensure that the operator has the correct permissions on SQL, if you use the -E option, and permissions on the remote location.
If you do use the saved setting make sure that the operator has permission to view the registry, as this is where the settings are saved.
Dan / comments
Hi Bern
The error code relates to the message "Failed to create security environment" while trying to initiate the backup.
Can you try using the full command rather than saved settings. If you are ...