No, you'll need to login as the SQLAgent and literally go manipulate their Inbox via Outlook or whatnot.

My initial reaction is why aren't you using Active Directory groups via Windows to manage this? When a person leaves, their login is deactivated, and that means they can't...

Nailed by the dupe post as well. Dangit, don't do that.

http://www.sqlservercentral.com/Forums/FindPost1314675.aspx

Couple of things. If it won't write while you're using it in BIDS, then you've got a pretty good shot to troubleshoot. First thing, put a data-viewer between...

Considering that's an error from a Send Mail task, my guess is you're actually out of mailbox space for that account. Time for someone to go in and archive/cleanup...

I come down on the opposite side of the fence from Anthony on this, for a few reasons.

First is memory usage. SSIS runs in its own memory space outside...

Removed until NetApp research completed... I was inaccurate. Depends on the NetApp setup.

Okay, NetApp CAN properly do backups and the like for SQL Server. What it can't do...

lbrigham (6/11/2012)

---

Basically, the entire lot of ITEM1 received on 1/1/12 was depleted and 500 units of the lot of ITEM1 received 2/1/12 leaving 2000.

I'm thinking a recursive CTE or something...

The part you care about is what I trimmed out of the original error.

laddu4700 (6/11/2012)

---

Description: "Login failed for user 'Domain\sqlservice'.". An OLE DB record is available. Source: "Microsoft...

Lynn Pettis (6/11/2012)

---

Evil Kraig F (6/11/2012)

---

You can load between ranges, which is what you're looking for, but not by row#, that's a construction meant for our sanity, not for use....

Assuming there were no mistakes with the Sessioning code (which, by how few wait types are listed, there wasn't) I'd have to assume what you're seeing there is the total...

You can load between ranges, which is what you're looking for, but not by row#, that's a construction meant for our sanity, not for use. You can use ranges...

+1 for the suggestions above, in particular the trace, since you can drag said person over to your desk and run exactly what they're sending you and show them the...

+1 for Ron's (bitbucket's) recommendation.

You CAN set a database to read-only mode. What that does, though, is make it read only to EVERYONE. Basically it avoid bothering to...

slunt01 (6/8/2012)

---

:unsure:

So i have the problem at work where i am rolling (union all) a bunch of tables together and to make it a little easier i want to be...