Wow, quite a configuration. I don't know that there is a definitive answer to your question until you talk to your vendors in all cases. However, I can say that...

The permissions you gave look fine and that is probably what I would have done. If I could though I would try to get more specific to see what he...

Thanks to all for the great comments on this. SQLBill brings a great point with the clustering issue and my configuration falls into that realm. Still not sure whether I...

This looks like a pretty good hit from the MS site however, it is not a perfect match. It appears that this workaround may help though.

http://support.microsoft.com/default.aspx?scid=kb;en-us;815008

I will be interested...

That is the only way that I know to change the settings for the server. Not entirely positive but I believe any database created prior to the rebuild of the...

Did you add the 3G switch in the boot.ini? Once you set that and reboot you should see the memory that SQL Server allocates increase.

Hope this helps.

David

Is there an index forcing a sort on the data? That is the only thing that I can think of.

David

I am assuming that you want to change collations in your migration. If so, then yes it is possible if you are running SQL Server 2000. Not sure off the...

I should have stated in my first post that I am openly opposed to rebooting my SQL Servers. I am just looking for more weight to my arguments. Thanks.

David

Did you try opening it up from another computer (i.e. another Client Tools installation)? If so, how are your msdb backups? I can't think of anything other than a restore...

My GUESS is that the login that owns the object is no longer the owner of the database. Being that it is no longer the owner of the DB, the...

Decent Q&A is given at the following link (may be information here as well)

http://www.sql-server-performance.com/q&a38.asp

You may also want to have the Server Engineer check the stripe size and make sure that...

Definitely do the backups, save a copy of all the DTS packages, script out the jobs and the logins with passwords (Steve Jones has an article on the site for...

Frank,

I can only speak for myself and I would say I could be looking for both. There are some times when it would not be fair to bring along an...

I would also agree on the relocation and the travel to the site for the interview. If a phone interview went well and they felt there was a strong potential...