I tested Quest, Idera, and Red Gate products a few years ago. The main feature I wanted was compression, although runtime was very important, too. I found the 3 products...

Timely discussion.

I'm arguing with one of our VisualStudio/.NET developers about column order in tables. He's asking us to move columns around so they appear where he wants to see them...

We run it in a .bat command file, and then execute that using scheduled tasks.

I just checked and unfortunately it doesn't look like it'll work with hours, only days.

http://technet.microsoft.com/en-us/library/cc753551.aspx

Sorry for the false hope.

We use the following to remove files x number of days old. I think it might work with hours, too.

For days:

forfiles /p C:\My Folder\ /s /m FilenamePrefix*.txt /d -7 /c...

We've used DB Mail on SQL 2005 - 64bit for several months now. It definitely works. Our OS is Windows 2003.

We enable it with these two scripts:

1.

use master

go

sp_configure 'show advanced...

Great editorial, Bill.

There are many opportunities for volunteerism today, and this is another one that deserves our support. We have to bring our government out from the shadows.

We've been having this problem on several servers. I ended up sticking this batch code into a schedued task.

@echo off

echo.

echo Removing old emrRun log files

forfiles /p C:\MSSQL.1\MSSQL\LOG /s /m MaintenancePlan*.txt...

We do something similiar to this with TSQL:

BULK INSERT dbname.dbo.[tablename]

FROM 'C:\FolderName\PipeDelimitedFileName.TXT'

WITH (FieldTerminator = '|',

FirstRow = 2) -- If you...

Our dbs and the associated application is supplied by a vendor. We had them create replication setup scripts for us, although we found we had to do some modification to...

Sorry I didn't respond sooner, but I was on vacation last week. 🙂

We publish 5 dbs totaling about 500GB - all from our Prod server to our Reporting server. The...

We use transactional replication with 3 servers: Publisher - Distributor - Subscriber. We off-load all reporting and job processing from the Publisher to the Subscriber. We only allow OLTP on...

tvu4251 (7/10/2008)

---

in Houston, only people with death wish are bikers. ... Also, there are some very militant bikers out there. they cruise along in the middle of the street around...

jezemine (7/9/2008)

---

I bike to work every day, 14 miles roundtrip. When I bought a house 3 years ago, I purposely bought a house that was within reasonable biking distance...

We've been extremely pleased with SQL Backup from Red Gate. When we priced LiteSpeed they were something like 8x more expensive then Red Gate. Red Gate licenses per server, not...