Search Results | SQL Server Performance Forums

transaction log help for beginner

Thread by: watts3000, Feb 24, 2006, 1 replies, in forum: SQL Server Log Shipping

I would like to ask is there an sql command that will tell you how many updates inserts and deletes have been commited to the transaction log? I...

sql server 2000 groups

Thread by: watts3000, Jan 13, 2006, 3 replies, in forum: General DBA Questions

Guys I'm having a problem creating groups for sql server. Basically I have a sql database that I need to give access to for an entire group.I went...

dts package moving oracle data to sql 2000

Post by: watts3000, Sep 11, 2005 in forum: SQL Server DTS-Related Questions

Anyone know how to resolve this problem

dts package moving oracle data to sql 2000

Post by: watts3000, Sep 8, 2005 in forum: SQL Server DTS-Related Questions

Ok I read the article but I don't understand all of this. I understand that if owner of the dts package is not in the sysadmin group that it will...

dts package moving oracle data to sql 2000

Thread by: watts3000, Sep 7, 2005, 3 replies, in forum: SQL Server DTS-Related Questions

I'm having a problem with a dts package that is supposed to import data from a oracle database.The dts package kicks off fine but its not putting any...

sql server transaction logs

Post by: watts3000, Aug 24, 2005 in forum: General DBA Questions

I have full recovery models in place

sql server transaction logs

Thread by: watts3000, Aug 24, 2005, 7 replies, in forum: General DBA Questions

I would like to know how transaction log size is managed. I now know after some reading that I can checkpoint the database in order to allow dirty...