Stack Overflow
Stack Overflow

Questions tagged [extended-procedures]

Extended stored procedures let you create your own external routines in a programming language such as C

Extended stored procedures let you create your own external routines in a programming language such as C. The extended stored procedures appear to users as regular stored procedures and are executed in the same way. Parameters can be passed to extended stored procedures, and extended stored procedures can return results and return status.

Extended stored procedures are DLLs that an instance of SQL Server can dynamically load and run. Extended stored procedures run directly in the address space of an instance of SQL Server and are programmed by using the SQL Server Extended Stored Procedure API.

9 questions
1
vote
2 answers

Finding standard Sql Server dll files on the computer

I am trying to add an extended stored procedure to Sql Server. I need to put the code for it in the same folder as the standard Sql Server dll files. I know the default place that they're stored is C:\Program Files\Microsoft SQL Server\Mssql\Binn,…
dmr
  • 21,811
  • 37
  • 100
  • 138
1
vote
1 answer

How to call an extended procedure from a function

hi im having trouble trying to get the following function to work. CREATE FUNCTION test ( @nt_group VARCHAR(128) ) RETURNS @nt_usr TABLE ( [name] [nchar](128) NULL , [type] [char](8) NULL , [privilege] [char](9) NULL , [mapped…
Alan Featherston
  • 1,086
  • 3
  • 14
  • 27
1
vote
2 answers

TypeError: Math["floor"] is not a function

I'm learning Javascript, so this question may seem ludicrous for most JS coders. I'm reading Javascript: The good parts, and I can't make this piece of code work: Function.prototype.method = function(name,func){ this.prototype[name] = func; …
Fabinout
  • 878
  • 7
  • 25
1
vote
2 answers

How to create an extended stored procedure in SQL Server 2000

I need to create an extended stored procedure in SQL Server 2000 using Visual Studio. It worked fine in SQL Server 2008 and 2012. I followed the instructions described here after adding the dll the stored procedure does not run! The procedure to…
Mushfiq
  • 759
  • 1
  • 8
  • 41
1
vote
1 answer

Can srv_paramsetoutput() be used to set nvarchar(max) or varchar(max)?

I'm writing an extended stored procedure for SQL Server in C++. The user can provide OUT parameters which I can set using srv_paramsetoutput(). However, this seems to always fail when I try to set TEXT, VARCHAR(max) or NVARCHAR(max). Note that…
Robin
  • 698
  • 6
  • 25
0
votes
0 answers

Where to get documentation on and/or source of SQL Server Migration Assistant extended procedures?

I am running into login timeout errors while calling a procedure that uses xp_ora2ms_exec2_ex through JDBC. There's nothing in the SQL Server Profiler trace log. The DB was restored from a back-up. I'm wondering if some setting did not get…
Chry Cheng
  • 3,378
  • 5
  • 47
  • 79
0
votes
1 answer

MSSQL could not find the function in the library

I would like to test extended stored procedure (I know that they are now deprecated, but from personal reason I would like to test them). I have generate a dll file in VC++ and here is my code: //First.h #include #include using…
Kaja
  • 2,962
  • 18
  • 63
  • 99
0
votes
1 answer

Is there is any way to drop/hide system extended stored procedures?

After running McAfee ePolicy Orchestrator 5.1.0 report for our DB (SQL Server 2008R2) got a bunch of items of the next view: The stored procedure xp_xxx is enabled. It is recommended to drop it if not needed. We've checked and all these xp_xxx…
Pavel Krupski
  • 28
  • 1
  • 4
0
votes
4 answers

xp_delete_file not removing old backups

This command is not deleting backups: EXEC xp_delete_file 0,N'F:\path\cms',N'*.bak',N'2014-01-30T21:08:04' Also tried EXEC xp_delete_file 0,N'F:\path\cms',N'bak',N'2014-01-30T21:08:04' and EXEC xp_delete_file…
Jeff Shain
  • 767
  • 3
  • 9
  • 21