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 |
|
Aleph_0
Yak Posting Veteran
79 Posts |
 Posted - 2011-09-29 : 17:26:32
|
Hi all, I've been learning/using SSMS for about 6 or 7 months, and I still don't understand what "projects" and "solutions" are. Does anyone use these? I just end up creating individual files since that's what I was told to do (by the only guy in IT willing to help me).
And now that I'm thinking about learning Analysis Services, I find the whole project/solution question coming back. Can anyone explain what exactly these are and how to use them? Is it all that different from having individual files saved in a folder?
Thanks, and sorry for the st00pid n00b question! |
|
|
alexylee
Starting Member
14 Posts |
Posted - 2011-10-04 : 13:20:40
|
SSMS is using Visual Studio shell and one of common practice of VS is using project and solution.
Project/solution in SSMS is similar concept as in VS. It provides a container that has connecton information and
multiple script files. Not a big practical difference between using project/sln and using folder/files, I think.
A difference is that if you set a specific DB in connection of ssms project, script in proj is open in the connection context.
http://www.sqlmgmt.com
|
 |
|
|
jassi.singh
Posting Yak Master
122 Posts |
|
|
|
|
|
What are SSMS projects and solutions?