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)

WebmasterWorld Senior Member 5+ Year Member

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,

Featured Threads

Hot Threads This Week

Hot Threads This Month