Welcome to WebmasterWorld Guest from 54.226.246.160

Forum Moderators: open

Message Too Old, No Replies

Help with MSSQL Server Project

     

andrewsmd

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]

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,
 

Featured Threads

Hot Threads This Week

Hot Threads This Month