Viewing 15 posts - 1,486 through 1,500 (of 5,678 total)
laddu4700 (6/12/2012)
Is this something I can do in SSMS-databasemail ?thanks
No, you'll need to login as the SQLAgent and literally go manipulate their Inbox via Outlook or whatnot.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 12, 2012 at 2:10 pm
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 12, 2012 at 1:53 pm
Nailed by the dupe post as well. Dangit, don't do that.
http://www.sqlservercentral.com/Forums/FindPost1314675.aspx
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 12, 2012 at 1:48 pm
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 12, 2012 at 1:46 pm
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 12, 2012 at 1:41 pm
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 12, 2012 at 1:10 pm
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 11, 2012 at 2:46 pm
lbrigham (6/11/2012)
I'm thinking a recursive CTE or something...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 11, 2012 at 2:41 pm
The part you care about is what I trimmed out of the original error.
laddu4700 (6/11/2012)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 11, 2012 at 2:23 pm
Lynn Pettis (6/11/2012)
Evil Kraig F (6/11/2012)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 11, 2012 at 2:21 pm
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 11, 2012 at 2:14 pm
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 11, 2012 at 2:08 pm
+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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 8, 2012 at 6:25 pm
+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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 8, 2012 at 6:22 pm
slunt01 (6/8/2012)
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 8, 2012 at 6:21 pm
Viewing 15 posts - 1,486 through 1,500 (of 5,678 total)