Is there a chance there's a quota? Can you log in as the service account and test that way? It might help track things down.

Sorry for the delay in responding.

Then it's not security. Is this valid on the SQL Server windows host?

C:\Program Files (x86)\WinRAR\unrar

Did a file get created in the folder?

GSquared (9/23/2011)

---

Grant Fritchey (9/23/2011)

---

I went back and read the article again because it just doesn't feel right to me somehow and then I saw this:

The more I travel, the more...

Log in as the service account and try to run the command.

Or run this:

xp_cmdshell 'dir > \\silverthrone\gadata\IPC\dir.txt'

That will tell you if you can write to that folder. Also, the...

SQL Server doesn't need extra space. It needs the space of the files and if they exist there, then that's enough.

It's a security issue. It doesn't matter if you connect...

How do you determine which one to keep? note that SQL doesn't order records, so the order you see from a SELECT ORDRBY FROM MYTABLE isn't necessarily what you'll always...

Does the SQL engine have permissions to that folder? Or the proxy? This doesn't run under your account, but the SQL database engine service account (or proxy)

Grant Fritchey (9/23/2011)

---

GSquared (9/23/2011)

---

Grant Fritchey (9/23/2011)

---

Based on a long history...

Password Safe is an open source product.

Can you define what unresponsive means? Are you sure it's the server and not your client?

The inability to process a login usually means there are DDL triggers in place or...

Now I feel like an idiot and a little naive for using Amazon so much: http://t.co/gm3hPsGv

BenWard (9/23/2011)

---

If you understand what the server is ACTUALLY doing you can anticipate such problems and think about it before you run it.

People seem to forget that every tool, every...

Yes and no. You have the right idea, but the problem is that UserA is inside SQL Server. When you execute the CLR, you should still be inside SQL Server,...

Excellent list of...