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,
