Check out this site: http://www.sqlis.com/

I recall seeing there a File Watcher Task, and this may be what you need for your SSIS package.

😎

Even if nothing is inserted, the INSERT trigger still fires. You may want to add a test at the beginning of the trigger to test the number of rows...

If possible can you post what you came up? Others may have a similiar requirement.

😎

Okay, your turn. Would you please explain how you got it working (others may have a similiar problem to yours)? Also, are you still using a cursor?

😎

BACKUP DATABASE ADVENTUREWORKS

TO DISK= N'C:\AW.bak' -- Attempting to create backup file in root directory

WITH STATS= 5

BACKUP DATABASE ADVENTUREWORKS

TO DISK= N'C:\backup\AW.bck' -- Creating backup file in the backup directory

WITH STATS=...

It may be job security, but I too would have looked for a way that would not require a rewrite if it was not needed.

😎

Not really. The question specifically stated SQL Server 2005. The assumption here is that you are using SQL Server 2005 tools, not SQL Server 2000 tools to access...

brownsea (9/10/2008)

I have a problem with my test server when i generate a backup

BACKUP DATABASE ADVENTUREWORKS

TO DISK= N'C:\AW.bak' <-- is not a backup device

WITH STATS= 5

Msg 3201, Level 16,...

select

datename(mm, SalesDate) as Month,

sum(TotalSale) as TotalSales

from

dbo.SalesOrder

group by

datename(mm, SalesDate)

order by

datepart(mm, SalesDate);

Something...

Unfortunately, sometimes you have to redo your work to get additional information. It happens all the tiome.

😎

unikhath (9/10/2008)

I want to pull data from the database table which has been updated today. For ex: select firstname, lastname from users where updatedate <= GetDate().

This pulls all records from...

AND, I actually have to agree with Gail. If this is strictly for archiving data, the trigger is not the best method.

😎

Sorry to say this, but your explanation doesn't really jive with the code in your trigger from what I see.

As I said earlier, we need to see the DDL for...

Jobs are not interactive processes, but batch processes with no user interface.

😎

No. Neither Full or Differential backups truncate the transaction log. During these backups enough of the log is backed up to provide a consistant backup. Transaction Log...