Viewing 15 posts - 5,611 through 5,625 (of 5,678 total)
subash: Can you please do a quick double check if you have triggers on the table? Something hiding underneath could be part of the problem.
If you change that 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
September 10, 2010 at 10:38 am
2 things.
If you could set that table data up (the source) as a temp table insert that'd be great.
Your results look the exact same visually as the source, not sure...
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
September 10, 2010 at 10:29 am
The 1 is a literal value of 1. It's an optimization technique to not actually pull anything from the recordset to anywhere, since all you're doing is checking for...
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
September 9, 2010 at 5:07 pm
For an easy answer, wrap the entire item with:
IF EXISTS (SELECT 1 from inserted where idcontrato='2' and eicanalid = '91')
BEGIN
--The rest of your trigger code goes here
END
A few significant issues...
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
September 9, 2010 at 4:19 pm
THolley, what Steve posted above is your best solution if you're proc based, but if this is straight dynamic SQL from a front end code bed you're basically SOL without...
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
September 9, 2010 at 3:44 pm
Well, the sql command you'd want to use would be sp_executesql @sql, with @sql being whatever was typed into text1, and the send command to the connection being in button1....
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
September 9, 2010 at 3:14 pm
Using right joins your last table is the one that has to have records, then the second to last to expand it, and so on.
If you're looking for results, no...
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
September 9, 2010 at 2:19 pm
You're looking for the REVERSE() function, paired with a CHARINDEX() to find the location of the space.
This can be processor intensive, hopefully this isn't a regularly running proc and 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
September 9, 2010 at 2:15 pm
It sounds as though you may have restored these databases from another server to here. If this is the case, and these are SQL logins (not NT logins), use...
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
September 9, 2010 at 2:14 pm
I'd start with the internal security on the linked server object, see who it's imitating, and see if that login can get to the view/has access to the other server.
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
September 9, 2010 at 10:55 am
Definately looking forward to parts 3 and 4, thanks for the articles!
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
September 9, 2010 at 10:38 am
Jeff Moden (9/8/2010)
Heh... whatever. My point is that BOL isn't wrong for the item I posted. 🙂
For the item you posted, no, but since we're discussing 2k5 and that...
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
September 9, 2010 at 10:33 am
Do you have the SQL Server error that gets kicked up when you try to call the local view that looks to the linked server view from .Net?
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
September 8, 2010 at 5:35 pm
Steve Jones - Editor (9/8/2010)
If you have a lot of code, it's a pain. I guess you could use something like SQL Search (http://www.red-gate.com/products/SQL_Search/index.htm) to find the code.
An additional method...
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
September 8, 2010 at 5:16 pm
To answer the specific question: You *can* alter the database restoration method via an Alter Database command before you begin, and thus the logging will only store the transactions that...
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
September 8, 2010 at 4:58 pm
Viewing 15 posts - 5,611 through 5,625 (of 5,678 total)