January 11, 2018 at 1:02 pm
The query always returns me an error,
I try with
USE master
USE DBNAME
USE HelloWorld
(I have a database called HelloWorld) :
It always returns me
Msg 2521, Level 16, State 40, Line 3 Could not find database ID 70.
Like there was no database
January 11, 2018 at 1:07 pm
francesco.mantovani - Thursday, January 11, 2018 1:02 PMThe query always returns me an error,I try with
USE master
USE DBNAME
USE HelloWorld
(I have a database called HelloWorld) :It always returns me
Msg 2521, Level 16, State 40, Line 3 Could not find database ID 70.
Like there was no database
That's the error I mentioned in an earlier post - if you look at the script, the database id is hard coded in dm_db_index_physical_stats. Replace 70 with DB_ID()
Sue
January 11, 2018 at 1:32 pm
My apologies ..I tried to edit it but not finding an option anywhere. please replace 70 with ur DB id or NULL or 0 to get the results for all the DB 's . Thank u
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply