December 2, 2008 at 10:02 am
I have recently migrated from 2000 to 2005 when i run a SP in 2005 ..I am getting this error ......I dont have any clue.Help me in solving this problem
Thanks Sudheer
December 2, 2008 at 10:38 am
Sudheer (12/2/2008)
I have recently migrated from 2000 to 2005 when i run a SP in 2005 ..I am getting this error ......I dont have any clue.Help me in solving this problemThanks Sudheer
It would help if you provided all the information needed to assist. The first thing is the complete error message.
December 2, 2008 at 11:10 am
Was this xp_varbintohexstr an extended stored procedure? You may need to copy the DLL into your 2005 MSSQL\Binn directory and re-register each procedure in that DLL using sp_addextendedproc.
December 2, 2008 at 11:13 am
Msg 2812, Level 16, State 62, Line 2
Could not find stored procedure 'master..xp_varbintohexstr'.
The statement has been terminated.
I dont have any idea wat this SP does
exec sp_addextendedproc N'xp_varbintohexstr', N'xprepl.dll'
December 2, 2008 at 11:35 am
Sudheer (12/2/2008)
I dont have any idea wat this SP doesexec sp_addextendedproc N'xp_varbintohexstr', N'xprepl.dll'
once the DLL is in the \Binn directory, this statement esentially creates the interface between T-SQL and the DLL, so that you can call the routines in the library with a T-SQL EXEC command. There's also a sp_helpextendedproc to list what extended stored procedures are already registered in the instance and sp_dropextendedproc to remove registered extended stored procedures.
July 5, 2010 at 10:19 pm
Hi All, I’m posting this in an old post cause i think its relevant.
Like the original poster, i'm migrating database from SQL 2000, but to a SQL 2008 environment.
I have a stored proc that uses xp_varbintohexstr. I don’t think this actually exist under extended stored procedures in SQL 2008.
Can someone please confirm. I looked every where on the net with out any success.
Thanks in advance,
Kay
July 6, 2010 at 3:22 am
On 2005
DECLARE @test-2 AS VARBINARY(MAX)
SET @test-2 = 0x4858FE25053CA4D236F3D61AE29668BA
SELECT @test-2 AS [VARBINARY]
,MASTER.dbo.Fn_varbintohexstr(@test) AS [VARBINARY SP]
,@@VERSION AS [SQL Version]
/*
VARBINARY VARBINARY SP SQL Version
------------------------------------------------------------------------------------------------------------------------------------------
0x4858FE25053CA4D236F3D61AE29668BA 0x4858fe25053ca4d236f3d61ae29668ba Microsoft SQL Server 2005 - 9.00.4028.00 (Intel X86)
*/
On 2008
DECLARE @test-2 AS VARBINARY(MAX)
SET @test-2 = 0x4858FE25053CA4D236F3D61AE29668BA
SELECT @test-2 AS [VARBINARY]
,MASTER.dbo.Fn_varbintohexstr(@test) AS [VARBINARY SP]
,@@VERSION AS [SQL Version]
/*
VARBINARY VARBINARY SP SQL Version
------------------------------------------------------------------------------------------------------------------------------------------
0x4858FE25053CA4D236F3D61AE29668BA 0x4858fe25053ca4d236f3d61ae29668ba Microsoft SQL Server 2008 (RTM) - 10.0.1763.0 (X64)
*/
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply