July 30, 2008 at 8:43 pm
Hi all,
I am trying to create a few procedures. I am getting the below error for almost 5 procedures
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master.dbo.xp_crypto'. The stored procedure will still be created.
Not sure what this is. Please help. THanks.
July 30, 2008 at 10:38 pm
SQL Server attempts to maintain a cross reference of objects (e.g. stored procedures) and the objects that are used by them (e.g. other stored procedures, tables, views). When you create the a stored procedure it check whether the related object exists and if it does, then it can add a record to the cross reference table (it is called "sysdepends").
If related objects do not exist when you are creating your stored procedure that is OK as far as SQL Server is concerned since the cross reference only exists to help us out - SQL doesn't use it for its operation.
However, if the referenced object (xp_crypto) does not exist when you attempt to run the stored procedure, an error will occur and the execution will fail.
July 31, 2008 at 3:19 pm
Ok. Thanks.
I've created the xp_crypto procedure in Master database and it got created successfully.( we have copied the 'tripleDese.dll' to the sqlserver/bin location on the db server).
sp_addextendedproc 'xp_encrypto', 'tripleDese.dll'
And, I created the below procedure val_enc for encryption
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE procedure dbo.val_enc(
@in_data varchar(100),
@chg_flag varchar(1),
@out_data varchar(200) OUTPUT,
@error_out varchar(2) OUTPUT
)
as
exec master.dbo.xp_encrypto @in_data, @chg_flag, @out_data OUTPUT, @error_out OUTPUT
But when I execute this procedure, I get this error:
Cannot load the DLL C:\Program Files\Microsoft SQL Server\80\Tools\Binn\tripleDese.dll, or one of the DLLs it references. Reason: 193(error not found).
ANy help is appreciated. Thank you
August 4, 2008 at 7:29 am
I'm still working on this problem..
'Cannot load the DLL C:\Program Files\Microsoft SQL Server\80\Tools\Binn\tripleDese.dll, or one of the DLLs it references. Reason: 193(error not found)'
Has anyone faced this problem before?? Please give me your suggestions, will greatly appreciate it.
Thanks
August 4, 2008 at 10:08 am
Could it be like a permissions issue??
We just found out that the client has created the database as a seperate instance with its own master database.Could it be the reason for the problem?
THnak you
August 5, 2008 at 7:14 am
The .dll might need to be registered in your server.
Open the command prompt. Type in regsvr32 (flag list) (.dllname)
The flag list is as follows:
/u Unregister Server
/s Silent; Display no message boxes
/i Call DllInstall; when used with /u calls dll uninstall
/n Do not call DllRegisterServer; this option must be used with /i
I'm pretty sure you have to use the full path name of the dll to register it properly.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply