Viewing 15 posts - 4,696 through 4,710 (of 18,926 total)
Is the db in the db list?
Is the server case sensitive?
July 20, 2011 at 10:19 am
steveb. (7/20/2011)
I would go for the backup/restore method outlined above over the dettach/attach as this way you can have minimal downtime.
Also if you move the db and even...
July 20, 2011 at 10:18 am
You can do that in multiple steps to.
Take full backup, copy to new location and restore (norecovery).
Then the day before the move, take a diff and move / restore.
During the...
July 20, 2011 at 10:08 am
bopeavy (7/20/2011)
Ninja's_RGR'us (7/20/2011)
SQLRNNR (7/20/2011)
--------------------------------------------------------------------------------
Jannie-186227 (7/20/2011)
--------------------------------------------------------------------------------
ahem.
How do you reply to a thread with 23 thousand replies?
Is there any more value to be added in this thread?
Cheers
Jannie
Plenty of...
July 20, 2011 at 10:04 am
Guesses...
do you have hidden columns in the report?
Do you have calculated columns?
do you have matrixes or groups to create new columns?
AFAIK, csv exports the raw data, nothing really formatted.
July 20, 2011 at 9:59 am
cfradenburg (7/20/2011)
July 20, 2011 at 9:57 am
SQLRNNR (7/20/2011)
Jannie-186227 (7/20/2011)
ahem.How do you reply to a thread with 23 thousand replies?
Is there any more value to be added in this thread?
Cheers
Jannie
Plenty of value - all watercooler - or...
July 20, 2011 at 9:55 am
GilaMonster (7/20/2011)
Ninja's_RGR'us (7/20/2011)
July 20, 2011 at 9:55 am
GilaMonster (7/20/2011)
Jim Murphy (7/20/2011)
July 20, 2011 at 9:50 am
sturner (7/20/2011)
anelson 66875 (7/20/2011)
July 20, 2011 at 9:47 am
That error is rally clear. It means that the pk value is already in the table (or twice in the data set you're inserting).
Try doing select PkKey FROM (select...
July 20, 2011 at 9:47 am
homebrew01 (7/20/2011)
Ninja's_RGR'us (7/20/2011)
bernard black (7/20/2011)
Find out what bars you've been at on Sat night. Get someone to monitor your behavior when you leave the bar.
I don't get it, care...
July 20, 2011 at 9:45 am
GilaMonster (7/20/2011)
Wow, normally people are complaining that the log file is too big...Leave the files alone unless you have a really good reason to do otherwise.
Ya that's a nice change...
July 20, 2011 at 9:44 am
Grant Fritchey (7/20/2011)
I really like that picture... well, the left side of it anyway.
Hey Grant, where can I buy it? 😉
July 20, 2011 at 9:41 am
Rob Schripsema (7/20/2011)
Toreador (7/20/2011)
But I then thought that was silly, and I was being unfair...
July 20, 2011 at 9:38 am
Viewing 15 posts - 4,696 through 4,710 (of 18,926 total)