Using ALTER ASSEMBLY to refresh the bits of an existing assembly

Hot Topic

Native Client connection to MSSQL 2000
Control flow drawing bug
Remove/Hide Export options in MRS
Page break after X items
Strange behavior with Calculated Members
Reprocessing Errors after using the migrationwizard
Works fine inside BI Dev. Studio, but fails when scheduling it in SQL server 2005.
Could Not Bulk Copy
connecting to sql server 2000 from sql server 2005 management studio
Input column collection in script component?

SQL Server

Using data from XML column as basis for LEFT JOIN...
How to Delete Files on Maintenance Plan
Reference variables with identical names but different scopes
Why is taking so long to open/render the reports for the first time?
Chart displaying too many bars
How to add 'ALL' as report parameter in drop down with other parameters
Foreach Loop based on Variable String separated by Semi-Colon Items?
Script Component – “extremely long lines of text”
LIKE % question
Running multithreaded component inside the Script Task

Using ALTER ASSEMBLY to refresh the bits of an existing assembly

According to the documentation, it looks that it's possible to use ALTER ASSEMBLY to change the contents of an existing assembly:

"If the FROM clause is specified, ALTER ASSEMBLY refreshes the assembly with respect to the latest copies of the modules located at the network location you specify."

However, if I execute:

CREATE ASSEMBLY [MyAssembly] FROM '\\mymachine\Test\MyAssembly.dll'
ALTER ASSEMBLY [MyAssembly] FROM '\\mymachine\Test\MyAssembly.dll'

I get the following error:

Msg 6285, Level 16, State 1, Line 2

ALTER ASSEMBLY failed because the assembly used as a source has the same MVID as an assembly currently registered.



Am I misreading the documentation, or this is not working as expected

Thanks

Answer this question

Using ALTER ASSEMBLY to refresh the bits of an existing assembly

  • Tom ODonnell

    So do I, so do I!!

    :-)

    Niels

  • JohnEwing

    Thanks Niels!

    I hope not to get a similar error when I do:

    INSERT INTO [Country] ([CountryId] ,[CountryName]) VALUES (1, 'US')
    UPDATE [Country] SET [CountryName] = 'US' WHERE CountryId = 1

    Smile

  • Nikolaus Brennig

    Try and do a minor code change and rebuild your assembly after you have run CREATE and then do ALTER. Then it'll work just fine.

    The error you're getting is basically telling you that no changes has been made to the assembly.

    Niels
  • Using ALTER ASSEMBLY to refresh the bits of an existing assembly
Answer this question