SQLRNNR (5/20/2014)

---

Jake Shelton (5/20/2014)

---

Added the Clustered Index to tbl.RegHist (after dropping the non-clustered one of the same name), runtime remains the same.

Attempted to change the datatype for the Chassis column...

Added the Clustered Index to tbl.RegHist (after dropping the non-clustered one of the same name), runtime remains the same.

Attempted to change the datatype for the Chassis column to Varchar(8)...

Msg 5074,...

Again, let me get this straight...

ChrisM@Work (5/19/2014)

---

Investigate all of the tables referenced in this query and list those tables which contain columns [chassis] and [model], making a note of the...

ChrisM@Work (5/19/2014)

---

Jake Shelton (5/19/2014)

---

Grant Fritchey (5/17/2014)

---

SQLRNNR (5/16/2014)

---

Grant Fritchey (5/16/2014)

---

To address the scan, you need to either have a filter of some kind to reduce the amount of data, or fix...

Grant Fritchey (5/17/2014)

---

SQLRNNR (5/16/2014)

---

Grant Fritchey (5/16/2014)

---

To address the scan, you need to either have a filter of some kind to reduce the amount of data, or fix the conversion so...

Grant Fritchey (5/15/2014)

---

The good news is, you have full optimization, so the optimizer didn't time out leaving you with a junk plan. The bad news is, yikes.

I suspect you may...

Everyone,

Have clicked 'Actual Execution Plan' and uploading, along with the newly created indices....

Mods - I KNOW it's an old thread, but I'm sure it's writeable for a reason....

Just to add, after having run DTSRUn with the above switches, you may just see...

Hi Lowell, many thanks for that! I haven't run it yet, but the GUID is actually double or triple that length, I had to shorten it for readability purposes.

Indeed...it does seem like the smartest way is to script out the new sprocs, Restore the db's, drop the newly restored sprocs, and run those scripts.

Thanks for your help Gail....

Effectively, recreate those sprocs, ok.

We have 30+ (user) databases, is there a script out there that can loop through the databases and generate Create Sproc statements for all of them?

I MIGHT have validated against source, not destination, dohh...here is the error output now.

Msg 213, Level 16, State 1, Procedure sp_delete_all_msx_jobs, Line 25

Column name or number of supplied values does...

I've checked, there's no current replication on that box. The script was generated by right click, 'Generate SQL Script'....

Msg 208, Level 16, State 0, Procedure sp_delete_job, Line 95

Invalid object name '#temp_jobs_to_delete'.

Msg 208, Level 16, State 1, Procedure sp_MSupdate_replication_status, Line 34

Invalid object name 'tempdb.dbo.MSreplication_agent_status'.

Msg 208, Level 16, State 0,...

george sibbald (4/10/2014)

---

Jake, the sp_help_revlogin will bring passwords across. straight to 2008. I have done it myself many times.

Perry, master.sys.sql_logins is not available in SQL2000 so Jake will not...