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 !

-

If you can, don't shrink the logfile !

Every extend it needs, takes an extra efford of your server.

It only extends if needed, due to transaction load.

It's a good choice...

alter database xx set RECOVERY  SIMPLE .

This way every ended transaction's logspace is immediatly set available again.

Point in time recovery is not possible. you can only restore fullbackups and differentials.

If the sum transactions...

select mycol, case when myrowcountcol > 1 then 'High' 

                          when myrowcountcol < 1 then 'Low' 

                          else 'ONE'

                          end as HL

from (select mycol, count(*) as myrowcountcol

          from ..... 

         group by mycol

        ) A

We use Gert Drapers (SQLDev.Net) XPSMTP and send the queryresult as an attatchment.

you'll need to use sp_changedbowner to change a db's owner.

sa = systemadministrator = omnipotent meaning has all authority to do anything with all db of a serverinstance. If you make...