Viewing 15 posts - 646 through 660 (of 1,195 total)
Thanks for the update.
Irrespective of which solution you use, test it on your system. All of the solutions work against the 10 or so rows provided, but what's the hit...
April 25, 2014 at 6:45 am
Hi,
Thanks for supplying the data - it makes life easier for anyone answering your question - and it means you will get an answer quicker.
One (quick and dirty) way of...
April 25, 2014 at 3:05 am
crookj (4/23/2014)
Ed Wagner (4/23/2014)
Revenant (4/23/2014)
Ed Wagner (4/23/2014)
SQLRNNR (4/23/2014)
periwinkleBullwinkle
Rocky
Stallone
Rambo
Rainbow
April 25, 2014 at 1:32 am
Hi Tomyum,
I'm sure we can help out, but it will be easier with sample data and tables.
Please see the first link in my signature block for the best way to...
April 25, 2014 at 1:19 am
Koen Verbeeck (4/25/2014)
Easy one, thanks!(at the time of writing, 100% had the correct answer (20 attempts). Never seen that before)
Nope that's changed 93% of 30 answers now - 3% reckon...
April 25, 2014 at 12:48 am
crookj (4/22/2014)
Ed Wagner (4/22/2014)
BWFC (4/22/2014)
Ed Wagner (4/21/2014)
crookj (4/21/2014)
Ed Wagner (4/21/2014)
SQLRNNR (4/20/2014)
TomThomson (4/20/2014)
SQLRNNR (4/20/2014)
Revenant (4/19/2014)
TomThomson (4/19/2014)
rhythmk (4/19/2014)
Ed Wagner (4/18/2014)
Revenant (4/18/2014)
BWFC (4/18/2014)
crookj (4/17/2014)
Ed Wagner (4/17/2014)
SQLRNNR (4/17/2014)
pretenseassumption
postulation
Theory
Science
Thought
Concept
idea
horse
with no name
no pain
no gain
Amplifier
Loudspeaker
Mother-in-Law
Outlaw
Colt
Kid...
April 23, 2014 at 2:03 am
For the sake of completeness (and maybe reference for others).
The AD objects were migrated with SID history and nothing untowards happened 😀
All users were still able to see all the...
April 23, 2014 at 2:02 am
With out seeing your code, I can't give any pointers for where the error may be happening.
The only advice I can give is that it will most likely be generated...
April 23, 2014 at 1:00 am
First of all, you need to link the two servers (under server objects -> linked servers-> New linked server)
Then query the table in much the same way you would...
April 23, 2014 at 12:51 am
a4apple (4/10/2014)
TomThomson (4/10/2014)
Ed Wagner (4/10/2014)
Kurt W. Zimmerman (4/10/2014)
Revenant (4/10/2014)
Ed Wagner (4/10/2014)
SQLRNNR (4/10/2014)
trackerHunt
Dogs
Sun
Set
Up
Bottom
Feeder
April 11, 2014 at 1:23 am
Ford Fairlane (4/10/2014)
Interesting QotD - Learned something here.
+1
April 11, 2014 at 12:41 am
That's because there is an active connection to the database. You need to make sure that there aren't any connections before you restore a database
April 4, 2014 at 1:03 am
Spot on Steve - this is the same way I've been telling others to do this when they have lost their passwords.
April 1, 2014 at 1:38 am
Viewing 15 posts - 646 through 660 (of 1,195 total)