Have just installed minimal SQL2012 Express and need to attach an existing database to it.
This will be used in a small office with two workstations accessing data on sql2012 express server box.
No IT dept - and just want a simple and easy way to administer system.
Need to know where to place the MyData.MDF file and how to assign a database name such as MySqlData to it so i can use a connection string that specifies server MyPC\SQLEXPRESS and database name MySqlData
Also, what else do I need to allow client computers to access this database?
Yes, there are SQL commands for this:
Here you can download Management STudio for SQL express. It's free:
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)
But how far can you go? When does the XML Source component become …