How to deploy assembly from remote system, without using VS.NET

Hi

I'm developing a tool to deploy the CLR objects from any where to the server

But I'm unable to deploy from remote system to the server.

I'm getting the error like

CREATE ASSEMBLY failed because it could not open the physical file 'D:\Working\DBS2005V2\GL\GLREPORTS\DBS.GL.RM.SQL\bin\Debug\sample.dll': 3(The system cannot find the path specified.).

when I try to deploy using

EXEC dbo.sp_executesql @.statement = N' CREATE ASSEMBLY [DBS.GL.RM.SQL]

FROM ''D:\Working\DBS2005V2\GL\GLREPORTS\DBS.GL.RM.SQL\bin\Debug\sample.dll''

WITH PERMISSION_SET = SAFE'

can anybody tell how to generate assembly_bits for assembly

the VS.NEt is generating assembly bits instead of physical path to deploy the assembly on the remote server.

as

CREATE ASSEMBLY [sample]

AUTHORIZATION [dbo]

FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD215 ..

WITH PERMISSION_SET = SAFE

But nothing is provided reg this in MSDN.

will u help me in handle this please

Thank u

See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=288119&SiteID=1 for code that will allow you to generate the assembly bits string.

How to de-install SQL Server 7.0

I am unable to de-install 120 days evaluation version of
SQL Server from my desktop running Windows XP Home
edition. While attempting to un-install, I get the
following message:
" unInstallShield has detected that 'C:\MSSQL7
\BINN\sqlmangr.exe' is in use. Please close the
application using this file and unInstallShield again."
Please advise.SQLMANGR.exe is the manager program in the task tray at the bottom of your
screen that allows you to stop and start SQL processes. Right click on the
icon that looks like a little server with a red or green arrow and close
it... or you can kill the sqlmangr.exe process from Task Manager...
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"TJ" <tajammalw@.msn.com> wrote in message
news:075401c399c6$eab57240$a101280a@.phx.gbl...
> I am unable to de-install 120 days evaluation version of
> SQL Server from my desktop running Windows XP Home
> edition. While attempting to un-install, I get the
> following message:
> " unInstallShield has detected that 'C:\MSSQL7
> \BINN\sqlmangr.exe' is in use. Please close the
> application using this file and unInstallShield again."
> Please advise.