It is more of question of what advantages/disadvantages AREAS you are looking for? (i.e. Speed, Maintainability, Architecture and Design etc.)

The discussion "Is dynamic SQL better than Stored Procedures" is as...

According to MS article, default value of the parameter on a parameters screen of Properties of a published report could only be a constant.

1. Search BOL.

2. Kimberly's article is the best. http://msdn.microsoft.com/en-us/library/ms345146.aspx

Kevin,

1. Instance name. Beginning from SQL server 2000, you can run multiple sets of services identifying Microsoft SQL server on the same machine. Microsoft calls such a set an instance....

There is no migration path. It is not a migration, since engine is the same.

All CONFIGURATION changes that you might want to perform are falling into the category of removing...

You started with a question about finding apostrophes in string expressions.

You've got several suggestions. Did you try them?

You continues then with a question about finding apostrpohes in field names. Field...

... checking for error messages in both SQL log and Event log.

Index tuning wizard?

Any related error messages? (It should be in Agent Error log).

When you are saying that it does not work, what do you mean?

Any error messages? Did you try sending a test email?

Did you enable db mail on both servers?

Check MSDTC settings on both computers.

When you are running INSERT from one server to another this is considered as DTC (distributed transactions).

You can use this tool: http://www.microsoft.com/downloads/details.aspx?FamilyID=5e325025-4dcd-4658-a549-1d549ac17644&displaylang=en

According to error message two (Error 1776) you have problems with schema differences on a table 'dbo.1Incaricati'

Check unique indexes on subscriber which were not replicated from publisher.

I would recommend uninstalling and reinstalling Client tools.

BTW, what SP you are running? What is MDAC version?

It could be a MDAC problem and I believe that applying SP upgrading MDAC...

Too common description.

What is DB version on server? What is DB version on client?

What is the location of your EM? (i.e. Server, local computer)

Where is your Query Analyzer is located?

Can...

What's wrong with included samples?

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