Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Location
    India
    Posts
    2

    Question Unanswered: Device Activation Error

    Hi,

    I have set of stored procedures in SQL 7.0. They are all encrypted. I moved the whole set to SQL 2K. I took a backup of the SQL 7.0 version and put it in SQL 2K. Now, when I run the stored procedure in SQL 2K, I am getting an error as "Device Activation Error". This is happening when I run a stored procedure which is creating a new database and I am giving the MDF and LDF names as parameters. I have not met with any success in SQL Books. Please enlighten....

    Thanks,
    Srinidhi

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: Device Activation Error

    Originally posted by srinidhiv
    Hi,

    I have set of stored procedures in SQL 7.0. They are all encrypted. I moved the whole set to SQL 2K. I took a backup of the SQL 7.0 version and put it in SQL 2K. Now, when I run the stored procedure in SQL 2K, I am getting an error as "Device Activation Error". This is happening when I run a stored procedure which is creating a new database and I am giving the MDF and LDF names as parameters. I have not met with any success in SQL Books. Please enlighten....

    Thanks,
    Srinidhi
    what do you mean by encrypted stored procedures ?
    if you could post the code ,it could be more helpful.

  3. #3
    Join Date
    Jan 2003
    Location
    China
    Posts
    38
    Does the stored procedure works fine in SQLServer7.0 ?
    Last edited by 884813; 01-16-03 at 05:36.

  4. #4
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    So your SP is encrypted. It is written with incompatible MSSQL7 syntax.
    You can simply decrypt it. MSSQL2K encryption is weak.
    Get permitions to rewrite SP from developer and look at I-net.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •