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.

just a wild guess, but did you remove builtin\administrators and forgot to give login auth to the cluster service account ?

tell him to use Visual Studio , create a new SSIS project and use the migration wizard for DTS 2000. (he must be able to get to the SQL2000 package...

can you script and post your "create linked server" DDL (and the details) ?