So you have mentioned stored procedures prefixed with "sp_". How about if they are prefixed with "sp" only (without underscore)? Are they affected too?

Is there any recommended solution? I mean...

Maybe you can try this:

ALTER AUTHORIZATION ON DATABASE::coda TO sa

Hope helps.

:: Ezz Khayyat

:: Well, the LIMIT clause is really mssing around in SQL Server!

:: But also, you have to consider the IDs...

:: JSBBS

:: It is now recommended to use the TABLE variable, rather than temp tables

:: (see SQL Books Online)

I've just known if...

:: PW

:: Why are you turning NOCOUNT off, when there are statements in there (eg

:: the INSERT INTO) which will generate...