Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
1sabine8
Posting Yak Master
130 Posts |
 Posted - 2012-01-23 : 04:55:55
|
| Hi I'd like to know what's the size of a SQL Server 2005 database and what's the limit number of records that it can take.Thank you in advance |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-01-23 : 07:09:53
|
| Take a look at this page: http://msdn.microsoft.com/en-us/library/ms143432(v=sql.90).aspx |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-01-23 : 07:10:30
|
| how long is this piece of string and what colour is it?your question is meaningless, without knowing what your data looks like and what your environment is like?Data lives on pages, pages are a set size and can hold a number of rows depending on how you model your data.....http://msdn.microsoft.com/en-us/library/aa174529(v=sql.80).aspxCharlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
Max number of records and size