Has anyone else noticed this or is it just me?
I have a database that I rename to _Old, then I detach it so I can rename the data & log files. I reattach it, but when I try to find it in master..sysdatabases, it's not listed. I even did a "Select * from sysdatabases" and can't see it.
But it shows up in SSMS no matter how many times I refresh. How weird is this?
Anyone have a clue as to what's going on?
Thanks,
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
I have a database that I rename to _Old, then I detach it so I can rename the data & log files. I reattach it, but when I try to find it in master..sysdatabases, it's not listed. I even did a "Select * from sysdatabases" and can't see it.
But it shows up in SSMS no matter how many times I refresh. How weird is this?
Anyone have a clue as to what's going on?
Thanks,
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
