ok I changed the authentication mode to windows and logged in using windows authentication but still same error.

and Jill i get no rows if i give your command for...

i am using sa account to do this , doesnt sa account has all the rights n roles?

how and which roles can i explictly grant to sa ?

ok its giving me error on any procedure I add . what could be the reason ? is the syntax wrong ?

exec sp_addextendedproc 'ABCAD', 'FADSFADFASF'

Server: Msg 2714, Level 16, State...

sorry I by mistake put it in the backup group and i was told to move it to the right area so I put it here.

I succeeded in restoring the databases from enterprise backup onto a standard edition.

The problem was a missing hotfix 2050 and once i applied it to the standard database...

ok i got the version and levels separately from the source and target databases and its below :

SELECT SERVERPROPERTY('ProductLevel') level , SERVERPROPERTY('ProductVersion') version

LEVEL VERSION

SP48.00.2039 <<<<<<<<...