Viewing 15 posts - 22,021 through 22,035 (of 39,824 total)
I'm not sure that employers are as concerned about you being current in your field, especially as educating yourself without experience might not be the greatest way to develop skill....
October 12, 2009 at 7:54 am
Very interesting responses. I have to say that I haven't necessarily had that experience, but I can see your points. There are definitely managers that worry they would be out...
October 12, 2009 at 7:48 am
We are looking through code today to see if we can do something. A number of users and IPs have been banned to try and combat this.
October 12, 2009 at 7:32 am
You shouldn't create tables accepting more than 8060 characters in the design, or use TEXT fields. That way you will not run into this error.
It's a warning only, and the...
October 12, 2009 at 7:28 am
The other thing you could try to do is pre-trap the error. If you know it's a particular type of data, then look for that data before you process it...
October 11, 2009 at 10:32 am
SSIS is not available in SQL 2000. Are you using SQL 2000 with DTS or SQL 2005 with SSIS?
If it's DTS, I think you're stuck with this error. What you...
October 11, 2009 at 10:31 am
Or you should just buy a 500GB-1TB USB drive, attach it restore, then shrink things down, set a better log size and make a new backup.
It's not much $$, and...
October 10, 2009 at 5:20 pm
@@error is your only way to do this in SQL 2000. Error trapping was fairly simplistic.
October 10, 2009 at 10:00 am
What you can do is lower the log file size on the source system, if it's appropriate, and then take a backup with a smaller log file.
Or get more disk...
October 10, 2009 at 9:59 am
For passwords, I typically just store a hash. Use a one-way function, compare hashes to see if it's a valid input.
October 9, 2009 at 2:38 pm
I don't think you can disable a trigger in SQL 2000.
2005, sys.triggers.
October 9, 2009 at 2:37 pm
That looks like an interview or test question.
Please make your own attempt and we'll help. You might want to look in Books Online for samples of stored procedure and insert...
October 9, 2009 at 2:32 pm
Can't you degrag the file on the drive? If it's really fragmented, I'd take some downtime on a weekend and try to clean it up.
October 9, 2009 at 12:01 pm
There is a day or two a year in my town. The announce it on signs and their website. It costs a little to recycle, and hopefully it's worth it.
October 9, 2009 at 11:59 am
Are you assuming that this thread made sense at one point?
October 9, 2009 at 11:54 am
Viewing 15 posts - 22,021 through 22,035 (of 39,824 total)