I will test if retry attempts will work in this situation

Tara,

this is a great question.

Microsoft Website says about SQL Server 2005:

A SQL Server instance can only run one instance of a job at a time. If a job has started...

This is correct. That is why I did not compose the script myself because we don't know this specific database design.

Did you try to convert the char, varchar and text...

I would do this:

1. Write a statement to change the collation for a single column (Alter Table...)

2. Write a statement to identify such columns in sys.columns or INFORMATION_SCHEMA.COLUMNS like:

select TABLE_NAME,COLUMN_NAME...

Yes, the Merge and Distribution agent run on the Subscriber with the Pull subscription

http://msdn.microsoft.com/en-us/library/ms151225.aspx

I guess you don't have Merge agent because you specified Snapshot replication. Did you when answering the...

Adam,

The solution is to filter by Database ID.

In the past I did not have luck with Database Name and always used Database ID for Profiler. Today I tried to...

Hi,

This error message says that the process can not connect tothe distributor. Where is your distributer? Is it on the same machine as the publisher?

The reason not to provide the entie solution is that each situation is different and the person who asks the question can not really capture all aspects of their environment...

Rob,

Thanks for sharing with us. I use not only Excel but Word and MS ACCESS automation too. I will get this book.

Stupid question: did you check the ReportServer service is started in Services applet? The display name for the service is

SQL Server Reporting Services (MSSQLSERVER)

This is what your error message...

This exception looks like the one from the front end.

Did you check the ReportServer log as I described? There should be messages on the startup. Also next to it there...

When you try to append rows and have only 1 row transfered, what are the messages? In the window that shows completed export tasks, it show say "N rows transfered"...

Then just re-run the job that sends emails.

BOL says:

"If number_files is specified as 'default', fn_trace_gettable reads all rollover files until it reaches the end of the trace. fn_trace_gettable returns a table with all the columns valid for...

I just tested and querying log.trc returns 122 rows on my computer, I have 5 files today starting with log_833.trc. Querying log_833.trc returns 122 rows too, querying log_834.trc returns 99...