Much much better. Many thanks

Changed the following entry in reportserver.config file for csv:

---

--- ...

It turned out to be an XML setting for us. We configured this:

Changed the following entry in reportserver.config file for csv:

...

Indexing temp tables seems to be an unprofitable experience. Even if you can create the index, getting SQL to use it makes it not worthwhile.

Using the Temp db is...

I took into consideration the update stats and renaming...thanks...and ended up with essentially the code below that seemed to work well enough though in the middle of the running the...

BUMP ....same issue with me.... anyone else seen this?

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

That is the link to the lowdown on how and why and when things expire in Replication and worth reading; however, I am not sure how expireration...

I wanna bump this thread back up to ask that those several who said they had or are in the process of moving to the EMC (which we are now...

I am both thankful and humbled.  Thank you guys so much. 

I toned this down from sending an email to just grabbing the one column (email address) and populating a table to get to the core of the problem.

I took your...

.NET tends to blow its processes after a certain time of inactivity...this is a built in security function from what i understand and is perfectly normal behavior...

I have used that method too.  Can vouch for the Restore WITH MOVE option after Repl is down.

In a nutshell, it is pretty straight forward.  I have done three dozen at least.

Here are a few tips:

Make sure, 3 times over, your build version is exactly the same...

I think I would build the restore in a Job, and have the User file call the job.  I (DBA) would want email notification or paged or text'd.  The job...

Awesome sproc.  Fits the bill PERFECT!  Anyone that ever gets in this position needs that animal.

THANKS!

Studdy