Post reply

Sql Server & MS Access database size

  • March 6, 2012 at 7:16 am

    #391737

    Q#1: How can I find the size of my sql server database?

    Q#2: I have MS Access database of size 80 MB. If I move access db data to sql server, does the data occupy same space in sql server?

  • March 6, 2012 at 7:41 am

    #1455309

    zeeshandar (3/6/2012)

    Q#1: How can I find the size of my sql server database?

    Q#2: I have MS Access database of size 80 MB. If I move access db data to sql server, does the data occupy same space in sql server?

    1:>

    sp_helpdb

    select * from sysfiles

    2:>

    No it will not be the same

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply