Comments
Sort by recent activity
It prevented the activity log from functioning effectively ie the activity log started but because of the error, I had to close VS2010.
The reason that I kicked off the activity log in the first place was that one of the (many) VS extensions I have installed was causing instability and I wanted to find out which one. I suspect that the instability is not being caused by SQL Prompt but something else, but I haven't yet established which something else. / comments
It prevented the activity log from functioning effectively ie the activity log started but because of the error, I had to close VS2010.
The reason that I kicked off the activity log in the first pl...
Hi David
Objects that no longer exist or have been renamed pretty much sums it up.
Glad to hear that SQL Prompt will fix it in the future. However, it would also be useful to be able to run a check from SQL Compare because that's where the problem will be mercilessly exposed.
Crispin / comments
Hi David
Objects that no longer exist or have been renamed pretty much sums it up.
Glad to hear that SQL Prompt will fix it in the future. However, it would also be useful to be able to run a chec...
Excellent! I did hunt around the 'Tables & Views' tab, but missed the 'Columns in Comparison' grid column. Now it's obvious...
Thanks
Crispin / comments
Excellent! I did hunt around the 'Tables & Views' tab, but missed the 'Columns in Comparison' grid column. Now it's obvious...
Thanks
Crispin
I've worked it out. I hadn't applied the correct user permissions to the particular database, so I was being locked out. The 'network error' was a red herring. / comments
I've worked it out. I hadn't applied the correct user permissions to the particular database, so I was being locked out. The 'network error' was a red herring.
Hi Robert
Sorry for the delay. Here's the exception detail.
System.InvalidCastException was unhandled
Message="Specified cast is not valid."
Source="System.Windows.Forms"
StackTrace:
Server stack trace:
at L.a()
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)
Exception rethrown at [0]:
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at System.Windows.Forms.Control.Invoke(Delegate method)
at N.a(IAsyncResult )
at System.Runtime.Remoting.Messaging.AsyncResult.SyncProcessMessage(IMessage msg)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)
at System.Runtime.Remoting.Proxies.AgileAsyncWorkerItem.ThreadPoolCallBack(Object o)
at System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)
Hope this helps. I need to be able to run a sync soon - will you be issuing a hotfix or something?
Regards
Crispin / comments
Hi Robert
Sorry for the delay. Here's the exception detail.
System.InvalidCastException was unhandled
Message="Specified cast is not valid."
Source="System.Windows.Forms"
StackTrace:
Server stack t...
Hi Robert
Thanks for the response. I had a go with the workaround but it didn't work for me. The default instance on th target machine is SQL Server 2005 developer edition and there is also an instance of SQL Server 2005 Express. In the past there were SQL Server 2000 instances but these have gone now.
I tried adding the value in the appropriate location with and without a trailing backslash just in case that made a difference - it didn't. I also added this value to both apparent instances of SQL Server.
The exported values are:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer]
"BackupDirectory"="D:\\SQL Server data\\2005 instance - Developer\\Backups\\"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer]
"BackupDirectory"="D:\\SQL Server data\\2005 instance - Developer\\"
Crispin / comments
Hi Robert
Thanks for the response. I had a go with the workaround but it didn't work for me. The default instance on th target machine is SQL Server 2005 developer edition and there is also an in...
Robert
I hate to say it but things seem to have got worse with 6.1. The crash problem I was experiencing involved SQL Server 2000 databases, but now I'm having a general problem (ie including SQL Server 2005 developer and Express editions) with SQL Data Compare 6.1. To see if it was my PC causing the problem I installed SQL Data Compare 6.0, then 6.1 on a reasonably clean Virtual Machine as well and ran into the same problem.
I've also tried to revert to 6.0 but that no longer works properly either.
Any ideas for a fix? It's suddenly got a bit critical as I now rely on being able to compare DBs.
Regards
Crispin / comments
Robert
I hate to say it but things seem to have got worse with 6.1. The crash problem I was experiencing involved SQL Server 2000 databases, but now I'm having a general problem (ie including SQL ...
Robert
I've thought of a more complex comparison that might be useful (well to me anyway). The ability to ignore carriage returns and linefeeds within the left or right panel (as appropriate) when making the comparison.
This means that if I've got a left-hand panel with linebreaks and a right-hand one without, I can still make a sensible comparison. To finish it off, the aforementioned word-wrap on both sides would make the comparison easier.
Crispin / comments
Robert
I've thought of a more complex comparison that might be useful (well to me anyway). The ability to ignore carriage returns and linefeeds within the left or right panel (as appropriate) when...
Richard
Thanks for your reply. I used to be on the beta programme and I'm quite happy to go on it again.
Crispin / comments
Richard
Thanks for your reply. I used to be on the beta programme and I'm quite happy to go on it again.
Crispin
David
Thanks. I'll leave it case sensitive.
One small point. On the Project Configuration 'Options' tab there's a couple of tick boxes for Mapping Behaviour marked "Ignore case" and "Ignore spaces", etc. The unwary might think that this refers to content rather than the object name. There is plenty of space to put in 'Ignore case in column name'. Ditto the others.
Crispin / comments
David
Thanks. I'll leave it case sensitive.
One small point. On the Project Configuration 'Options' tab there's a couple of tick boxes for Mapping Behaviour marked "Ignore case" and "Ignore space...