Er, yuk! 

As you're obviously finding out now, SQL 6.5 is a bit of a mongrel.  One major difference from SQL 7/2000 is that all information regarding the quite complicated makeup...

My mistake Robert.... as we're often warned, the question text changed between newsletter (which omitted the Enterprise Manager bit) and what was on this site.  I failed to re-read it.

Ah ha... Enterprise Mismanager!  I was wondering how so many people got the "correct" answer.  

In that case the real correct answer is "ENTERPRISE MANAGER won’t let you put in a...

oops

My version of SQL 2000 does as BOL states... it allows/executes the restore and gives a message "This log file contains records logged before the designated point-in-time. The database is...

Phill,

Some inline views may help simplify it:

select
    Account,
    Address1 = substring(address, 1, delimpos1-1),
    Address2 = substring(address, delimpos1+1, delimpos2-delimpos1-1),
    Address3 = substring(address, delimpos2+1, delimpos3-delimpos2-1),
    Address4 = substring(address, delimpos3+1, delimpos4-delimpos3-1),
    Address5 =...

Terry,

You must always specify an ORDER BY to GUARANTEE that results will be returned in that order.

More often that not, if your data is physically in the order that you...

I think it's just an example.  Phil will be combining results of charindex with other text handling functions (eg LEFT, as shown in his other example).

You can use ::fn_trace_gettable to read trace files and/or load them to SQL tables.  Other undocumented extended stored procedures (eg. xp_dirtree and xp_getfiledetails) can be incorporated to determine the files generated by...

Phil,

Prepare to kick thyself....

it should be: CHARINDEX(';', [address])

crdate gets set when you create or drop/create the procedure.  unfortunately it doesn't get touched when you alter the procedure.  as wz700 points out, schema_ver gets updated on alter... but...

Wow Brian, you're getting to be an old softie.

I've taken advantage of your offer.  Thanks.

Why is Report Designer not a valid choice?  It allows creation and preview of reports.

I don't see why such a query wouldn't work.  The following works fine for me on both SQL 2000 and 7.0.

use pubs

select t.title, a.state

from titles t

inner join authors a on...

Unfortunately the IDENTITY function - which can generate incrementing numbers - only works with a SELECT INTO, not a normal SELECT.  So, to achieve the results you're after you may need...