Actually not randomly. It's normally after weekly reboots. This causes the Great Plains DB to be locked to 1 person, so other people get errors.
Sometimes I can just unrestrict access, other times it's grayed out and I have to drop the DB and restart the services to take it out of single user mode.
SQL 2k3.
Anyone ever encounter this glitch?
edit* meant sql 2000, on win server 2k3
Sometimes I can just unrestrict access, other times it's grayed out and I have to drop the DB and restart the services to take it out of single user mode.
SQL 2k3.
Anyone ever encounter this glitch?
edit* meant sql 2000, on win server 2k3
Last edited: