How can I get a list of settings on my SQL-server - 2005 version ?

Best regards
KSor

What settings? There are a huge amount of settings, ranging from the instance level, through the
database, table and index level (etc). You can read up on things like sp_configure, sys.databases,
sp_indexoption, sp_tableoption, sp_procoption etc. But it is easier to tell you anything concrete if
we know what settings you are looking for.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"KSor" <keld.soerensenDELETETHIS (AT) psa (DOT) dk> wrote

What settings? There are a huge amount of settings, ranging from the instance level, through the
database, table and index level (etc). You can read up on things like sp_configure, sys.databases,
sp_indexoption, sp_tableoption, sp_procoption etc. But it is easier to tell you anything concrete if
we know what settings you are looking for.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"KSor" <keld.soerensenDELETETHIS (AT) psa (DOT) dk> wrote

What settings? There are a huge amount of settings, ranging from the instance level, through the
database, table and index level (etc). You can read up on things like sp_configure, sys.databases,
sp_indexoption, sp_tableoption, sp_procoption etc. But it is easier to tell you anything concrete if
we know what settings you are looking for.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"KSor" <keld.soerensenDELETETHIS (AT) psa (DOT) dk> wrote

What settings? There are a huge amount of settings, ranging from the instance level, through the
database, table and index level (etc). You can read up on things like sp_configure, sys.databases,
sp_indexoption, sp_tableoption, sp_procoption etc. But it is easier to tell you anything concrete if
we know what settings you are looking for.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"KSor" <keld.soerensenDELETETHIS (AT) psa (DOT) dk> wrote

What settings? There are a huge amount of settings, ranging from the instance level, through the
database, table and index level (etc). You can read up on things like sp_configure, sys.databases,
sp_indexoption, sp_tableoption, sp_procoption etc. But it is easier to tell you anything concrete if
we know what settings you are looking for.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"KSor" <keld.soerensenDELETETHIS (AT) psa (DOT) dk> wrote

What settings? There are a huge amount of settings, ranging from the instance level, through the
database, table and index level (etc). You can read up on things like sp_configure, sys.databases,
sp_indexoption, sp_tableoption, sp_procoption etc. But it is easier to tell you anything concrete if
we know what settings you are looking for.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"KSor" <keld.soerensenDELETETHIS (AT) psa (DOT) dk> wrote

What settings? There are a huge amount of settings, ranging from the instance level, through the
database, table and index level (etc). You can read up on things like sp_configure, sys.databases,
sp_indexoption, sp_tableoption, sp_procoption etc. But it is easier to tell you anything concrete if
we know what settings you are looking for.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"KSor" <keld.soerensenDELETETHIS (AT) psa (DOT) dk> wrote

What settings? There are a huge amount of settings, ranging from the instance level, through the
database, table and index level (etc). You can read up on things like sp_configure, sys.databases,
sp_indexoption, sp_tableoption, sp_procoption etc. But it is easier to tell you anything concrete if
we know what settings you are looking for.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"KSor" <keld.soerensenDELETETHIS (AT) psa (DOT) dk> wrote

What settings? There are a huge amount of settings, ranging from the instance level, through the
database, table and index level (etc). You can read up on things like sp_configure, sys.databases,
sp_indexoption, sp_tableoption, sp_procoption etc. But it is easier to tell you anything concrete if
we know what settings you are looking for.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"KSor" <keld.soerensenDELETETHIS (AT) psa (DOT) dk> wrote