SP creation problem. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SP creation problem.

Author

Topic

psangeetha
Yak Posting Veteran

95 Posts

Posted - 2008-07-30 : 22:42:44

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.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-07-30 : 22:44:54

the store procedure xp_crypto is not found in master

KH
[spoiler]Time is always against us[/spoiler]

psangeetha
Yak Posting Veteran

95 Posts

Posted - 2008-07-30 : 22:53:54

But the procedure got created anyway. I didnt create the SP's and I am not sure what it is. Is this an error message or just a warning?

Thanks much

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-07-30 : 23:47:38

Yes it will still create your stored procedure.

It is a warning. But if you did not create that stored procedure xp_crypto you will encounter error when you run your Stored Procedure.

KH
[spoiler]Time is always against us[/spoiler]

psangeetha
Yak Posting Veteran

95 Posts

Posted - 2008-07-31 : 17:04:38

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

psangeetha
Yak Posting Veteran

95 Posts

Posted - 2008-08-04 : 09:30:26

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

psangeetha
Yak Posting Veteran

95 Posts

Posted - 2008-08-04 : 12:07:57

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

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-08-04 : 20:45:06

quote:
Originally posted by psangeetha

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

have you installed it into that new instance ?

KH
[spoiler]Time is always against us[/spoiler]

psangeetha
Yak Posting Veteran

95 Posts

Posted - 2008-08-05 : 09:18:32

Yes, We copied the dll to the new instance location and registered in the master database of the new instance

psangeetha
Yak Posting Veteran

95 Posts

Posted - 2008-08-05 : 09:24:56

I registered with the path of the dll. Its still the same error

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources