if you have a corrupt log file you can attach it and create a new log. if it's a corrupt mdf file then you need to restore

there was an article in CIO magazine a few years back about how AT&T tried to implement a new CRM system and it was a total failure

CRM/ERM apps are...

we have it running on a server, and it needs a restart

personally it's more trouble than it's worth. makes the sql log too hard to read

my favorite method is the following

create new tempdb files on the drives you want them on

restart SQL

shrink the default tempdb files if they are large

set growth restrictions on them...

i've had these for various reasons, my first guess would be to make sure you have it installed and configured properly

what about adding a number column to the master table and using that in your loop?

i have databases where the log file is over 100GB and i leave it alone

shrinking files is bad for performance, especially if you have multiple files on the same disk

the book answer is you need to stop publication, but i have detached without doing so

make sure you check the box to drop all connections and you might have...

i haven't seen any and we have a bunch of alerts set up

i remember when I Love You or Melissa hit around 1999. i was in the army and working for the command group of my unit. Our Italian Army liason told...

when you create your SQL backup scripts in Veritas, in the original GUI where you choose the databases you can choose to do a page verify. you have to set...

write a query using the sessions and connections DMV's to dump data to a table. if you want you can get the SQL as well, but it's going to require...

article missed prevention and catching fraud as a reason for logging. we have triggers and management has caught people giving freebies to friends in the audit tables.

rebooted and the db came back all OK, took 15 minutes to recover

and i was hoping to try something i haven't done before

the data would go into the mdf