how can i query my sql server to only get the size of database? I used this : use “MY_DB” exec sp_spaceused I got this : database_name database_size unallocated space My_DB 17899.13 MB 5309.39 MB It returns me several column that i don’t need, maybe there is a trick to select database_size column from this … Read more
I am using this query to rename the database: ALTER DATABASE BOSEVIKRAM MODIFY NAME = [BOSEVIKRAM_Deleted] But it shows an error when excuting: Msg 5030, Level 16, State 2, Line 1 The database could not be exclusively locked to perform the operation. Is anything wrong with my query? 11 Answers 11
I need to check when function was changed last time. I know how to check creation date (it is in function properties window in SQL Server Management Studio). I found that in SQL Server 2000 it wasn’t possible to check modify date ( look at this post: Is it possible to determine when a stored … Read more
This question already has answers here: Check if table exists in SQL Server (29 answers) Closed 2 years ago. CREATE TABLE IF NOT EXISTS works on mysql but fails with SQL Server 2008 R2. What is the equivalent syntax? 1 Answer 1
Currently, my database is in Single User mode. When I try to expand me database, I get an error: The database ‘my_db’ is not accessible.(ObjectExplorer) Also, when I try to delete the database, I get the error: Changes to the state or options of database ‘my_db’ cannot be made at this time. The database is … Read more
I have a development database that re-deploy frequently from a Visual Studio Database project (via a TFS Auto Build). Sometimes when I run my build I get this error: ALTER DATABASE failed because a lock could not be placed on database ‘MyDB’. Try again later. ALTER DATABASE statement failed. Cannot drop database “MyDB” because it … Read more
I have many users on my web site (20000-60000 per day), which is a download site for mobile files. I have remote access to my server (windows server 2008-R2). I’ve received “Server is unavailable” errors before, but am now seeing a connection timeout error. I’m not familiar with this – why does it occur and … Read more
