Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to run a local copy of SQL server? 1
- Thread starter sjh
- Start date
-
1
- #2
nigelrivett
IS-IT--Management
Yes you can install the personal or developer edition on non-server o/s.
Developer would be best.
You can also downl;oad and install msde free of charge but you don't get the client utilities.
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Developer would be best.
You can also downl;oad and install msde free of charge but you don't get the client utilities.
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
- Thread starter
- #3
nigelrivett
IS-IT--Management
If you want to use enterprise manager, query analyser, ... they are part of client utilities.
They will get installe d with the developer edition. MSDE is the only pc edition that doesn't include them.
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
They will get installe d with the developer edition. MSDE is the only pc edition that doesn't include them.
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
- Thread starter
- #5
I need to test my application with Windows Authentication mode, so does that mean that I need Enterprise Manager??
I looked for the Developer edition, but couldn't find it. They only have MSDE or 120-day trial version.
Thanks again!
I looked for the Developer edition, but couldn't find it. They only have MSDE or 120-day trial version.
Thanks again!
nigelrivett
IS-IT--Management
You don't need enterprise manager for anything but query analyser is handy. You would have to access MSDE via osql which is a bit of a pain.
Do you have an MSDN subscription? Developer edition will be on that.
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Do you have an MSDN subscription? Developer edition will be on that.
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
If you don;t have an MSDN subsctriptiona dn dont; want to pay for developer edition, every Enterprise and standard edition of SQL server comes with the peronsal edition.
NOte tat you will not be able to do everything that enterprise or standard edition do unless you have a server operating system. I know fulltext search for instance does not work on personal edition.
Questions about posting. See faq183-874
NOte tat you will not be able to do everything that enterprise or standard edition do unless you have a server operating system. I know fulltext search for instance does not work on personal edition.
Questions about posting. See faq183-874
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question