How much of data is it returning? Check the network bandwidth in the Task Manager. Also Is any App Server being used? How is the traffic / response on the...

[font="Courier New"]Thanks Craig.. I think i found the solution soon after posting 🙂 but by using the CROSS APPLY feature. I was trying JOIN etc and they were not allowing...

Check the ownership of the database on the server. May be you restored the db and are trying to set up the replication.

David

The following is what i do usually. Using the "Allow Initialization from Backup" Option. The following methodology is useful if the database size is big. The usual snapshot regenerates copy...

Ok. Here are some links.

How to Perform Required Pre-Replication Setup Tasks

http://technet.microsoft.com/en-us/library/bb693465.aspx

**Hopefully you have not missed on setting the replication text size in the publisher**

Frequently Asked Questions for Replication Administrators

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

http://vyaskn.tripod.com/repl_ques.htm

Best Practices...

Please keep in mind that if something is not mirrored, then it will not be replicated ; Because in the case of a failover / switchover the new Principal cannot...

Try the URL given at the end.

When you try to transfer first time, it will say file(s) absent.

The rss and rdl , cmd, xml files etc will be created...

Does Microsoft support Publisher 2008 and Subscriber 2005?

Was the SQL Server Service restarted? That is a requirement.

I am not 100% sure if this will meet your needs. The following is what i do in my setup.

When the Report URL is clicked, username/password will be prompted as...

Jeff

After looking at the Task Manager (all processes) for multiple servers, i agree with you. There are not too many OS processes running in the servers and 2 GB out...

sturner (7/29/2010)

---

if you restore a database you must reinitialize the mirroring. meaning you'll have to backup the database and restore it to the mirror. The replication can be re-initialized...

Upgrading to SS2008

http://msdn.microsoft.com/en-us/library/bb677622(v=SQL.100).aspx

http://msdn.microsoft.com/en-us/library/ms190775(v=sql.100).aspx

http://msdn.microsoft.com/en-us/library/ms189625(v=sql.100).aspx

HTH

gk-mct

Memory (Figures converted from bytes to MB)

Avbl.bytes 130MB

Cache Bytes 60MB

System Cache Resident bytes : 50MB

SQLServer:Buffer Manager

Buffer cache hit ratio : 99.86

Checkpoint pages/sec : 0.000

Page Reads/sec...

Long running jobs : http://www.sqlservercentral.com/articles/Administration/longrunningjobs/1897/

Identifying Long running SQL Server Agent jobs : http://www.databasejournal.com/features/mssql/article.php/3500276/Identifying-Long-Running-SQL-Server-Agent-Jobs.htm

Track long running queries :

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/30908/