I'm still having nightmares from trying (and mostly failing) to get SQL...

After contracting as a DBA in UK for nearly ten years I can report that many companies are still using SQL 2000 (and quite a few at SP3! :w00t:) in...

Thanks for the reply! SSRS it is then. 🙂

qh

Looking forward to this; flying over from the UK.

See you there.

qh

Great article, thanks!

qh

Great article, company I contract for are constantly changing the recovery model and shrinking the log then changing the RM back - have presented them with the URL for this,...

Apologies for digging up and old thread 😀 but having the same issue with a Windows 2003 x64 SP2 and SQL 2005 Ent x64 SP4. My Prod server has 32GB...

Very good article, thanks for this. I did Database design on my HND and hated it, no surprise that I failed it and had to retake it before I...

All very good articles, thank you.

Sometimes you *think* you know something but it turns out you were only half right. No harm in keeping the ole grey matter in check...

Good call, I have not seen much discussion on here regarding SQL 2005 SP4, however that may be due to that the initial SP4 only has 3 bug fixes, however...

Very well written article, even someone of 10+ years experience its nice to read something and think, I haven't touched on that area of SQL for a while (or even...

Just thought I'd add my resolution when changing server collation in SQL 2005 (thankfully before any user dbs created) so no hassle in rebuilding the system dbs)

I had window auth,...

Hi,

just to add to this thread, I have recently had the same error message as above, however the problem was caused by the login that ran the SQL Server Agent...

I have an issue where I need physical proof to convince the Development manager about SQL Server 2005 Standard SP2 (yes they are still needing to upgrade to SP3) 64bit...

Hi,

I am looking to monitor sql jobs for our SQL 2000, 2005 and eventually 2008 servers. I am looking at the SQL Management Packs for SQL 2000/2005 for SCOM...