Viewing 15 posts - 36,256 through 36,270 (of 39,771 total)
Which part of the maintenance plan? I suspect that either the plan didn't create correctly or there is corruption in sqlmaint.exe.
Have you dropped and recreated the plan? Can you create...
June 12, 2003 at 4:19 pm
June 12, 2003 at 4:17 pm
June 12, 2003 at 4:08 pm
Be sure the sql server is running. Also are you using NT authentication or mixed?
Steve Jones
June 12, 2003 at 10:50 am
We standardize on RAID 1 for OS, RAID 1 for logs, RAID 5 for data. Sometimes split that further. For one high end DSS system we went with RAID 10...
June 12, 2003 at 10:47 am
Use DTS to transfer the logins after that. Sp_change_users_login to synch users/logins if you need to.
Steve Jones
June 12, 2003 at 10:41 am
Your company should have some policy spelled out, probably for email, that all activities may be monitored, blah, blah, blah. I suspec that this would cover profiler.
Of course, IANAL.
Steve Jones
June 12, 2003 at 10:31 am
srvinfo gets a bunch of stuff, but takes some parsing.
Steve Jones
June 12, 2003 at 10:16 am
As an aside, if you've run on SS2K/ W2K for a year, you are missing some valuable security patches. Not that you have to apply them, look at your...
June 12, 2003 at 10:15 am
Thanks, I'll try. It's one of those things that I wish I'd take the 2 days and do it since I see things I need to move fairly often.
June 12, 2003 at 10:08 am
Honestly part of the reason is also that this is a community. We hope that you visit the site more, not just read things through email.
Steve Jones
June 12, 2003 at 10:07 am
If you run the select without the insert does it return any rows? that's likely where your issue lies.
Steve Jones
June 11, 2003 at 10:54 am
.\ is the local machine, so it is using an account on that machine as opposed to the domain.
Steve Jones
June 11, 2003 at 10:53 am
June 11, 2003 at 10:52 am
It can't find the server. Is it started?
Steve Jones
June 11, 2003 at 10:51 am
Viewing 15 posts - 36,256 through 36,270 (of 39,771 total)