Viewing 15 posts - 916 through 930 (of 1,319 total)
Ummmm - I believe a resolution was attained 4 months ago (and your suggestion was more or less proposed 6 months ago!).....but that's just me 😀
-- You can't be late until you show up.
September 12, 2008 at 7:27 am
Homework/project - what's the difference?? You mentioned msdn. Here's the link. Use a query to get the data that you need. If you make a honest effort and get stuck,...
-- You can't be late until you show up.
September 12, 2008 at 6:11 am
FYI - Upon further investigation of the servers and interrogation of the former DBA, I found out these were remote servers created several years ago. They're history now!
-- You can't be late until you show up.
September 11, 2008 at 1:33 pm
Does it have to be bcp or can you use some of the native SQL tools like DTS? DTS can do this very easily.
-- You can't be late until you show up.
September 11, 2008 at 1:14 pm
Thanks Manu! Sometimes the obvious proves elusive. In the words of the immortal Homer Simpson - "DOH"! sp_dropserver did the trick. :blush:
-- You can't be late until you show up.
September 11, 2008 at 12:50 pm
Google yielded this, among others. Some interesting stuff that may help you solve the mystery.
http://www.sqlservercentral.com/articles/Administering/howtousetraceflagsinsqlserver2000/1860/
-- You can't be late until you show up.
September 10, 2008 at 12:39 pm
I'm running SQL2K sp4 and this message is not in my logs, even after a server restart. Possible it's in your startup parameters?
-- You can't be late until you show up.
September 10, 2008 at 12:24 pm
Hardware is most always the culprit. Check your event logs for disk errors and run hardware diagnostics to see what causing your corruption issues.
-- You can't be late until you show up.
September 8, 2008 at 10:32 am
Thanks. I've already run one of the scripts and it created the job fine. Again, paranoia on my part - I think because it seemd too simple (good ole' MS!)....
-- You can't be late until you show up.
September 5, 2008 at 12:31 pm
Upon closer inspection, it appears it does want to ADD the steps, not execute them. I'm very skittish with these two jobs because there are references to linked-production servers within...
-- You can't be late until you show up.
September 5, 2008 at 10:55 am
Any maintenance jobs running (index rebuilds, checkdb)? Large adhoc or runaway queries? Is the tempdb set to autogrow? The log file seems awful small for tempdb (.59 mb??) with 24Gb...
-- You can't be late until you show up.
September 5, 2008 at 8:55 am
Nope, using IE. Deleted temporary internet files and all is good. Hate doing that because I lose all my "remember me" logins and now have to re-type them. :crazy: I...
-- You can't be late until you show up.
September 5, 2008 at 8:23 am
That's what I was doing, searching for a recent script. Based on another topic, Steve stated he had approved/posted two new scripts. I couldn't find them but as I was...
-- You can't be late until you show up.
September 4, 2008 at 3:22 pm
I'm trying to picture the difference between an inner join and an outer join, (outer join sounds painful)....or a one-to-many join - woohoo!! Seems like the possibilities could be endless...
-- You can't be late until you show up.
September 4, 2008 at 2:26 pm
Mark, you've got a pretty good handle and argument for why you shouldn't be doing what you obviously, short-term, have to be doing. SQL Server does not tolerate latency very...
-- You can't be late until you show up.
September 4, 2008 at 12:35 pm
Viewing 15 posts - 916 through 930 (of 1,319 total)