system-views Image

system-views

question
Grant Fritchey avatar image
Grant Fritchey commented Default

Difference between [sys]-schema views in master and msdb? Closed

msdb master system-views

This question has an accepted answer. Accepted

5 Likes

1Answer

0 Comments

question
Fatherjack avatar image
Fatherjack edited Default

What is the difference between sysobjects and sys.objects

system-views

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
Fatherjack avatar image
Fatherjack edited Default

report against system views

permissions system-views

This question has an accepted answer. Accepted

1 Like

1Answer

0 Comments

question
MileHiger avatar image
MileHiger answered Default

permissions to master database

permissions system-databases system-views

This question has an accepted answer. Accepted

1 Like

3Answers

0 Comments

question
Magnus Ahlkvist avatar image
Magnus Ahlkvist commented Default

find out what table a stored procedure updates,inserts to, modifies

sql-server-2005 system-databases system-views system-stored-proc

0 Likes

2Answers

0 Comments

question
xnl28 avatar image
xnl28 asked Default

sys.sql_expression_dependencies incorrect

sql-server-2008-r2 system-views

1 Like

1Answer

0 Comments

question
Nick Kavadias avatar image
Nick Kavadias edited Default

What causes `system_scans` in sys.dm_db_index_usage_stats to count up?

statistics system-views

This question has an accepted answer. Accepted

5 Likes

1Answer

0 Comments

question
Fatherjack avatar image
Fatherjack asked Default

What is index fragmentation % - actually?

fragmentation system-views

4 Likes

1Answer

0 Comments

question
Dolfb Bosch avatar image
Dolfb Bosch asked Default

When last has a View being executed

system-views

This question has an accepted answer. Accepted

2 Likes

5Answers

0 Comments

question
Ian Roke avatar image
Ian Roke edited Default

system table for Synonyms?

sql-server-2005 system-views

This question has an accepted answer. Accepted

0 Likes

2Answers

0 Comments

question
Fatherjack avatar image
Fatherjack asked Default

Database status = ONLINE or OFFLINE

database-files system-views database-state

This question has an accepted answer. Accepted

2 Likes

2Answers

0 Comments

question
Steve ebald avatar image
Steve ebald asked Default

what system table has key field info

system-views

This question has an accepted answer. Accepted

2 Likes

2Answers

0 Comments

question
Steve Jones - Editor avatar image
Steve Jones - Editor edited Default

getDate() & CURRENT_TIMESTAMP

sql-server-2005 t-sql date-functions system-views

This question has an accepted answer. Accepted

1 Like

2Answers

0 Comments

13 Posts
12 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.