Red Gate forums

Smart Assembly Failed

jf3000 — Fri, 17 May 2013 22:58:49 GMT

Okay so it looks like I've successfully built the app but when I go to publish I get this error

Code:

Error 2 SmartAssembly build failed:
You are trying to merge the following assemblies which were not referenced by the main assembly:
FileA, Culture=neutral, PublicKeyToken=null
FileB, Culture=neutral, PublicKeyToken=null
FileC, Culture=neutral, PublicKeyToken=null
FileD, Culture=neutral, PublicKeyToken=null
C:\Users\Blah\Project.vbproj 418 5 Project

In SA I did ask it to compile the DLL into the exe, the build before the publish worked, but the build to publish has failed, how do I fix this?

Thank you

RE: Profiling a different machine

jessica.ramos — Fri, 17 May 2013 21:10:02 GMT

I'm sorry to say that the Memory Profiler will need to be installed and running on the customer's machine. :/

RE: Oh Boy problems

jf3000 — Fri, 17 May 2013 20:34:38 GMT

Please close and review:

http://www.red-gate.com/MessageBoard/viewtopic.php?p=62009#62009

RE: Login failed for user when trying to open .sqlgen file

Manfred.Castro — Fri, 17 May 2013 20:09:45 GMT

You should be able to set password encrypted ="0" and then you can free type the password for the account.

<Password encrypted="0">your_unencrypted_password</Password>

schema compare and queue tables and queues

MelissaOlson — Fri, 17 May 2013 15:46:03 GMT

Hi,
Is there a way to set up my schema compare so that it will find my queues and queue tables?
Thanks!

RE: Is my .net app secure?

Chris.Allen — Fri, 17 May 2013 14:53:33 GMT

I can only refer to testimonials we've been given permission to publish. Please take a look at:

http://www.red-gate.com/our-company/about/all-testimonials

Force updates rather than inserts

dinonz — Fri, 17 May 2013 14:33:02 GMT

Hi,

I'm trying to do a comparison every 15 minutes and keep a target database up to date. I have fields whereby I can filter what has been added, and what has been changed in the last 15 minutes.

Problem is, adding that filter makes it want to "insert" all records that have changed, because they don't appear to be in the target data because they have not changed there. Is there a way to force the generation of SQL to always make update statement not inserts?

Dino

RE: Some methods in .app7results file are not exported to .htm

Brian Donahue — Fri, 17 May 2013 14:20:54 GMT

Hello Hein,

I'm curious to know if this is a problem with your web browser (not supporting JavaScript or some form of CSS). If you export to HTML whilst you are viewing the results in grid mode as opposed to tree mode, do you still have methods missing?

RE: 7.3.0.383 Issue: Refreshing Connection for 20m & counting

mglenn — Fri, 17 May 2013 13:51:54 GMT

Has Red-Gate looked into performance tuning sqbdata? Activity History still takes forever to populate--GT 5 minutes for us on a server that contains 1 year of history.

Customers should not be forced to delete important backup history as a workaround for a poorly performing SQL Backup process.

RE: Incorrect syntax near ')'

kevinw — Fri, 17 May 2013 13:00:09 GMT

Sorry. Ignore me. It was caused by a bad merge that removed the TransactionWeek column.