thnaks for the DecryptByKeyAutoCert !

solved using

http://msdn.microsoft.com/en-us/library/ms182559.aspx

there is a bug opened on that issue

check if the service is running as "NetworkService"

and change it to a user with Admin priviliges.

after it restart the service and check again

good...

did you manage to solve the problem?

i got the same one

Thanks

peleg

i send data to a STORED PROCEDURE in the db.

this STORED PROCEDURE insert data and raiserror.

the thing is that the problem is between how an exception occusres when for example...

thats not the problem

beacuse i added aleardy all the messages that i wanted to sys.messages

this is the vb6 code : (when i dont use the try/catch/error i do get back the error on line (***)

g_Command.Execute -- executes the STORED PROCEDURE

If...

Lamprey13 (7/28/2009)

---

It's been a while since I set up my stored procedure template with error handling, but I *think* you need to use the ERROR_NUMBER() function inside the CATCH block....

it still dosent help

seems that only add_message can help in this case

i want to store text in a table with unique value of a column of type nvarchar(200)

and to be able to search (fast ) for text...

Thanks

Peleg

how do i do the same in sql 2000 where the row number ability dosent exist?

i have move to row into :

ROW_NUMBER() OVER (PARTITION BY id ORDER BY case when val1 is not null then 0 else 1 end)+(case when val2 is not null then...

ok the code work,but when i try to add an order by i get this error :

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and...

i do this

SELECT CAST(NULL as NVARCHAR(50)) as Company , CAST(NULL as NVARCHAR(50)) as ServiceName

INTO #ReportTable

when i check the COLLATION of the column i see it's :

SQL_LATIN1_GENERAL_CP1_CI_AS

i want to mention that the certin tables that there index were removed, wont be updated ever again!

the question if i will want in the future to put an index,...