Thanks for the reply. It is 92% full.

Thanks!

Thanks for the replies! Will that give the user the ability to create stored procedures on other schemas, say dbo?

Thanks again,

DK

Sean,

Thanks for the reply. I decided against going forward with this as every option seemed to involve reinitialization of the subscriber. On top of that Microsoft does not support adding...

Thanks for the replies. I did not have the database in single-user mode, as far as I am aware of. I ended up having to remove the master key...

I think I found it, we used maintenance plans with ssis packages. The package was doing a check to see if the database on this server had the advantage in...

Thanks for the responses.

jasona.work, the reason was 'Log_Backup', so I increased the frequency of log backups. Will repost results.

Thanks again,

DK

Thanks.

Yes, it does.

Thanks.

Maybe I should have included this in the OP, but I am aware that I can do an insert/select to a temp table and then rename, but I am worried...

Thanks.

DK

Thanks for the responses.

Anthony.green, yes, the reports have to be as close to real time as possible at this point. We are going through the process of identifying reports...

Yes, we are only using selects in our reports, but the selects are complex with large predicates, mostly ad-hoc, with wide spread use of CTEs(With;) statements and unions. Yes, we...

Thanks to all, we are organizing a transition from sql server '05 to sql server '12. I am going through maintenance jobs to prepare for the new version. I am...

To answer my own question, yes. Replication is still working.

Thanks,

DK