If you adopted a 12-digit char column instead, in a million row...

It's been my experience that most "strategic" decisions are made...

James Goodwin (9/26/2008)

---

It should be pretty clear by now to Eric that he isn't moving up in this company. But it is also possible that he doesn't really want...

Wait for it...

🙂

Jonathan Kehayias (8/19/2008)

---

To keep your CLR Assembly scalable, you might consider using a Enum of acceptable file types. Then your procedure could validate that the filetype provided is in...

You've both made a good point (I hate it when that happens).

Since the goal is really to delete text files, I can change the C# code to reject a file...

I was wondering when you'd show up to ask me that, Jeff 🙂

I have a stored procedure that creates files that are emailed as attachments by sp_send_dbmail. I...

Yep, that did it. I thought I set it to external access on the create assembly statement, but I guess not. Thanks for all your help.

I copied it to C:, then did this:

USE master

GO

-- First Create the Asymmetric Key from the Assembly

CREATE ASYMMETRIC KEY DftFileDeleteKey

FROM EXECUTABLE FILE = 'C:\SqlServerProject1.dll'

GO

--Now create a...

When you build a SQL project is VS, where does it put the assembly? I have to specify it for CREATE ASYMMETRIC KEY, but I don't see where on...

Thanks Johnathon, but how does the user in your example relate to the user who is actually going to run the stored proc? I have an Agent job that...

Show him an article that says that Oracle developers make 50% more than SQL Server developers...:w00t:

Yeah, I especially liked that last...

Matt Miller (6/11/2008)

---

If the SAN performance is decent - i'd even consider moving the data and log volumes onto the SAN, and keep the local volumes for paging file and...

Is it just me, or is there really a requirement that all corporate standards have to have at least one stupid element? I...