Activity overview
Latest activity by CrispinH
Startup error caused by SQL Prompt
I needed to log activity on Visual Studio 2010 so I started devenv.exe with the /log switch. This error gets thrown:
System.IO.FileNotFoundException was unhandled
Message=devenv.exe
Source=System
...
Suggestion: generate managed code with fake/mock data
The Data Generator is great when you are populating a database but in the TDD world it would be good to have an output option that creates methods in managed code (C#, VB.NET) containing fake data....
Suggestion: list SQL errors before synchronisation
At the moment if there are any SQL errors found at synchronisation time only the first error is shown in a pop-up. This is a nuisance if there are actually multiple errors that need resolving. It...
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
Ignoring a column
I'm compaing a couple of database tables on production and development servers where one column is Arabic text, but the encoding in each database is different. I want to compare the tables except ...
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.
Log-in issue
Hi
I can log into a remote SQL Server Express 2008 database (across a VPN) with SQL Server Management Studio (SSMS) without problems, but SQL Compare 8 is complaining of a network error: Provider, ...
Suggestion: word wrap in Viewer
It would be useful to be able to wrap text in the data viewer - a simple tickbox like the Whitespace one.
Crispin
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...