Here is a script for generating INSERT statements for 1 table. You could modify it for all tables or a subset. I use it when generating a subset of...

If it is inserting, and you want it to stop, I don't think you can avoid a rollback.

If you're lucky , it hasn't been doing inserts the entire 22 hours,...

Or you can use Windows utility "Forfiles". I think the syntax varies depending on the version of windows.

How is the archived data used ?

You can find scripts that will show you the blocking processes. Then identify the primary blocking process. From that point you need to identify what the process is doing, what...

I would also go ahead and use the 2 tables, but make them both temp tables. ie, #ErrorLog & #ErrorLog2

You need to double quote everything because your query is inside a set of quotes. Example:

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'AdventureWorks2008R2 Administrator',

@recipients = 'danw@Adventure-Works.com',

...

What is your select statement ?

What is the insert statement that you have tried, and what is the error ?

You can put your query in sp_send_dbmail.

I do something similar looking for failed job steps. I run the query, and if the count is > 0, I run sp_send_dbmail with...

Here are some ideas.

http://blogs.msdn.com/b/psssql/archive/2009/02/19/how-to-copy-dts-2000-packages-between-servers-and-from-sql-2000-to-sql-2005-and-sql-2008.aspx

I also remember a free tool that migrated them all with only a couple of clicks.

Maybe it was the DTS BAckup tool mentioned here:

http://www.sqldts.com/204.aspx

Do you need DETAILED information ? Maybe LIMITED would be good enough ?

From MSDN:

The DETAILED mode scans all pages and returns all statistics.

The modes are progressively slower from...

Somebody read on the internet that it's good to rebuild indexes, so they created a job to do it ...

It could easily be negatively impacting other processes.

Declare @RecCount int

set @RecCount = (Select count(* ) from table

where conditions x,y,z)

if @RecCount > 0 begin

EXEC msdb.dbo.sp_send_dbmail

end

OnlyOneRJ (8/14/2013)

---

homebrew01 (8/14/2013)

---

Is 3 hour data loss acceptable for the business ? I prefer log backups every 15 or 20 minutes.

I run a server side trace 24/7 on my...

What Data Type does the wizard think that the column is ? I think it should be string (DT_STR) if you are expecting non-numeric data.