Visual Studio Tools

Question

Post reply

Visual Studio Tools

Jamie Thomson

SSChampion

Points: 11805
More actions
February 16, 2011 at 10:30 pm

#235260

Comments posted to this topic are about the item Visual Studio Tools
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson

Viewing 15 posts - 1 through 15 (of 19 total)

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

M&M SSC-Insane Points: 21700 More actions · Answer 1

I had no idea on this. Got the answer after googling a bit. 🙂

M&M

Koen Verbeeck SSC Guru Points: 259207 More actions · Answer 2

Thanks for the question.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

tejaswini.patil SSCommitted Points: 1812 More actions · Answer 3

Even I was not having any idea about this. Googled and got the answer.

This was a new learning for me.

Thanks.

Duncan Pryde SSCertifiable Points: 7956 More actions · Answer 4

I couldn't even get the answer by googling! Does anyone have a reference?

Thanks,

Duncan

tejaswini.patil SSCommitted Points: 1812 More actions · Answer 5

Please find details on the below url:

http://msdn.microsoft.com/en-us/library/z29kb47d(v=vs.71).aspx

Duncan Pryde SSCertifiable Points: 7956 More actions · Answer 6

tejaswini.patil (2/17/2011)
Please find details on the below url:
http://msdn.microsoft.com/en-us/library/z29kb47d(v=vs.71).aspx

Thanks for the link. Although it's for Visual Studio .Net 2003, I can browse to the newer versions from there.

Abi Chapagai SSCrazy Points: 2666 More actions · Answer 7

Learnt something new today!! Thanks for the question.

OCTom SSChampion Points: 11815 More actions · Answer 8

tejaswini.patil (2/17/2011)
Please find details on the below url:
http://msdn.microsoft.com/en-us/library/z29kb47d(v=vs.71).aspx

According to that link:

"A database reference is simply a pointer to a database."

I chose the pointer option and got it wrong. So, is there two correct options?

tejaswini.patil SSCommitted Points: 1812 More actions · Answer 9

The link says

"

Database References

The database project now includes the concept of database reference. A database reference is simply a pointer to a database. Whenever you create a database reference, the database project immediately checks the list of database connections in Server Explorer and if there is no connection to that database, it creates such a connection for you automatically. A database reference differs from a database connection, because a reference is merely a pointer; it does not allow you to enumerate the contents of the database. A database connection, on the other hand, lets you inspect the contents of the database.

A database reference is persisted with the database project. When you save a project to disk, the reference is saved. When another user opens the project and begins using it, the reference is available to that user. Furthermore, when any user opens a database project, the project checks that user's Server Explorer for a corresponding connection and if no such connection exists, the database project automatically creates it. "

i.e. a new concept of Database Reference is introduced which is a pointer to a database.

So answer to the question should be "Database Reference".

tejaswini.patil SSCommitted Points: 1812 More actions · Answer 10

I am sorry for the font size. I selected 7 thinking that it would be smaller.

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 11

Can someone suggest a good reference to learn more about Visual Studio database projects?

Thanks.

Koen Verbeeck SSC Guru Points: 259207 More actions · Answer 12

tejaswini.patil (2/17/2011)
I am sorry for the font size. I selected 7 thinking that it would be smaller.

You can still edit your post. Please do. 🙂

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP