locked
could not find the stored procedure dbo.pro_logchange RRS feed

  • Question

  • W

    when I adding the content database to webapplication in sharepoint 2010 I got this error

    could not find the stored procedure dbo.pro_logchange.

    any idea ?


    Think More..Do More..
    Wednesday, October 13, 2010 9:27 AM

Answers

  • Hi KSDN,

     

    I have  resolved this issue by giving the command

    stsadm -o addcontentdb -url http://myserver/Mysite1 -databasename ContentDBMigrate -databaseserver myserver/SQLInstance.

     

    previously i supplied the database name only without databaseserver parameter.


    Think More..Do More..
    Thursday, October 14, 2010 12:54 PM

All replies

  • Using SQL Server Management Studio, did you check if this Stored Procedure is present in your environment?

    If it is present and still you get same problem then there must be problem with Access Permissions.


    Thanks & Regards,
    Kamlesh | Blog | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, October 13, 2010 9:35 AM
  • Hi KSDN,

     

    I have  resolved this issue by giving the command

    stsadm -o addcontentdb -url http://myserver/Mysite1 -databasename ContentDBMigrate -databaseserver myserver/SQLInstance.

     

    previously i supplied the database name only without databaseserver parameter.


    Think More..Do More..
    Thursday, October 14, 2010 12:54 PM