Viewing 15 posts - 24,976 through 24,990 (of 39,810 total)
I'd agree with Gus. I'd also start by being sure you are using N' data types (Nvarchar, ntext, etc.)
March 2, 2009 at 10:03 am
Haven't tested it, but this (http://msdn.microsoft.com/en-us/library/ms186865.aspx) seems to indicate it does.
It doesn't prevent another process or user from deleting them.
March 2, 2009 at 9:58 am
FWIW, I'd consider this the way to do things. Always restore with NORECOVERY and then once you're sure you're done, run the statement Gail has listed above.
March 2, 2009 at 9:57 am
I believe we used .dat in the old days (pre v6.5) at some point. That and .dmp were used, but they were by convention, no reason not to use them....
March 2, 2009 at 9:56 am
I'm not sure what is wrong, but how are you retrieving the backups from tape? There should be a header that you can read with the RESTORE HEADERONLY.
Also, it's recommended...
March 2, 2009 at 9:52 am
Interesting thoughts. I would have thought that most people wouldn't prune old procs, but quite a few people do seem to do it.
And a great point about DR procs. They...
March 2, 2009 at 9:51 am
Moved to data corruption.
As Gail mentioned the error log usually has an error code and description that can explain many of the reasons why a database gets suspect.
If it's a...
March 2, 2009 at 9:46 am
Are they? Salesforce.com is essentially a cloud service. That much different from an app? You wouldn't have to send all the images, formatting, etc. down, just the data. The XBOX...
March 2, 2009 at 9:44 am
You would need to provide more detail, or ask more questions for these, IMHO.
We are happy to help, but we want to see you do work. Thanks for putting in...
March 1, 2009 at 8:39 am
:), not bad.
How about a SQL JD, just argue the way things should be done in the database all day
February 27, 2009 at 5:00 pm
Tom Garth (2/27/2009)
:cool:It's also just plain dumb to leave them laying around like that.
It's not necessarily question of smart of dumb. It's easy to keep control of your app, but...
February 27, 2009 at 4:03 pm
Interesting split here. I'm mostly in the camp of not worrying about old stuff. I can see the issues with validating the old procs for upgrades/changes, so perhaps it's worth...
February 27, 2009 at 8:48 am
You can "reverse" the flow of geothermal. It's basically a heat pump and you jump the heat into the Earth, which presumably can absorb it. I'm not sure how much...
February 27, 2009 at 8:27 am
It shouldn't change. Have you checked if the values are being set in the tables? Maybe the GUI is hosed.
There should be some script that resets values. I've had scripts...
February 27, 2009 at 8:21 am
I don't know of a good reason to set this. I think it was something you might have altered in v6.5. Or maybe someone was getting an error at some...
February 27, 2009 at 8:18 am
Viewing 15 posts - 24,976 through 24,990 (of 39,810 total)