When you say the job window shows step id completely out of order, is this the history window? Also, when you create a job, you can specify it to start...

This forum is for assistance to others and we appreciate everyone remaining poite and professional towards one another.

The comments above from Mr. Celko are not appropriate nor necessary to...

Good luck. Be sure to visit here for help

http://www.sqlservercentral.com/columnists/sjones/killthattarget.asp

http://www.sqlservercentral.com/columnists/sjones/batching.asp

Good catch, administration is a pain. We typically setup servers into 3 groups. First group is lower impact, less people where we test patches and hotfixes. Sometimes we could script...

You can run Profiler to see what the most common SQL is. Make notes and keep track of what tables/fields are used for. Be sure that the db is being...

I have been involved in two cases where the cert mattered. One, I applied for a position with JD Edwards. The ad stated that MCDBA required and pretty much every...

Check your connection settings. Might be different in ISQL from defaults. Are you sure the data sets are the same? Default db, etc. the same?

Wow, that's some code

Haven't read all through it, but the left joins always make me worry about non-matches. That could be the issue....

Generate the scripts for replication and run them on the next server.

I did this for JD Edwards, about a hundred servers, thousands of databases. We have Patrol (BMC) for performance monitoring, but only on select servers. The big issue there was...

Definitely a bug, but interesting in the way the type conversion works well for 10 9s and 8 9s, but not 9 9s.

What indexes are on the table? How many rows? Are you sure statistics are up to date?

Can you create a new db, detach it, and then attach it back right away? Almost seems like something's wrong with your install. Are the mdf/ldf from the same version...