Viewing 15 posts - 35,896 through 35,910 (of 39,720 total)
Do you not have a backup that works?
Try attaching the MDF without the log file (rename it) and let the system recreate it.
If that doesn't work and you are really...
September 12, 2003 at 10:20 am
Actually more urgency since it's a similar attach vector so worms could appear very quickly.
SSC is patched as of today, will get rebooted tonight.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com...
September 10, 2003 at 5:06 pm
No it won't. It reports an instance is already running and won't run again.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 10, 2003 at 5:03 pm
In general NO, sometimes SELECT, but that's it. I guess Execute for Sprocs. NOTHING ELSE.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 10, 2003 at 5:00 pm
I recommend that anyway. If you have corruption in the file you could lose a whole bunch of backups.
If you really want them to be the same name, rename the...
September 10, 2003 at 9:58 am
Don't you want
getdate() < dateadd(d,1,DateofAction)
?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 10, 2003 at 9:57 am
Tend to agree. Not sure who needs else needs it, possibly banks (financials).
More of a pain, but it's easy to pick on for questions.![]()
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of...
September 10, 2003 at 9:51 am
Shazam!!!
Should be better. Apologies for not snagging that sooner.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 10, 2003 at 9:49 am
Great idea on the tips. We may start gathering them soon.
The book is live and shipping for those of you interested.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 10, 2003 at 9:44 am
Agree with that, but for most systems, most people, sparing a few constant I/Os along with 5% of the CPU might be a big benefit.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server...
September 10, 2003 at 9:43 am
This should help
If not, hopefully someone else has some resources.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 10, 2003 at 9:41 am
It does upgrade MDAC (potentially) to 2.71 (I think this is right, 2.7something). This could be an issue for some apps, I know it was here at J.D. Edwards. Some...
September 10, 2003 at 9:35 am
Usually the next number is the build. Not sure about the final one, maybe some build version or other tracker.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 10, 2003 at 9:34 am
Not from a single email address. You are welcome to sign up with a 2nd user for the newsletter.
Or setup a forward rule on your office to send things home.
Steve...
September 10, 2003 at 9:29 am
We'll take a look. It's on our list, but not a priority since it doesn't seem to affect many people.
Apologies. I'll try to see if I can reproduce it somehow.
Steve...
September 10, 2003 at 9:12 am
Viewing 15 posts - 35,896 through 35,910 (of 39,720 total)