Viewing 15 posts - 42,286 through 42,300 (of 49,571 total)
paul.kuczwara (12/18/2008)
Is it possible to attach the DB even though it is looking for three NDF files?
No. Those are secondary data files, ie they contain part of the data...
December 18, 2008 at 1:35 pm
bitbucket (12/18/2008)
I give up ? What is it in U.S. English
Hoekom nie? Ek het eek vraag in Fraans geseen. Nie maklik to antwoord nie.
Why not? I've seen one...
December 18, 2008 at 1:16 pm
clementhuge (12/18/2008)
grea answer! This is a good news. I never thoughtI can do a snapshot on a database "in-recovery".
In general you can't. It only works for a mirrored database that's...
December 18, 2008 at 12:10 pm
clementhuge (12/18/2008)
When ou talk about snapshot, are you considering snapshots on mirrored databases ? because the mirrored databases are in recovery state, so I...
December 18, 2008 at 11:16 am
rew (12/18/2008)
Hi AllWhen I do "Index REBUILDs", my database files GROW. Alot! And the database is in "SIMPLE" recovery mode.
Yup. They will. Rebuilds are logged operations (though bulk logged in...
December 18, 2008 at 11:04 am
r.hensbergen (12/18/2008)
Oh no, my ancestors went to your country and.... We're family! 😉
Hehehe :hehe:
Actually I'm originally from the UK, so you don't have to worry. :w00t:
December 18, 2008 at 11:00 am
srawant (12/18/2008)
Gail will If I turn on that flag will it show me the graph of the past like it was occurred yesterday...
No. It will print the deadlock graph...
December 18, 2008 at 10:38 am
Steve Jones - Editor (12/18/2008)
Well, this is officially the longest thread on the site.
We win! :hehe:
r.hensbergen (12/18/2008)
December 18, 2008 at 10:36 am
You posted the second question only 3 hours ago (and the 1st question only 12 hours ago). This isn't a chat room. Be patient. If you need help urgently, contact...
December 18, 2008 at 10:17 am
You can enable traceflag 1222 (DBCC TRACEON (1222,-1)) to get the full deadlock graph written into the error log. That will tell you what the other process was.
As for the...
December 18, 2008 at 10:14 am
Ok.
Is there a question?
December 18, 2008 at 8:32 am
Chris Morris (12/18/2008)
.. the global temp table is available outside the scope of the dynamic sql.
Ah. I thought that the end of the dynamic SQL would mean that the last...
December 18, 2008 at 8:12 am
Jeff Moden (12/18/2008)
It's bad enough that we now have two national languages
Only 2? Be grateful, I've got 11. Only two of those are due to immigration (and both...
December 18, 2008 at 7:54 am
Ok, so you're implementing application load balancing, completely outside of SQL and DB mirroring for high availability.
What's the question then? I think I've missed something.
December 18, 2008 at 7:24 am
It'll be recorded in the default trace. There are 5 (or so) trace files in the SQL error log directory, that's the default trace (providing you haven't turned it off)
The...
December 18, 2008 at 7:12 am
Viewing 15 posts - 42,286 through 42,300 (of 49,571 total)