Stack Overflow
Stack Overflow

Questions tagged [system-databases]

12 questions
20
votes
3 answers

sql view server state permission was denied

I just installed SQL server 2014 however, I have a problem creating the database or even view properties. I get "VIEW SERVER STATE permission was denied on the object 'server', database 'master'. Microsoft Server, Error:300" I cannot alter my server…
Mindan
  • 979
  • 6
  • 17
  • 37
6
votes
1 answer

Cannot connect to Sql Server database: non-system databases are not shown

I'm trying to connect to SQL Server 2008 express database from Visual Studio 2010 using data connection wizard. I choose new connection -> MS Sql Server then I choose the only available server name (PAVEL-PC\SQLEXPRESS). The problem is i cannot see…
Pavel Murygin
  • 2,242
  • 2
  • 18
  • 26
6
votes
3 answers

Is it possible to query the system databases in SQL server without using the names?

When doing a query over several databases in SQL server (2005+) I find it sometimes necesary to exclude the system database (master, model, tempdb, msdb and distribution) Is there any OTHER way to filter these besides where name not in (''master',…
edosoft
  • 17,121
  • 25
  • 77
  • 111
1
vote
1 answer

write a json into the databricks data system

I am trying to write a json file into the data storage system from Databricks by using open('/dbfs/mypath/test.json', 'wb').write(files) I am getting the following error: FileNotFoundError: [Errno 2] No such file or directory:…
meuto
  • 11
  • 4
1
vote
2 answers

What column from master.dbo.sysprocesses is unique for the session?

I'm creating SQL mechanism (in MSSQL 2005) which allows only one user at time set the field in certain table. If this field is set, no one else can clear it (set to NULL). If not, this field is set to something unique for the user's session. As a…
user532231
1
vote
1 answer

How to open a EVERNOTE file extension "*.exb"?

I have evernote.com app running on my machine ---- they store the notes in my local machine unbder a database with extension "*.exb" How can I open that database file with that extension .EXB? Any help or any software that can do this? Thanks
joao
  • 11
  • 1
  • 3
1
vote
1 answer

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

I am facing this issue at one of my clients system. When we are connecting to to SQL server 2008 DB engine through SSMS, I am getting the error Database 'msdb' cannot be opened due to inaccessible files or insufficient memory or disk space. See…
Johnson T A
  • 1,274
  • 1
  • 9
  • 6
1
vote
1 answer

Oracle SQL Retrieve Data From End of Month - 16th And 15th - 1st

Alright so I am trying to retrieve data a field we will call DATE_OF_ENTRY and the field is like this. Example DATE_OF_ENTRY Data 28-NOV-15 So I need to use this field in a script that will be running twice a month to pull certain records.…
smurfguy
  • 45
  • 1
  • 6
1
vote
2 answers

How to deal with '#mysql50#.cache' database?

I found '#mysql50#.cache' database on my mysql. Is this something standard? I can't select this database and look what is inside it because of it's name. Can I drop it?
Dims
  • 47,675
  • 117
  • 331
  • 600
1
vote
1 answer

What does the suffix of a temporary table's name mean?

If you expand the tempdb node and go to Temporary Tables, you will notice the name of the temporary tables have "______XXXXX" appended. Where does that part refer to?Is it the memory place where the temporary table is created? Thank you
user2155565
  • 317
  • 3
  • 5
  • 11
0
votes
1 answer

How to hide other databases from User in Azure SQL Database?

I am using SQL Server Management Studio v17.9.1. I followed guide of this post to use below command but failed with error. REVOKE VIEW ANY DATABASE FROM PUBLIC Securable class 'server' not supported in this version of SQL Server. I tried below…
DaiKeung
  • 1,077
  • 1
  • 19
  • 38
0
votes
1 answer

System database Log backup and recovery model

I am very new to sql server, does anyone know what kind of recovery model for each system databases. I don't know if I should all make it to simple or full in my databases. Because if the database is in full so I need to create a log backup for…
bobtheguy
  • 33
  • 1
  • 8