homepage Welcome to WebmasterWorld Guest from 23.22.128.96
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
Help with MSSQL Server Project
andrewsmd




msg:4075183
 10:26 pm on Feb 5, 2010 (gmt 0)

I am trying to implement a website that was developed on a test server and make it go live. I am running into an issue with a function within the DB that decrypts a password. Here is the function

USE [ward2004]GO/****** Object: UserDefinedFunction [dbo].[DecryptDES] Script Date: 02/05/2010 16:19:47 ******/ALTER FUNCTION [dbo].[DecryptDES](@value [nvarchar](4000))RETURNS [nvarchar](4000) WITH EXECUTE AS CALLERAS EXTERNAL NAME [SqlServerProject3].[SqlServerProject3.UserDefinedFunctions].[DecryptDES]
USE [ward2004]

GO

/****** Object: UserDefinedFunction [dbo].[DecryptDES] Script Date: 02/05/2010 16:19:47 ******/

ALTER FUNCTION [dbo].[DecryptDES](@value [nvarchar](4000))

RETURNS [nvarchar](4000) WITH EXECUTE AS CALLER

AS

EXTERNAL NAME [SqlServerProject3].[SqlServerProject3.UserDefinedFunctions].[DecryptDES]


The problem is, when we try to switch to the live server I get an error because that function doesn't exist. If I try to create it then I get an error saying it can't find the project in the last line "EXTERNAL NAME..."

My question is, what is that sqlserverproject3 and where can I locate it. I am not a DB guy so this is way beyond me. Thanks,

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved