Hiiiiiiii all
I have to make a user defined function in c# as the class liberary and create a dll file, now i want to use this function in SQL Server 2005 as a part of CLR Integration
I have tried like this
CREATE
ASSEMBLY abcFROM 'C:\abc.dll'
WITH
PERMISSION_SET = SAFE
but it gives me
incorrect syntax error
so plzzzzz anyone help me wht to do in my probbbbbbbbb
Pratik Kansara
Hiiiiiii
the exactly error message and syntax is like tht
CREATE
ASSEMBLY abcFROM
'C:\abc.dll'GO
and the error message i m getting is:
Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'ASSEMBLY'.
and i have also tried in sql server 2000 instance but as far as i know tht CLR Integration in SQL Server 2000 is not possible.
plz plz give me solution, i need it urgently...
Thnxxxxxxx
Pratik Kansara
Hiiiii
the exact code tht i m writing is and error message is as bellow...
CREATE
ASSEMBLY abcFROM
'C:\abc.dll'GO
and the error message is :
Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'ASSEMBLY'.
and i have also tried in SQL Server 2000 instance also but as far as i know tht this is not possible in SQL Server 2000 because SQL Server 2000 does not support CLR Integration
so plzz plzzzz help me i need it urgently
Thnxxxxxxxxx so muchhh
Pratik
Respected Sir,
First of all thanks a lot for replying my mail
Sir, Recently i checked a blog and i going to knew tht there is a compitibility problem in my Sql Server tht u have mension
i have a database name Job which i have made in SQL Server 2005 now while chacking the compitibility using following syntax:
sp_dbcmptlevel
Job
it gives me
The current compatibility level is 80.
means tht its a comitibility of SQL Server 2000 and also when i checked the property of my Database then in Option tag i found compatibility Lavel to Microsoft SQL Server 2000(80) and i m not getting here level SQL Server 2005(90)
and after executing the syntax
SELECT
@@version
i got the message
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
and sir I m using Microsoft SQL Server Managment Studio tool for CREATE ASSAMBLY statement
so sir the problem as i think we got is compitibility lavel so sir i have created this database in SQL Server 2005 also
then why i m not getting here compatibility lavel 90 or SQL Server 2005
and sir another thing is tht when i m executing the statement
sp_dbcmptlevel
Job, 90
then it gives me following error:
Msg 15416, Level 16, State 1, Procedure sp_dbcmptlevel, Line 92
Usage: sp_dbcmptlevel [dbname [, compatibilitylevel]]
Valid values of database compatibility level are 60, 65, 70, or 80.
thnks a lot and plz plz send me this solution.......
once again thnks
Pratik Kansara wrote:
and after executing the syntax
SELECT @@version
i got the message
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
and sir I m using Microsoft SQL Server Managment Studio tool for CREATE ASSAMBLY statement
so sir the problem as i think we got is compitibility lavel so sir i have created this database in SQL Server 2005 also
then why i m not getting here compatibility lavel 90 or SQL Server 2005
Respected Sir
yes i m connected to SQL Server 2000 from the SQL Server 2005 Managment Studio but sir i have cheked the configration tools and other option but i cant find out how to connect to 2005
So will you plz help me how to connect to SQL Server 2005 using Managment Studio
thnnking you so much
Respected Sir,
I have successfully solved this problem, and created a assambly in SQL Server thnkin you so much for helping me...