Just to add. Since this DLL is written in C, you might want to consider adding it as your own extended procedure with sp_addextendedproc

Counterquestion: What kind of environment are we talking about? OLTP or OLAP. How many users, transactions, size of db, uptime requirements....

In the meantime have a look here:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx

Yes, that's right. It's really magic how one romantically glorifies such things once they are gone.

Btw, forgot to say: Nice to know your real first name, Johan!

This might also be of some help

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=15272

You need to put everything inside a string, including the cursor stuff and execute this. See http://www.sommarskog.se/dynamic_sql.html

May I add that dynamic sql + a cursor + a UDF...

Well, today start everyday's life again. Curious what my wife will look like this afternoon

And to be honest, I don't like the first...

Yes, that was the link. I must admit, I haven't read it though

Just out of curiosity:

Would anyone use the SSN as Primary Key? What about privacy or data protection in this case?

I agree. An interesting idea. But at the same time I think, it won't help much here. People seem to post to online communities (here or anywhere else) without even...

No discussion. I think it was an article there.

Patrick,

thanks for digging this out! I knew I read it somewhere, but apparently didn't work through the discussion on it. They should have edited the article on SQL Team anyway thereafter...

Glad I could remind you, Patrick.

Well, a lot of people might wonder, how do I get the time to keep a post count that high. Let me say, I post a lot while hanging on...

Might be wrong, but I think I have seen something useful on SQL Server Performance. Due to my f@%$&ng slow connection, I leave it up to you to look...

And while you're at SQL Server MVP Erland Sommarskog's site, read also his article on dynamic searches. It helps explaining dynamic sql, too. And gives some information you don't find...