Viewing 15 posts - 33,781 through 33,795 (of 39,736 total)
Why the waitfors?
The code appears to wait, you just need to take a parameter for the month, or two, like
declare @mn char(2), @yr char(4)
declare @start datetime, @end datetime
select @start...
August 4, 2005 at 11:00 am
Do you have column names in the XLS?
August 4, 2005 at 10:55 am
Lee has a great summary although I'd avoid the linked server item. If you're a public corp I'm sure it would violate Sarbanes Oxley standards.
I've always done backup/restore, but the...
August 4, 2005 at 10:54 am
I think Phil is right. There's on date info in sysindexes. There might be something encoded, but nothing I know of.
August 4, 2005 at 10:53 am
You're going to have downtime, so the easiest thing is to backup master and msdb.
Then detach all user dbs.
Now uninstall
Reinstall
attach dbs
restore msdb
restore master.
August 4, 2005 at 10:47 am
And be sure you apply patches/SPs before restoring master adn msdb.
August 4, 2005 at 10:47 am
Thanks for the update. Perhaps the multiple growths were causing some error. If you get a chance to test it on another box, we'd love to know what you observe.
August 4, 2005 at 10:46 am
Can you add a new login?
Or try to change the dbo mapping to sa and then add your new login? Sounds like you've got the issue figured out, but I'm...
August 4, 2005 at 10:45 am
You might try, if you can, removing and reinstalling the client tools. I'm sure something got mucked up in the install. My XP SP2 worked fine with SP4, but I...
August 4, 2005 at 10:43 am
I guess the cursor thing is possible, but I haven't seen that to be an issue. I thought that cursors would grab a copy of the data to hold it,...
August 4, 2005 at 10:41 am
If you have a firewall nearby, you might be able to do some port redirection if needed.
August 4, 2005 at 10:40 am
Throw - "Can't you just throw all that data onto a report?"
August 4, 2005 at 10:33 am
Dreams are great, but you need to ask. Next time you get a review or an interview, ask for a bit more and see what happens.
August 4, 2005 at 10:32 am
Anytime and thanks for the update.
Did you script them out? Just checking in case someone else searches the thread.
August 3, 2005 at 12:58 pm
Viewing 15 posts - 33,781 through 33,795 (of 39,736 total)