IT Nursery
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...
I am using this query to rename the database: ALTER DATABASE BOSEVIKRAM MODIFY NAME =...
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...
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...
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...
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:...
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)....