Activity overview
Latest activity by keeneyen
How is it in "backwards compatibility mode" when the database compatibility level is set to 90? Are you referring to the fact that the database was restored on SQL 2005 from a SQL 2000 backup?
Let me know how it goes. I will email to red-gate support as you suggested.
Thanks. / comments
How is it in "backwards compatibility mode" when the database compatibility level is set to 90? Are you referring to the fact that the database was restored on SQL 2005 from a SQL 2000 backup?
Let...
Ok, let me know how you would like to go about exchanging the backups. To avoid exposing my company's proprietary information, database schema etc.., would it make sense just to send you the system tables?
Regarding the upgrade scenario you described, the original databases involved in the comparison was copied from a sql 2000 instance having been originally created on that 2000 instance. I am checking with our DBAs regarding the method they used to copy the database. The second database involved in the comparison is a copy that first database.
Let me know how we should proceed.
Thanks,
Eric / comments
Ok, let me know how you would like to go about exchanging the backups. To avoid exposing my company's proprietary information, database schema etc.., would it make sense just to send you the syste...
I installed version 5 and received the same error when trying to perform the same comparison. The exception seemed to be thrown while reading permissions. I selected "Ignore permissions" and "Ignore users roles...", to no avail, same error:
Specified cast is invalid.[/img] / comments
I installed version 5 and received the same error when trying to perform the same comparison. The exception seemed to be thrown while reading permissions. I selected "Ignore permissions" and "Ign...
If you think it would help to isolate and fix the bug we are experiencing then yes I would try it.
This may be obvious, but my organization would not implement release candidate software in production environments.
So, hopefully we can get a production release build or patch to fix the problem.
Thanks again for your help! / comments
If you think it would help to isolate and fix the bug we are experiencing then yes I would try it.
This may be obvious, but my organization would not implement release candidate software in product...
4.1.0.59
SQL Compare installed on Windows XP SP2. Database server is Windows Server 2003.
SQL Server version is 9.00.1399.06, Standard Edition.
Let me know if there is anything else.
Thanks! / comments
4.1.0.59
SQL Compare installed on Windows XP SP2. Database server is Windows Server 2003.
SQL Server version is 9.00.1399.06, Standard Edition.
Let me know if there is anything else.
Thanks!
Thanks for replying, Brian.
Checked SQL 2005 Management Studio (both databases are in SQL 2005) in both databases for views w/o an owner, but I did not see any.
Should I look for other objects that do not have an owner/schema assigned. We use a schema other than dbo for all of our user defined objects. Also, I am not in db_owner, could there be an issue related to permissions?
What else can I check?
Thanks again. / comments
Thanks for replying, Brian.
Checked SQL 2005 Management Studio (both databases are in SQL 2005) in both databases for views w/o an owner, but I did not see any.
Should I look for other objects that...
Error: Specified Cast Is Not Valid
Receiving the message "specified cast is not valid" when comparing two databases in the same SQL Server 2005 instance. Saw a posting from user digitalage where the thread of the posting mentioned ...