When I've used DTS to transfer a lot of records, I set the "Insert Batch Size" to 100,000 records or so. I sometimes got timeout errors if it was trying...

Just a thought ....  If you post this in the SQL section, under "Replication", you might get more viewers familiar with this topic.

Do you have any other replication already on this...

Why would Local Account work, but another account didn't work ?  Did your other Windows account not have any permissions ?

Just change the account that MSSQLSERVER & SQLSERVERAGENT uses to another account.

Software Compatablity Alert-

  Last year, I upgraded my Girlfriend 5.0 to Girlfriend 5.1, which

  installs itself as "Fiancee 1.0". Recently, I upgraded Fiancee 1.0 to

  Wife 1.0 and it's a...

Some of us old dogs are a little slow learning new tricks !

Here's another version (tweak as needed):

Of course, you can pass in the dates as parameters instead of hardcoding.

CREATE TABLE #Table1

 (WeekDate datetime NULL,

 DayOfWeek char(10) NULL)  ON [PRIMARY]

declare  @EndDate datetime,

            @WeekDate datetime

set @WeekDate...

Martin .... good points.  I do the same thing. I run an analysis of index fragmentation every couple of months, and then on a Sunday, I switch to Simple recovery,...

You can run SP_WHO2 to see active connections

Perhaps you should run your optimization jobs at a slow period once a week, right before a full backup. Then after the full backup, your t-log should be truncated back...

Simple Recovery (common in developement or static environments) - You cannot backup transaction logs. If you have a hardware failure, or data corruption, you will have to revert to your...

We did that a few years ago .... No problems that I recall

After having lost some developement work a year or so ago on a database that was not backed up regularly, we now just back up everything. All our DBs are...

I wouldn't recommend Bulk-logged either in a production environment.

The link doesn't work when I try it  🙁