Oops :blush: ... this thread is in the SQL2005 forum ...

the methode I explained is not possible with SQL2000.

So you connect to a sqlserver instance and specify a dbname,.....

with SQL2005 Express Edition, you can "in line" attach a mdf-file only on the local instance !

Attach a database file on connect to a local SQL Server Express instance

...

TommyB has given you the solution.

Afterward you should restart sqlserver "normal".

On the other hand, I wouldn't advise tempdb to reside on Raid5 ! Best is to put is on a...

just put brackets around the columnname ( look at my previous reply 😉 )

maybe this will get you going ..

SELECT CASE t1.[ORDINAL_POSITION] WHEN 1 THEN 'SELECT ' ELSE ' , ' end

+ ' sum( CASE WHEN ' + t1.[COLUMN_NAME] + ' is...

thanks for the missing link notification :blush:

It used to work befor SSC got to this new version.

I'll ask Steve to fix it.:cool:

I got this from last years SQLPass conference:;)

Potential for enormous filesystem cache on 64-bit can create external memory pressure !

Configure OS to favor memory for programs, not filesystem.

In stead of keeping fingers crossed, because it should be possible.

Maybe it's better to just grab a spare DESKTOP, pop in a 500Gb disk and install a w2k3 server on...

Keep in mind logon triggers have only been implemented with SQL2005 as from SP2 and off course they are at instance...

I'd go with GilaMonster's advice.

Keep in mind that when you are going to restore, you can actualy move the log-file to a new location during the restore itself. Nomore hassle...

At next SQLPass, this may be the banner on the backside of the T-shirt:

500000 and growing ! (Update the number active at the time) :w00t::cool::cool::cool:

so your solution would be:

1) correct your /pae and AWE settings.

Only use the /3Gb in boot.ini and do NOT enable AWE in sqlserver

2) I'd...

maybe the better way is to use the INFORMATION_SCHEMA views, but you'll get the idea using :

declare @Tabelname varchar(128)

set @Tabelname = 'T' -- Adjust to filter !!

-- print 'set...

Nice thing, these upgrades, it's a pitty you didn't migrate the forum-reply-counters. So all of a sudden I'm back to 3.:doze:

been there, done that, burned the fingers too

I'm glad you're back on track now.