sql-server-2008-r2 Archives

Programming, sql

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

Programming, sql

IT Nursery

I am using this query to rename the database: ALTER DATABASE BOSEVIKRAM MODIFY NAME =...

Programming, sql-server-2008

IT Nursery

I need to check when function was changed last time. I know how to check creation date (it is in function properties window ...

This question already has answers here: Check if table exists in SQL Server (29 answers) Closed 2 years ago. CREATE TABLE IF NOT ...

Currently, my database is in Single User mode. When I try to expand me database, I get an error: The database ‘my_db’ is ...

I have a development database that re-deploy frequently from a Visual Studio Database project (via a TFS Auto Build). Sometimes when I run ...

I have many users on my web site (20000-60000 per day), which is a download site for mobile files. I have remote access ...

Important Tag

Search for:

INSTALL_FAILED_DUPLICATE_PERMISSION… C2D_MESSAGE June 4, 2022

How to sort by meta value? June 4, 2022

WPF text Wrap vs WrapWithOverflow June 4, 2022

How to retrieve the list of all posts ever published via the feed? June 4, 2022

how to use javascript Object.defineProperty June 4, 2022