..... SELECT * FROM dbo.BSGGetReports3(0,@Report_ID)

Is this function supposed to be recursive ?

Interesting .... Thanks for sharing the solution.

You should simply re-run the snapshot agent.

Do *not* mark the subscription for re-initialization.

These errors are raised by the stored procedures on the subscribers. If you are using -skiperrors the agent is supposed to ignore them but you are somehow risking that the...

PuffThePug (11/7/2008)

When setting up a Transactional Replication scenario, does the Rep Agent add columns with data to the tables. I am thinking things like GUIDS used to monitor status of...

And ... Server-level privileges have to be migrated as well

FYI: This operation is deprecated

If the Publication is setup correctly and you run the snapshot agent it should push newly added articles only.

We do this all the time.

Restoring master in a "new" server is tricky ....

Take a look here: http://www.sqlservercentral.com/Forums/Topic490956-357-1.aspx

It has been *my* experience that upper bound memory (max) should be set in these cases.

In addition choosing CPUS per instance is also nice (if you can. This is usually...

Did you updated all the stats with fullscan ?

If after all that you are still getting the same throughput the app and not the server is the likely bottleneck.

If there are other connections on the DB you will be blocked.

Any change from read_only to read_write and viceversa requires exclusive access

you either are the only one connected...

Happy to help

1. PIVOT needs an aggregate function you...

The title of this forum is T-SQL(SS2K5)

you...