Sunday, March 11, 2012

Cannot CREATE ASSEMBLY

Hi,
I am new to SQL Server 2005 but not to dotnet development. I am trying to
use the CREATE ASSEMBLY on my machine that is running the developer edition.
The ASSEMBLY keyword is not highlighted as a recognised keyword and when I
run the SQL it fails (see below). Have I not enabled something or have I
just installed it incorrectly?
CREATE ASSEMBLY
helloworld FROM 'c:\helloworld.dll'
WITH PERMISSION_SET = SAFE
Regards,
LandersHello landers,
Some questions first:
a.) What error message do you actually get?
b.) What are you using for a T-SQL editor?
c.) If you run xp_msver, what output do you get?
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/

No comments:

Post a Comment