The DB is exact copy of source(Query runs without filling tempdb) that gets copied daily morning to destination(Query fills tempdb). So stats, DB settings are same. Coming to server settings...

I looked at estimated execution plan and created the missing index it suggested. But still no luck. Can you tell how can i differentiate query plans.

ok fine. Let me know if any option available.

The upgrade is being done on Publisher database. Though i stopped the disabled the distribution agent and log reader agent the application still shows a message that those tables are...

First subscriber database will be used by HR team and the new subscriber database will be used by Finance team. So 2 different teams will be using the different databases.

So...

I will be using transactional replication since they need up to date.

Here the publisher database is same but the additional new subscriber database is required with different tables replicated from...

sorry mistyped query in forum.

I checked the security and permissions and it works now.

yes i can see the tables under catalog. Just now i gave read permissions and it worked.

Thanks.

So what is the way to find when the databases are last modified in a SQL instance.

Create View as

SELECT dbo.CLBALANCN.COMPANY, dbo.CLBALANCN.ACCOUNT, dbo.CLBALANCN.INCIDENTNO, dbo.CLINS.PLANTYPE AS insurance1FinancialClass,

...

CREATE VIEW permission denied in database 'medical'

ok thank you all.

ok thank you all.

But the client needs inplace upgrade from SQL 2005 to SQL 2012 cluster. What would be the issues if we do inplace upgrade.

Can you suggest me the best autogrowth settings on the tempdb files

Thank you all.