Viewing 15 posts - 37,006 through 37,020 (of 39,769 total)
Probably worth an article to discuss these, and I'd welcome feedback on what people think, but here's our issue.
We backup nearly 1TB a day of changed information. So our backups...
October 13, 2002 at 9:09 pm
That is what I thought. I was reviewing a setup for a client on SQL 7 and wanted to be sure.
My recomendation is to use scripts I've developed, but I...
October 11, 2002 at 10:32 am
Mine will delete everything less than tomorrow, which includes today's records.
I did misread. You'd want to delete everything less than today, so you can take
cast( month(getdate()) + '/' day(getdate())...
October 11, 2002 at 10:30 am
You'd need to develop a script that will write out the necessary parameters and build the mail from scratch. Or use an ActiveX type object. Persits software has a free...
October 11, 2002 at 9:57 am
You'd have to include in the where clause
where cola is not null
and colb is not null
...
Steve Jones
October 11, 2002 at 9:34 am
use coldate < dateadd('d', 1, getdate())
Steve Jones
October 11, 2002 at 9:30 am
I agree that a password should be created. We delete sa? Doesn't make sense.
Steve Jones
October 11, 2002 at 9:20 am
Antares has the best solution.
Steve Jones
October 10, 2002 at 6:31 pm
Of every word? If the first word, use substring and upper() and lower()
select upper(substring(col,1,1)) + substring( col,2)
Steve Jones
October 10, 2002 at 6:29 pm
I think it will be enough. Nice to know the others, but not necessily needed. Last I saw, Yukon wasn't completely set, so not sure how much .NET will be...
October 10, 2002 at 6:28 pm
DTS can do this. Bulk Copy can, but you'd probably want to do a DOS find and get the lines you need into a separate table.
Or load hte whole thing...
October 10, 2002 at 12:36 pm
Running XP Pro, using Domain (AD Native mode) and no issues changing passwords. Do it every 30 days (4 so far).
Steve Jones
October 10, 2002 at 12:35 pm
I'd agree. Depends if you need it. You could also denormalize and include some of the FK stuff into the table.
Steve Jones
October 10, 2002 at 12:34 pm
no, it's a bug. I've seen it disappear on some pages. Always on the home page though.
Steve Jones
October 10, 2002 at 12:31 pm
I'm an MS user and have been working with SQL Server for 12 years. I've only developer (briefly) against Oracle, and that was 7, so I'll admit first off that...
October 10, 2002 at 12:27 pm
Viewing 15 posts - 37,006 through 37,020 (of 39,769 total)