Re: how to decrypt an encrypted stored proc in 2005

When I use your stored proc on SQL 2005, i get following error message:

Invalid object name 'sys.sysobjvalues'.

Is something I am doing wrong or the Stored Proc is broken?

Let me know.

Thanks.

.

Relevant Pages

  • RE: Inserting/deleting data in table in multiuser environment
    ... Add a field to the table in the SQL DB? ... Capture the value to a variable before you send it to the stored proc, ... I did create a table in a front-end to just copy data from that table on SQL ... the stored procedure will be running each time with report generation anyway. ...
    (microsoft.public.access.modulesdaovba)
  • Retrieving primary key of newly added record
    ... stored proc explicty). ... key field is an identity/autonumber one in SQL Server - that is SQL ... I'm worried that if I do another explicit query, ... Handling concurrency with stored procs. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: full-text contains * issue
    ... You may also want to consider using a stored proc for this situation as it ... EXEC usp_FTSearchPubsInfo '' ... > no data but was concatenation of the fields I wanted to index. ... > This is the SQL ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Parameter Sniffing - Need more info
    ... Consider a stored proc defined as follows: ... In 6.5, at compile time SQL ... when compiling a plan. ... execution plans, but a key requirement for everything to work as expected ...
    (microsoft.public.sqlserver.programming)
  • Re: type argument in OpenRecordset method
    ... format call to stored proc ... The databases/tables on the SQL Server side are split up based on ... derive the fully qualified table name, the Access app does, in fact, ... things on the SQL side, and by providing this abstraction layer, it is ...
    (comp.databases.ms-access)