system-databases Image

system-databases

question
Jeff Moden avatar image
Jeff Moden commented Default

Missing indexes in sys.sysclsobjs for sql server 2014

sql-server system-databases system-tables

0 Likes

2Answers

1 Comment

question
cornpoppy avatar image
cornpoppy commented Default

when i select from my view in my database is much slower than i select that( database.schema.table) from system databases why ?

database dba system-databases query-plan dba-developer

This question has an accepted answer. Accepted

0 Likes

2Answers

0 Comments

question
morgenweck avatar image
morgenweck answered Default

Setting up a multi institution SAAS system

system-databases architecture design synchronisation best practices

0 Likes

1Answer

2 Comments

question
nidheesh.r.pillai avatar image
nidheesh.r.pillai commented Default

Database 'msdb' cannot be opened due to inaccessible files or insufficient memory or disk space

system-databases msdb sql_

3 Likes

1Answer

1 Comment

question
Grant Fritchey avatar image
Grant Fritchey commented Default

Attached AdventureWorks2012 but master database does not have AdventureWorks2012 objects.

system-databases

This question has an accepted answer. Accepted

0 Likes

1Answer

3 Comments

question
SQLGoooRooo avatar image
SQLGoooRooo commented Default

System Databases are missing!!!!!!

sql-server-2008 sql-server-2008-r2 sql-server system-databases

This question has an accepted answer. Accepted

2 Likes

3Answers

0 Comments

question
Magnus Ahlkvist avatar image
Magnus Ahlkvist commented Default

How to rebuild and restore the master database without a backup file ?

rebuild system-databases master

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
Grant Fritchey avatar image
Grant Fritchey commented Default

Export & remove data then re-access later

database export-data system-databases export data-export

0 Likes

2Answers

2 Comments

question
Grant Fritchey avatar image
Grant Fritchey answered Default

System crash after index rebuild

sql-server-2008-r2 memory system-databases

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
Pete1 avatar image
Pete1 edited Default

In a SQL 2008 R2 SP2 cluster, does mssqlresouce database need to be in same location as master database (on shared storage)?

sql-server-2008-r2 cluster system-databases

This question has an accepted answer. Accepted

1 Like

2Answers

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
Blackhawk-17 avatar image
Blackhawk-17 commented Default

Move tempdb

sql-server-2005 tempdb system-databases

7 Likes

5Answers

1 Comment

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
mariolottering avatar image
mariolottering answered Default

Sql server system command location

system-databases

1 Like

2Answers

1 Comment

question
mickyd avatar image
mickyd asked Default

help - problems with Model database

system-databases

1 Like

1Answer

0 Comments

26 Posts
26 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.