Recent content by cglaves

If you are using SQL Enterprise Manager to do editing/ design, I find its no problem at all to add while online. All existing rows wil have a <null> value for thenew column even if you specify a default value, so you might have to do a quick update.

In a query like: select * from dbo.sysobjects where id = object_id(N'[dbo].[Users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1 what the heck is the N before the string '[dbo].[Users]'?

Thanks Everyone! I tried to find a paper like this with some links hopefully and came up empty handed, thanks vidru! And Wallie12 appreciate the offer to have a look, thanks all Chris

I am looking more for the fixes to the RDC - so the SP for CR8 developer - altho I am sure there are more fixes I am gonna find I need fixed as time passes. Chris

Does anyone have the last SP or update for CR8.0 so i can update my re-install. I cant find my backup and BO refuses to give it to me as its a non-supported product now. Any FTP or HTTP url would be great for download - willing to pay for a CD via mail also. Thanks Chris

I have installed phpMyAdmin and all queries by default are 'SELECT * FROM `WHATEVER` WHERE 1&quot; What does the &quot;WHERE 1&quot; portion mean and what is it doing? I have searched the MYSQL manual and cant find an explanation, if you know where it is please tell. Thanks

Does anyone know where I can get a component or code to have something like this: http://www.glaves.org/chris/vb/dir_check.JPG Thanks Chris

My IDE setup is IDE1 Master = Hard drive IDE1 Slave = Generic CD-ROM IDE2 master = HP CD Writer 9300i Mandrake mounted the harddrive as dev/hda, the generic cd drive as /dev/hdb and the HP drive as /dev/scd0 - shouldn't the HP drive have been /dev/hdc? Does Linux recognize cd writers as SCSI...