Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SP_CONFIGURE doesnt return expected results...

Author  Topic 

SQLServerDBA_Dan
Aged Yak Warrior

752 Posts

Posted - 2001-05-02 : 09:20:51
When I log in as SA and run SP_CONFIGURE from one of our servers it only returns a few lines. Am I missing something??

example:

name minimum maximum config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
allow updates 0 1 0 0
default language 0 9999 0 0
language in cache 3 100 3 3
max text repl size (B) 0 2147483647 65536 65536
nested triggers 0 1 1 1
remote access 0 1 1 1
remote login timeout (s) 0 2147483647 5 5
remote proc trans 0 1 0 0
remote query timeout (s) 0 2147483647 0 0
show advanced options 0 1 0 0
user options 0 4095 0 0

Daniel
SQL Server DBA
   

- Advertisement -