Viewing 15 posts - 481 through 495 (of 5,678 total)
If you take a look at the first link in my signature below, you'll see how we usually prefer code assistance requests to be formatted. We're looking to have...
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
January 28, 2014 at 3:15 pm
I agree with Jeff here. Don't use that method, and give the SQLAgent running the job the necessary permissions, and save with no encrypted data.
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
January 27, 2014 at 4:26 pm
muthyala_51 (1/27/2014)
Hi,Can some one suggest what should i be looking at?
Concurrency.
The most typical reason two identical environments behave differently (and I do mean identical, down to the data in them)...
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
January 27, 2014 at 4:24 pm
SQLKnowItAll (1/27/2014)
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
January 27, 2014 at 2:33 pm
I hate to say it, then, but you've basically answered your own question.
The command's not getting to the server, and the service you're using to send it over isn't getting...
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
January 27, 2014 at 2:28 pm
I don't know if you need a full on table for this, but yes, you need to create a list somewhere, somehow, for this.
You can create the list in 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
January 27, 2014 at 1:41 pm
I'd start with running a serverside trace on the 2012 server to determine if the commands are even getting there.
If the commands are reaching the server, then it's something we...
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
January 27, 2014 at 1:37 pm
You need to add a profile to the dbmail. It's not security for the login, it's setup for the sysmail profile for the login
Check out msdb.dbo.sysmail_add_principalprofile_sp.
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
January 25, 2014 at 6:35 pm
"invalid profile" is not an exact error. Can you cut and paste the full error message here?
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
January 24, 2014 at 5:40 pm
Run away unless this is hourly. Just run.
Personally, I'd offer a semi-realistic plan based on their lack of data. Start with quoting them a 2 week period 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
January 24, 2014 at 5:38 pm
Lynn Pettis (1/24/2014)
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
January 24, 2014 at 2:20 pm
PARSENAME (usually used for server.database.schema.table) will work just as well for an IP4 address, and would save you some of your patindexing.
Can we see the query you're using to get...
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
January 24, 2014 at 10:46 am
GilaMonster (1/23/2014)
JustMarie (1/22/2014)
GilaMonster - I'm talking about the 2012 SEQUENCE object type.
In that case, Kraig's comments on contention don't apply, he was talking about the practice of creating a table...
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
January 23, 2014 at 10:15 am
JustMarie (1/22/2014)
The main problem this won't solve is the need for uniqueness across servers so this wasn't being considered for that one. GUID is the way on those.
Ah hah!...
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
January 22, 2014 at 12:51 pm
The problem with a sequence table isn't the uniqueness (it works), it's the contention you get when everything needs to access the single point. Because of that, GUID is...
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
January 22, 2014 at 12:03 pm
Viewing 15 posts - 481 through 495 (of 5,678 total)