If we shrink the Databse and Files, how much size is
decreased?
Answer / lmr
The primary data file cannot be made smaller than the size
of the primary file in the model database.
for eg. while creating a db having size 10 MB
N GREW 100MB
then max the can be shrunk to 10MB.
| Is This Answer Correct ? | 0 Yes | 0 No |
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
What are the approximate numeric data types?
Is there any difference between the primary key and unique key?
How to Insert multiple rows with a single insert statement?
Differnce between sel server 2000 and 2005
can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?
Difference between aggregate functions of sql?
what is performance tunning in sql server ? explain.
What is The Use Of TIMESTAMP DataType in SQL Server 2005?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
How to Install SQL SERVER 2005 remotely?
What are the 7 disadvantages to a manual system?
Oracle (3253)
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)