Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Visual Studio Tools Expand / Collapse
Author
Message
Posted Wednesday, February 16, 2011 10:30 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, November 10, 2013 11:52 AM
Points: 877, Visits: 188
Comments posted to this topic are about the item Visual Studio Tools

Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Post #1065433
Posted Wednesday, February 16, 2011 10:30 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 3:53 PM
Points: 2,278, Visits: 3,801
I had no idea on this. Got the answer after googling a bit.

Mohammed Moinudheen
Post #1065434
Posted Wednesday, February 16, 2011 11:35 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 1:52 PM
Points: 13,368, Visits: 11,148
Thanks for the question.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1065447
Posted Thursday, February 17, 2011 12:54 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 19, 2011 1:59 AM
Points: 1,042, Visits: 234
Even I was not having any idea about this. Googled and got the answer.

This was a new learning for me.

Thanks.
Post #1065465
Posted Thursday, February 17, 2011 2:00 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 6:56 AM
Points: 3,352, Visits: 1,487
I couldn't even get the answer by googling! Does anyone have a reference?

Thanks,

Duncan
Post #1065497
Posted Thursday, February 17, 2011 2:05 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 19, 2011 1:59 AM
Points: 1,042, Visits: 234
Please find details on the below url:
http://msdn.microsoft.com/en-us/library/z29kb47d(v=vs.71).aspx
Post #1065499
Posted Thursday, February 17, 2011 3:06 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 6:56 AM
Points: 3,352, Visits: 1,487
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.
Post #1065527
Posted Thursday, February 17, 2011 5:45 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 5:36 PM
Points: 1,786, Visits: 1,116
Learnt something new today!! Thanks for the question.
Post #1065589
Posted Thursday, February 17, 2011 7:19 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:07 AM
Points: 2,610, Visits: 3,972
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?
Post #1065651
Posted Thursday, February 17, 2011 7:27 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 19, 2011 1:59 AM
Points: 1,042, Visits: 234
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".
Post #1065657
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse