or differential if you have them.

Simple recovery logs just about the same as Full recovery although some transactions are minimally...

what is the error you are seeing?

in Profiler select the "Audit Shema Object Access Event" and filter it to look for your database name and object name (this should match the name of the table)

the following should generate the alter schema commands to change schema for any Stored Proc not owned by dbo

select 'alter schema dbo transfer ' + sch.name + '.' + tab.name

from...

if a manager asks you to setup Perfmon to monitor sql server processes and uses (especially on a multi instance box) he wouldnt expect you to say " yeah i'll...

i had a telephone interview last week for a job and the interviewer asked me to provide port numbers for some commonly used TCP ports (e.g. DNS, SQL, POP3,etc). If...

GilaMonster (3/8/2009)

---

Server or client, how important is it really for a candidate to know that?...

also depends on if they mean client or server side. Server process is sqlservr.exe

aww shuks, i been lookin for that one LOL

oh you do those too in your spare time Paul! LOL

we use Redgate and set the redgate extended stored procedure to 'verify', not...

Sailor (3/6/2009)

---

I was told it has 8 drives.

Disk time on all servers is pretty low. Only one of them has any sort of activity which around 10%...

that's a good point Jeff, although Simple and Bulk Logged recovery do minimally log create and alter index transactions

as already mentioned, you really do need to take a good look at the disk subsystem

minimum you could get away with would be

RAID1 for OS (2 disks)

RAID1 for logs...

dastagirid

i am assuming from your post that you want a script to generate an insert statement for each row in a table, is that correct? If so, take the following...

Gail

i was under the impression that a database backup in simple recovery mode also initiates a checkpoint which will truncate the log file