Viewing 15 posts - 40,681 through 40,695 (of 49,571 total)
Steve Jones - Editor (3/2/2009)
Always restore with NORECOVERY and then once you're sure you're done, run the statement Gail has listed above.
Agreed. Much safer than putting the WITH RECOVERY flag...
March 2, 2009 at 12:58 pm
ElSuket (3/2/2009)
March 2, 2009 at 12:57 pm
There must be someone who has access to the server. The errorlog's just a text file. Without knowing why the DB's suspect, it's hard to offer a solution, and the...
March 2, 2009 at 9:41 am
Lynn Pettis (3/2/2009)
You gave the OP EXACTLY what he asked for in his post.
Nope. Barry's solution equates to IIf([x]="YEN","JPY",IIf([x]="EURO","EUR",NULL)) , ie
If X = 'Yen' then 'JPY' ELSE If X...
March 2, 2009 at 9:32 am
Do you have up-to-date backups of this database?
Please look in the SQL error log on your production server and look for messages related to this database. There's a reason it's...
March 2, 2009 at 9:27 am
Restore Database < DB Name > WITH RECOVERY
March 2, 2009 at 9:22 am
RBarryYoung (3/2/2009)
Hmm, I think it's this:
Needs the else block as well
CASE x
When 'YEN' Then 'JPY'
When 'EURO' Then 'EUR'
...
March 2, 2009 at 8:59 am
MANU (3/2/2009)
What do we need to search for in case we manage to open the .mdf file in any HEXEditor?
Offhand I don't know. I know it's somewhere in the DB's...
March 2, 2009 at 8:10 am
Alvin Ramard (3/2/2009)
GilaMonster (3/2/2009)
*snigger*http://www.sqlservercentral.com/Forums/Topic666430-146-1.aspx
WOW, he got the hint!!!
It wasn't exactly subtle.
March 2, 2009 at 7:56 am
March 2, 2009 at 7:30 am
GSquared (3/2/2009)
Try dumping the data into a single table, in a test environment, with that index (with the first two reversed, as Gail suggested). See how that performs.
I'd like...
March 2, 2009 at 7:24 am
alstar (3/2/2009)
March 2, 2009 at 7:13 am
ammarghanem921 (3/2/2009)
More than 300!!
That's nothing. Last system I worked on (which did use dynamic SQL to reduce procedure count) had over 3000.
Rather write the procedures. The downsides of dynamic SQL...
March 2, 2009 at 6:57 am
alstar (3/2/2009)
any general thoughts?
Without seeing the code, no.
March 2, 2009 at 6:47 am
ammarghanem921 (3/2/2009)
A lot of them!!!
How many?
March 2, 2009 at 6:47 am
Viewing 15 posts - 40,681 through 40,695 (of 49,571 total)