and choose a security context to run under impersonation of the login account used to access the target server.

Arshad

If I were you , I would go with option 2 , more so considering scalability etc. .Since the SQL to SQL will have no issues due to backward compatibility...

Thank you Brandie , Jacob , Gail for such useful insights.

Thank you

Arshad

Small correction above .. over 1 million inserts are there for the table I mentioned . 

Thank you

Arshad

But , don't the system objects physically exist in the resource database and only logically are they in each database ? this is what I've been believing in so far...

Hi,
Thanks All for putting info on this .

Gail , aren't the statistics stored in system objects , like sys.sysrscols etc . am I missing something...

Looks like some client-side issue . Irrespective of the status in SSMS I suggest to query from the client and see the response . If it still says that the...

Hi John,
As I knew from my past experience of being part of migration activity for all the databases / apps from one data center to another , I was...

Hi John ,
Thanks so much for the info. I understand that it shouldn't be really worrying as we can update stats after restore as well which I had mentioned. Our management...