locked
error number -1073548784 RRS feed

  • Question

  •  

    I'm new to SQL... trying to get a maintenance plan to work.  I need to run a daily reindexing of a table.  I have tried to recreate the maintenance plan several times... any ideas anyone?
    Friday, May 30, 2008 12:03 PM

Answers

  • Check whether SQL Server Agent user has permisson on database to execute those commands

     

    Friday, May 30, 2008 1:08 PM

All replies

  • Can you tell what is the exact error you are getting please

     

    Friday, May 30, 2008 12:53 PM
  • This is the error I am getting:

     

    Executing the query "
    ALTER INDEX ALL ON LINKS_SRC1
    REBUILD;
    " failed with the following error: "Cannot find the object "LINKS_SRC1" because it does not exist or you do not have permissions.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

     

    The query I am using for the maintenance plan is:

     

    USE Captavia
    go

    ALTER INDEX ALL ON LINKS_SRC1
    REBUILD;
    go

    Thanks!

     

    Friday, May 30, 2008 1:02 PM
  • Check whether SQL Server Agent user has permisson on database to execute those commands

     

    Friday, May 30, 2008 1:08 PM
  • That was it... I did't check the permission!  Thanks a lot!  Simple...

     

     

    Friday, May 30, 2008 1:18 PM
  • great

    Monday, June 2, 2008 9:29 AM
  • Dinesh,

    I am facing the same problem as rocketman....please suggest me how to check that?

     

    Thanks,

    Raj


    gouthamraj
    Wednesday, June 29, 2011 9:35 PM