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

It boots sqlsrvr.exe in the windows priority against other applications. It might get you slightly better performance, but if there are other processes on the box that might need resources,...

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

I've heard good things about Protegrity, but hanve't used it.

http://www.protegrity.com/products1.html

Does it do this if you run it interactively? Can you double click the failed item and get an error?

Most likely it's a data problem. Try changing the first and...

I believe 6.5 only had Std and Enterprise editions. If select @@version doesn't return it, I'd look through the registry keys (HKLM/Software/MS/SQL Server) for it or properties of the server...

Must be some bug somewhere. I'll take a look.

I don't think that you want [] around the filepath do you?

I received this question with supporting documentation about an open case with MS. At the time I needed some questions and posted it ,...

select sum( case when sub2 = 0 then sub1 else sub2 end)

from ...

select max( dt) from mytable

where dt < (select max( dt) from mytable))

I'd contact EMC and work on this.

I haven't worked with many systems at 8GB and none on W2K3, but I pinged a few people that might have. Which HP system is this?

Installing 6.5 on W2K requires some tweaking. Search MS.com for a kb article on this. As far as the restore, I'm not sure. I know there are issues if you...

Profiler is really the only good way of doing this. Be sure that if you remove stuff, you archive it so that if 6 months from now you find out...