Your airline carrier could learn something from the Underground train drivers in London. Although there are frequent delays on the Tube, passengers are always informed of the reason for...

You may want to consider a donation scheme to keep the site growing. I'm sure some people would not mind making a small donation every month or year, if...

If you examine the nationality the 100,000 MCDBA's, a lot of them probably live outside the US. I am a South African, living in London, and while the conference...

For many people, a free but flawed product is still better than a perfect but expensive tool...

Is the licence for v3 a per head licence? That can be quite...

No, the cast does not work.

If I move both CASE statements around the UDF into the UDF itself as a IF, I also get incorrect results.

If I try the following I get the expected, correct...

Hi all. Here is the code - it is pretty ugly. I'm still busy optimising it. It won't run, as my boss asked me to change the...

I used to work at a company where we had SQL jobs running all through the night and weekends, usually staging product and price updates to the web site. ...

Thanks for the reply. I took a look at the SP1 fix, but my problem did not meet the requirements for that bug.

I actually did fix the problem by...

The previous posting of restoring a backup should work quite well. Create your template database, back it up and then restore it with a new name when you need...

Did you ever fix this problem? I'm getting the same problem in our new server. I migrated from Windows 2000 Server to Windows 2003 Server. SQL SP3.

In Query analyser, go Tools/Options/Results. Change 'Max chars per column' to 8012.

Large sprocs could be split over multiple rows in syscomments.

The code for stored procedures is kept on the system table syscomments which resides on your database. To be honest, unless you have been using VSS or some scripting...

Some standards we've found useful here:

1.When replacing a stored procedure or function, rename the old version using sp_rename (assists with speedy rollback and version control). Rename using sprocname_WF_20060309_CommentClearquestProject. ...

For simple transfer, DTS is often the best solution but I recommend creating the destination tables first (with primary keys). Don't use the DTS option to delete the contents...