Truncating tables is out of the question as of now I think.

So what I did was (just for 1 DB), I generated the script from the Source and executed...

My apologies, the source server is running on 2008R2 and the destination server is on 2014

Guys I do appreciate you telling me that this is not a good practice and I do agree but this is what I was asked to do. And before we...

Chitown (9/8/2016)

---

Expert, I am working on scheduling a job which runs every 10 minutes and kill any active session (which is active for more than 10 minutes) from a specific...

Thanks Phil but this question is for people who are not that busy so they can take their time and look at the code? If my question isn't clear then...

That query worked fine. That user was looking in the wrong server. Don't you just love that?:-)

Michael L John (9/6/2016)

---

Chitown (9/6/2016)

---

All, I granted user to see all SPs in all DBs but he is not able to see any. Am I missing any steps?

This is what...

Yes, we do take full backups for dev servers every week and full, dif and tlog for Prod. We also have 6 months of backups for prod in place just...

We are going to upgrade it next week but developers need the data now to test. I am sure that's not new.

Thanks!

Thanks! Didn't think about that. Its running now.

Thanks for the reply. I appreciate that.

When I run the select * from the table, it returns 100K records in 6 minutes. I deleted top 10 records and it took almost 50 seconds (5 seconds per...

I get this Msg 208, Level 16, State 1, Line 1

Invalid...

There was another file .ndf close to 78 Gb in size which I completely forgot about. Didn't even notice it.

The validation report didn't come clean. There are some network related issues we are experiencing. For time being, I have deleted Always ON. (T logs backup are in place every...