Would you mind testing what happens when you make it 8Gb or even 12Gb in total ?

if it finds VS2005 installed, it can add the components for SSIS (format dts), reporting server apps and the olap dev stuff.

Else it installs it all if you choose so.

another  wild guess : how big is your pageing file(s) ?

Is your /3gb /pae in the first settingsline of your boot.ini

Did doublecheck that this is the active line and that your server is started with these settings !

Did you try seting MIN server memory as well as Max server memory to 6G ?

and then stop/start the sqlserver ?

jut to add ...

when you build your query in Query Analyser, you can check out the execution plan. (exstimated /executed)

(Ctrl+L or Query/display exstimated  execution plan)

(Ctrl+K or Query/Show execution plan)

This option...

on your installation disk, there's a template.ini file which explains all the parameters and has a couple of examples.

Yes you can add the parameters as you expected, but you'll also...

you may want to try ...

select 'exec sp_addlogin ['

+ name

+ '],'

, password

, ', @encryptopt=skip_encryption'

from master..sysxlogins

run it on your sql2000

run the result on your sql2005

Be suspicious and TEST it !

No.

If you are authorized to be sysadm, you're internaly switched to sa.

sa has dbo-authority for the whole of the server/instance.

Did you try ...

ALTER SCHEMA system_function_schema TRANSFER dbo.fn_DateTime24;

- someone didn't pay attention when creating/altering the table.

- Latin_General_CI_AS is a "new" sqlserver2005 collation. This should have some advantages for NVarchar.

are you looking for e.g.

Me

.myrelationddl.SelectedValue.ToString

just to add to Balmukund Lakhani 's replies :

- check you have installed SQL2000 Enterprise Edition !

-