Question: Does anyone have any idea how can i open new window at click on any dynamic link and my problem platform is vb.net and also remember that new window is not internet explorer window or any other browser give me full source code.

This is what I've tried till now

```
Private Sub WebBrowser1_NewWindow(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles WebBrowser1.NewWindow
    Dim thiselement As HtmlElement = WebBrowser1.Document.ActiveElement
    Dim targeturl As String = thiselement.GetAttribute("href") 
    e.Cancel = True
    Dim window As New Form1
    window.Show()
    window.WebBrowser1.Navigate(targeturl)
End Sub

```

Answer: 
If these are for the current database, your best bet is to import the project, then just replace "MyDBName.dbo." with "dbo.". If you're trying to reference other databases, you should probably use SQLPackage to extract a dacpac for those, then add database references for them. When adding the database reference, do not choose the option to treat these as a variable unless the names of those databases change from environment to environment. E.g., if you reference MyDB1.dbo.Table1 in your project and "MyDB1" is always the name of that database, you should not try to use a DB Variable.

I've written about this on my blog. Maybe that will give some better examples.

<http://schottsql.blogspot.com/2012/10/ssdt-external-database-references.html>

and

<http://schottsql.blogspot.com/2013/01/ssdt-publishing-and-referenced-databases.html>
I thought I had the same issue, but following step 4 cleared it. I first forgot and left in the variable reference! Clearing the field let my project build correctly...

A possible solution is to add a database reference to the database that has the missing object. The reference needs a Data-tier Application (dacpac file) that can be easily generated on the solution with the database project that has the missing object. Press the right mouse button over the database project and selected Snapshot Project. The dacpac file is created on the Snapshots folder. The file should then be copied to a common folder for re-usability.

In the project with the error press the right mouse button over the References and selected Add Database Reference. The Add Database Reference dialog appears:
1. Select the dacpac file
2.Select the database location. The most common option is "Different database, same server"
3.Confirm that the Database name field is as expected
4.Clear the "Database variable" field in the dialog. If this field has a value the queries must use this variable and not the database name