Viewing 15 posts - 3,586 through 3,600 (of 5,678 total)
Sorry, saw this thread earlier but my life is a bit zany at the moment.
Remove the 100 percent part. There's no purpose to it and the old trick of...
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
March 24, 2011 at 3:47 pm
Side note: I use max posts per page... and we've hit 500 pages. 🙂
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
March 24, 2011 at 3:08 pm
Public is a database role, and as mentioned above, you can just outright remove said user from the database. However, this becomes a problem if you're doing NT group...
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
March 24, 2011 at 1:31 pm
allbymyself (3/24/2011)
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
March 24, 2011 at 1:24 pm
GSquared (3/24/2011)
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
March 24, 2011 at 1:03 pm
Koen Verbeeck (3/24/2011)
You can just store it into a ResultSet.Select single line and store the value in a string variable. You'll avoid the for each loop this way.
*facepalm* Thanks...
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
March 24, 2011 at 2:05 am
There's no where clauses on any of this, you're mass updating in multiple passes... Yeah, that's gonna hurt.
The nc index really only hurts if you're updating something 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
March 24, 2011 at 1:51 am
I don't have SSIS in front of me, but I'm 99% sure you can load the SQL Statement as an expression. Build out your dynamic query in the expression...
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
March 24, 2011 at 1:43 am
SQLkiwi (3/23/2011)
Stefan Krzywicki (3/23/2011)
I may go to that one. I think it is between yours and plan reuse.I'm giving away chocolate fish, if that helps...:hehe:
Warning: They melt if you put...
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
March 23, 2011 at 6:09 pm
imani_technology (3/23/2011)
Regarding the Script Component, how would I set the DTS.Variables("").Value to the value from the spreadsheet?
You wouldn't directly. You'd read the row into the stream in a datasource,...
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
March 23, 2011 at 6:07 pm
oskargunn (3/21/2011)
I found the solution on this site 🙂http://www.sqlservercentral.com/Forums/Topic554399-149-1.aspx
After adding the server name to the host file on the subscriber side (2K8) I was able to connect.
Thanks for the solution...
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
March 23, 2011 at 5:49 pm
FredS-1001785 (3/21/2011)
I get two cursors.
Well, no cursor declares in this code, I assume this is an excerpt then.
The first has references in code with a short string 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
March 23, 2011 at 5:48 pm
Jeff Moden (3/22/2011)
FredS-1001785 (3/21/2011)
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
March 23, 2011 at 5:42 pm
sqldba_icon (3/21/2011)
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
March 23, 2011 at 5:40 pm
First thing that comes to mind is dropping it out to a recordset destination and then using that in a foreach loop (with 1 loop for your one row) in...
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
March 23, 2011 at 5:31 pm
Viewing 15 posts - 3,586 through 3,600 (of 5,678 total)