Post reply

sp_helpdb and sysdatabases not in sync?

  • October 28, 2010 at 1:18 am

    #388111

    Hallo gents

    I've posted the same question in 2000's adminstration forum but it seems that no one is that interested. I am re-posting it here to see if someone can put some thoughts on it.

    I've recently moved master db's data and log files to new location and today I had a check at the outcome.

    When I use "sp_helpdb master", it returns the new file location while I send a query to master.dbo.sysdatabases, it gives back still the old location.

    Is there a way to sync master.dbo.sysdatabases to the new location then?

    Thanks!

    Bazinga!

  • October 28, 2010 at 11:43 pm

    #1243988

    Did a restart of the SQL Server service help?

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • October 29, 2010 at 2:38 am

    #1244016

    Adiga (10/28/2010)

    Did a restart of the SQL Server service help?

    Thanks for providing this idea, but unfortunately it doesn't work.

    Bazinga!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply