Select SQL Server database size
how can i query my sql server to only get the size of database? I used this : use “MY_DB” exec sp_spaceused I … Read more
sql-server-2008-r2
Error on renaming database in SQL Server 2008 R2
I am using this query to rename the database: ALTER DATABASE BOSEVIKRAM MODIFY NAME = [BOSEVIKRAM_Deleted] But it shows an error when excuting: … Read more
How to check date of last change in stored procedure or function in SQL server
I need to check when function was changed last time. I know how to check creation date (it is in function properties window … Read more
CREATE TABLE IF NOT EXISTS equivalent in SQL Server [duplicate]
This question already has answers here: Check if table exists in SQL Server (29 answers) Closed 2 years ago. CREATE TABLE IF NOT … Read more
Exit single-user mode
Currently, my database is in Single User mode. When I try to expand me database, I get an error: The database ‘my_db’ is … Read more
Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
I have a development database that re-deploy frequently from a Visual Studio Database project (via a TFS Auto Build). Sometimes when I run … Read more
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated
I have many users on my web site (20000-60000 per day), which is a download site for mobile files. I have remote access … Read more