Folks acting like Sufian has been acting should probably be ignored. I've tried in two threads to help him understand the philosophy of the forums, one of helping each other...

Yup, when you start picking out favorites there is bound to be some hurt feelings. Some folks might also be discouraged because they'll feel like their contributions aren't being recognized...

SQLServerCentral.com has this feature called Question of the Day. If you are interested in testing people's knowledge, why not submit a question or two to that? They are always looking...

True, but the leaks in SQL 2000 were in the RTM. They fixed it in SP1 and we're up to SP4 now. While SP4 had its own issues with AWE...

I don't think I've seen anything indicating for sure there are memory leaks in the sp_OA* extended stored procedures. However, since they serve the purpose of instantiating COM objects in...

Sufian,

So what you're saying is you solved the problem by directly updating the system tables, something that is not recommended and not supported. Most of us are wary to give...

If you solved the problem, great, post the solution. Taunting, which you're doing, is not acceptable here.

Whoa. No Domain Admin privs. That's not necessary. And it's a bad security practice. Nothing should run as Domain Admin unless it's absolutely impossible to avoid.

If the job is owned...

How large is the log file for your tempdb? I'm assuming 500 MB is both data and log files totaled up. What are the settings on the log file and...

UDFs in SQL Server 2005 can be CLR. Whoa to us DBAs.

Outside of xprocs and rewriting the functionality, you can always call a...

If you have that discrepancy in your BOL, you should go ahead and grab the latest version of BOL:

SQL Server 2000 Books Online January 2004 Update

I'm not sure as to the cause of the every 5 minutes, but if you're already using XPSMTP, with a little more work, you can use it in your SQL...

Once you get everything converted, stand down the old machine. The safest mechanism to rename a machine with respect to the domain is:

1) Move system into a workgroup. Reboot.

2) Rename...

Ah. I got there. This is the same question asked by the same guy. He's correct, with DBCC LOGINFO() you can see which logfile is in use. Of course, it's...

Hrm. It works for me. I've removed the target that causes it to open in a new window. Maybe that was the cause. Here is the direct URL (not link...