Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of using sql server over ms access
or why should one use sql instead of ms access
- 2 Answers
- 13712 Views
- CMS, Impetus, I also Faced
- E-Mail Answers
Answer Posted / ramakrishna
Some SQL Server 2000 and Access 2000 products limits:
Feature SQL Server 2000 Access 2000
database size 1,048,516 TB 2 GB plus
linked tables size
objects in a database 2,147,483,647 32,768
user name length 128 20
password length 128 14
table name length 128 64
column name length 128 64
index name length 128 64
Number of concurrent users limited 255
columns per table 1024 255
table size limited 1 GB
number of indexes in a table 250 32
number of columns in an index 16 10
bytes per row 8060 2000
number of tables in a query 256 32
columns per SELECT statement 4096 255
nested subqueries 32 50
number of enforced relationships 253 32
| Is This Answer Correct ? | 24 Yes | 6 No |
Post New Answer View All Answers
what are the three command line utilities and what are their primary functions?
How to delete database objects with "drop" statements in ms sql server?
what are candidate key, alternate key and composite key? : Sql server database administration
What is database white box testing?
Explain the xml support sql server extends?
What is the openxml statement in sql server?
Can binary strings be converted into numeric or float data types?
What is a fill factor?
Which are the important points to note when multilanguage data is stored in a table?
How can you check the version of sql server?
Can group by and orderby be used together?
How to create a user to access a database in ms sql server using "create user" statements?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
what is the system function to get current user's user id? : Sql server database administration
Explain DBCC?
