How we Resize table,temp table, database and log file size
in SQL Server 2005
Answer / amrish kumar
USE DataBaseName
GO
SELECT name,physical_name,size,max_size
FROM sys.master_files
WHERE database_id = DB_ID('DataBaseName');
go
| Is This Answer Correct ? | 0 Yes | 6 No |
how to insert the values in 5 table at a time Using any single statement ?
6 Answers Infosys, Value Labs,
How many types of the database links?
What is a database in ms sql server?
Can we install sql server 2016 on windows 7?
when inserting to a table how many rows will be effected using triggers
explain different types of jions with examples briefly?
2 Answers Accenture, Excellence, Zensar,
What are the types of backup and tell me the difference between full and differential backup?
What are the different types of backups that exist?
What is the library index called?
What are sql server procedures?
What is a field in a table?
Explain view in sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)