Home | Forums | Contact | Search | Syndication  
 [login] [create account]   Tuesday, October 27, 2020 
View User Profile  

 User Profile - Patrick Gaule  
Patrick Gaule
SilverStone Group


Log in to send this member a message!

 Patrick Gaule's Contributions
Patrick Gaule has contributed 1 comments and 0 articles.
Select to view:    
Comment: Re: Generating Table IDs in T-SQL - Version 2

Hey Jason,

I know this post is very old, but I'm hoping you still read this...

Is there any way to get this working as a User Defined Function on x64 SQL Server, similar to your original solution?  Your 64-bit solution requires a stored procedure (probably because you need to save the output of xp_cmdshell into a temp table, which is not allowed in a UDF).

We used the UDF/CLR method in a lot of external aplications and it would be too much of a burden to change all of thoese references to call a SPROC instead of a UDF.  We are now upgrading to x64 SQL Server and I ran into the roadblock of having the 32-bit SlxOleDb provider.  So far, it seems like our only option is to downgrade to 32-bit SQL server on the new server...any other ideas?

Author: Patrick Gaule - 12/9/2013


 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2020 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
page cache (param): 10/27/2020 9:45:15 PM