Also in Visual Basic...

Don't know why it says datatype and not function though...

Don't shoot - I'm only the messenger!

Here's something my googling fished out...

Conversion of "NOW()" Access datatype in SQL Server 2000 datatype - GETDATE()

Yes Amit - this is true!

I just don't know of people who actually change the extensions preferring to go with the SQL Server defaults!

Remi - I found that if you go to the Results tab instead and select "Tab Delimited" in the Results output format then you get your wish ...query & results...

Thanks Noel!

It's amazing how one post spawns another...no end to the invaluable information on this site!

My question too....you didn't mean grid right ?!

Et Voila! Thanks a million Noel - Ron!

Remi - You're too modest!

ps:I wonder how that darn thing got checked in the first place - I'm the only one in the...

What would you get if you ran:

SELECT DATABASEPROPERTYEX(N'DBName', N'RECOVERY')

and

SELECT DATABASEPROPERTY(N'DBName', N'RECOVERY')

in Query Analyzer ?

Maybe therein lies the key to the solution - the fact that it's running a function "databasepropertyex" on something that still recognizes only the old (sql 7.0) function "databaseproperty"....?!?!

If you want to change the properties at least you can do so using t-sql via Query Analyzer - & view them using sp_dboption.

I guess what I'm trying to...

Chris - wouldn't there be only one .mdf in the primary filegroup - I thought all other datafiles created get the default .ndf extension ?!?!?!?!

Could you explain a little more ?!

For instance are Detail1 & Detail2 part of a single ID?!

Would there always be only 2 details associated with each ID ?

How...

What if you tried using

exec sp_dboption 'dbname' in Query Analyzer ??

You can attach a single file using:

exec sp_attach_single_file_db @dbname = 'dbname',

@physname = 'C:\Program Files\Microsoft SQL Server\Data\xxxData.mdf'