Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Help with MSSQL Server Project

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

Senior Member

WebmasterWorld Senior Member 5+ Year Member

joined:June 10, 2008
posts: 1130
votes: 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]


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

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



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,