StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
18590767
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-09-03T11:09:56.523
FavoriteCount
0
LastActivityDate
2013-09-03T11:09:56.523
LastEditDate
LastEditorUserId
0
OwnerUserId
13302
ParentId
18578196
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
The whole User Instance and AttachDbFileName= approach is flawed - at best! Also, it's only supported by the Express edition of SQL Server - so if your hoster has anything other than Expres, you're basically screwed. The real solution in my opinion would be to <ol> <li>install SQL Server Management Studio Express</li> <li>create your database in SSMS Express, give it a logical name (e.g. <code>MyDatabase</code>) </li> <li>connect to it using its logical database name (given when you create it on the server) - and don't mess around with physical database files and user instances. In that case, your connection string would be something like: <pre><code>Data Source=.\\SQLEXPRESS;Database=MyDatabase;Integrated Security=True </code></pre> and everything else is exactly the same as before...</li> </ol> Now, when you go and upload your web site to the hosting site, you need to get the necessary SQL scripts to create and populate your database on the hosting site - you can do this by using <code>Tasks > Generate Scripts</code> from the SSMS Express tool, or by some other means. Then, on the hosting site, you need to execute those SQL scripts to create and populate your database (and later on: execute the change scripts to keep the database up to date). Your connection string will also most likely change to something like: <pre><code>Server=(ip-address-or-name);Database=MyDatabase;User ID=YourUserIdHere;Pwd=YourPassword </code></pre> since the hosting provider doesn't use the <code>SQLEXPRESS</code> named instance (but most likely a default instance without any name). You need to ask your provider for the details - it could be that you have to provide some other instance name! That's totally up to the provider, we cannot know that - you'll have to ask and find out.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POSQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified for MDF file
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USmarc_s
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POSQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified for MDF file
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. COthanks @marc_s...
 singulars
 PostPostId
 PO
 UserUserId
 USArjun Vachhani

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.