Skip to Content
0
Former Member
Oct 29, 2019 at 01:52 PM

sp_helpdb fails with Msg 11021

58 Views

Hi.

When trying to run sp_helpdb with arguments, some info are missing and returns "

Msg 11021, Level 16, State 2"

Appreciate any help with this.

1> sp_helpdb master
2> go
name db_size owner dbid created durability status
------ ------------- ----- ---- ------------ ---------- ------------------
master 13,0 MB sa 1 Dec 09, 2009 full mixed log and data

(1 row affected)
Msg 11021, Level 16, State 2:
Server 'FNR', Line 1:
Function STR invoked with wrong number or type of argument(s).
device segment
------ ----------
master default
master logsegment
master system
(return status = 0)


1> select @@version
2> go

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Adaptive Server Enterprise/15.5/EBF 17336 SMP/P/Sun_svr4/OS 5.8/ase155/2391/64-bit/FBO/Tue Nov 10 01:27:55 2009