I updated the source code of a "class StoredProcedure" using C# and need to update the assembly in a remote SQL 2008 server.
On my local SQL database all I do is click on the project in VS 2010 and I choose "Deploy".
I can't follow the same process for my remote SQL server because for some reason it won't allow me to add a new Data Connection for that specific remote SQL server, however I am able to access the remote server via SQL Server Management Studio.
A friend told me I can do it via SQL script by right clicling the assembly under Programmability/Assemblies folder.
I am not very confident about doing that or how that process work. How does it copy the new assembly remotely?
Could anyone point me to the steps of how I do that in detail please?
View Complete Post