Re: MS03-031 and 818806

From: mike singer (nospam_zookeeper_at_wwwhr.com)
Date: 07/28/03 

Date: Mon, 28 Jul 2003 14:41:27 -0400

I have the same error

I took a looke at the .sql files that were stored as part of the package
using winrar and found this snipped of code.

if object_id('sp_setuserbylogin','X') IS NOT NULL
 exec sp_dropextendedproc 'sp_setuserbylogin'
execute sp_addextendedproc 'sp_setuserbylogin','(server internal)'
go
grant execute on sp_setuserbylogin to public
go
exec sp_MS_marksystemobject 'sp_setuserbylogin'
go

After I ran that myself in master, the problem went away. I'm not sure why
it didn't run during the install which seemed to go fine.

"Chris Wood" <chris.wood@gov.ab.ca> wrote in message
news:uc78PfSVDHA.1812@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> Looking at 818806 under More Information, it seems to imply that if you
will
> no longer be able to look at Backup/Restore info, on the updated server,
> from another SQL2000 server that has not been updated. It appears that
> console.exe is not a SQL client executable? It this all true?
>
> Thanks
>
> Chris Wood
> Alberta Department of Energy
> CANADA
>
>

Relevant Pages

  • Re: exec() gives output??
    ... > I'd like to execute a command on the server ... > particular command takes a long time to execute, ... A successful call to exec() replaces the Perl script with whatever execis ...
    (comp.lang.perl.misc)
  • Re: BUILTINAdministrators Account!!!!!
    ... You can execute the following in Query Analyzer: ... the group is a member of the sysadmins sql ... EXEC sp_addsrvrolemember 'BUILTIN\Administrators', ... >> We've removed the builtin group from all our production servers without any issues and as referred ensure your login or referred logins has required privileges in order to hand SQL Server. ...
    (microsoft.public.sqlserver.security)
  • RE: An insert exec statement cannot be nested. Pls HELP.
    ... Before we can use SELECT * FROM OPENQUERY(LOCALSERVER, 'EXEC SP....'), ... Do we put these 3 lines in the stored proc that is running the SELECT ... Or do we just execute the 3 lines manually in query ... server LOCALSERVER? ...
    (microsoft.public.sqlserver.programming)
  • Re: "Linked Table" from a .txt file in SQL Server?
    ... Something similar would be to create a linked server to ... EXEC sp_tables_ex 'TextLinkServer' ... table_name listed when you execute sp_tables_ex which is the ... >on SQL Server. ...
    (microsoft.public.sqlserver.odbc)
  • Re: SQLPLUS fails when there is an extra line in the sql ?
    ... Usually I am using this command to access a databae to execute a ... "deploy.sql" that invokes another hundreds sql files, ...     set sqlblanklines on ...
    (comp.databases.oracle.misc)