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...

Are you sure there wasn't something else added to Server A by the PSFT product?

Not so easy since the sysdepends information isn't dependable. I guess you could search out the code for all objects in sysobjects and perform an alter on all of them,...

For the sysadmin, you can run a query on syslogins and check for administration with a function (isadmin(), I think?). Same for dbo, although you'll need to query each sysusers...

That's a tough one. What about putting the SQL Server at their sites and you vpn in to admin it?

Since 65 mimics a v6.5 server, some of the keywords that are used for advanced functionality, like TOP, INSTEAD OF triggers, etc, do not work. If it works for you,...