In creating user define data types in SQL server 2005 , i have done all the things you have given in the procedure.
I have succeeded in building the application.
But when i tried the deploy option for deploying my application, i faced an error message which i have mentioned on the next line.
Error message :-
"Incorrect syntax near 'SqlServerProject1'"
"SqlServerProject1" is my project name.
So please help me to solve this problem.
waiting for your reply,
successful build, means a correct program structure and not successful deploy, means something wrong with data base
it's a general error
check that you enabled clr and make sure the connectionstring is correct
otherwise if your database supports clr and connectionstring is correct
i just cant't figure out the problem
I have similar problem while I try to deploy the assemby to my database. I can use SQL Server Management Studio to import the maganged dll but from within the Visual Studio I get the following error: The current database compatibility level does not support managed objects.
I did run the
EXEC sp_configure 'clr enabled', '1' reconfigure
on the database but even when I got it imported manually I could not see my new data type nor the stored procedures I created.