I'm confused as well. I'm assuming "they" is your client. But the fact that they don't like big numbers and you are generating a random 50 character number that you...

That's usually what that error means. Glad you got it resolved.

It occurs to me to wonder if the SQL users even have permissions to run your proc. If they don't, then EXECUTE AS won't do you any good.

If this is...

Salary.com posted an interesting click-thru article about 14 job hunting mistakes. Though y'all would be interested.

Upper left, under the banners:

http://www.salary.com/Articles/ArticleDetail.asp?part=par4104

EDIT:

Found another one. This one about bad habits.

http://salary.com/Articles/ArticleDetail.asp?part=par2041

Steve Jones - SSC Editor (6/9/2011)

---

Brandie Tarvin (6/9/2011)

---

Hey, Steve (and other Prius owners), I just heard about this and wanted to pass it along:

Toyota says a problem with electric power...

Steve Jones - SSC Editor (6/9/2011)

---

Brandie Tarvin (6/9/2011)

---

Just a reminder for anyone in or near Dallas this weekend. I'll be attending A-kon 22 to promote and sign anthology copies of...

No, but only because I don't use DB Mirroring at the moment. But it sounds like a resource issue since you're mirroring 6 dbs on that one instance.

Have you run...

So it's just that it will cause SQL Server to not use all the physical memory, not that it will cause the Zombiepacolypse or something equally horrendous, right?

Silly question that may not have anything to do with anything... Are you sure that the drive / folder in question has enough disk space for that database to even...

Then consider your issue might be that you have too much database and not enough memory. Altering the memory allocation is unlikely to fix performance issues if the server is...

sqlfriends (6/9/2011)

---

It's impossible for us now to get another sandbox for us to play with, no budget for that, the server hosts 4 vendor applciations related with network monitoring, ITSM,...

jcrawf02 (6/9/2011)

---

Jim Murphy (6/9/2011)

---

Congrats Gail! That's awesome.

The best part is that your posts are not useless point-getting restatements. Grrrr, I hate those. You post...

Have you ever gone to that network location and verified that the file is still there?

Have you ever run a network sniffer to make sure you weren't disconnected at the...

We have scripted backups that run as SQL Jobs via Litespeed and we never see those messages.

Does the ADO need to run the script itself or can it just...

Again, it depends, but I believe the blanket recommendation is to let SQL Server figure out memory allocation for itself unless you are having problems.

Too many people don't understand what...