Also remember to script jobs and move there. And change the compatability mode to 90 for all databases in sql 2005 so that you can take the advantage of sql...

No infact when running with bulk logged mode your backup size will be much higher than the size it was when on full recovery mode. You can give a try...

This might help you

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=4811&whichpage=2

If the package has multiple versions you have to specify the version number tooo.

Dual Duo core processors should virtually show as 4 processors which is right. But licensing as mentioned can be done for 2.

Before that run dbcc sqlperf(logspace)  to check the space used by the log files of each database so that you can shrink accordingly.

Can you post this in English please?

You can't use the variables there you have to change it.

If you find hard to use the above query then use SSMS to restore the database and force restore over the new db you have created.

For more then 16GB RAM you have to use /PAE switch and not AWE. The link given below can be more useful.

http://www.sql-server-performance.com/awe_memory.asp

Use this script given below to see if the user has grant option.

select b.name,c.name,

user_name(a.grantee_principal_id) as UserName,a.permission_name,

case a.state

   when 'W' then 'With Grant Option'

   when 'G' then 'Grant'

   When 'D' then 'Deny'

   Else ''

   end as...

Hope this helps you

Declare

@CaseFlag int

SET

@CaseFlag = 2

if

@caseflag = 0 or

Can't this be re-written as

using the in clause

Don't mistake me have you added him in the sysadmin role of sql server or the windows group. Add him in the sysadmin role of sql server.

Case statement has a else clause too. see if you can use the else clausefor that. else one idea is check if @caseflag has a value of 1 or 0...