what about a differential backup? would that cause a problem?

Well as DBA I think I should have some type of policies regarding security. Was wondering if there was any starting points out there for 'good practices'. Its audit time...

my guys in a panic changed the password so now the last updated field is set to the time they changed it. is there any type of log to track...

Are any of your servers running the base line version of SQL 2000? NO sps? and Win 2000 sp2?

How would I use the substring command in a case like this ..

if carriage return found

substring(column_name,?,?)

Does the UPDATEXT function actually overwrite whats in the column? What would be the syntax on that? Sorry if these are ignorant questions.

Does the UPDATEXT function actually overwrite whats in the column? What would be the syntax on that? Sorry if these are ignorant questions.

How about

select distinct candidateid,skill,count(*)

from table

group by candidateid,skill

order count(*) desc

I am alright with the speed. The fact is I have two tables right that have over 15 millions rows in each. I don't want the tranascaiton being logged because...

Thanks for all the helpful info. The non-logged operations might be the best way to go. Anyone have any good articles on other non-logged operations?

shouldn't it truncate the log on checkpoint if i have it set to simple backup recovery?

isnt there someway to clear out this log even while the process is running? I would hate to lose all these hours of time running.

Thank you that was very informative. IF STANDBY option works the way you say it, its exactly what I need. Thanks again!

So if you had a reporting server for which you wanted to keep the data refreshed as frequently as possible, how would be the recommended way of doing it? I...

I need to have it as update to date as possible on the offsite so thats why the log shipping was recommended because you are sending over logs for example...