Questions tagged [visual-studio]
Use the tag Visual Studio when you are having issues using Visual Studio in combination with a database system.
127
questions
2
votes
2
answers
343
views
Visual Studio DAC with Schemabound View containing hierarchyid::GetRoot() - Two part name needed?
In Visual Studio, when trying to create a DAC which has a schemabound view which contains hierarchyid::GetRoot() this error is generated and the project does not build. However, the t-sql is ok as if ...
- 151
3
votes
3
answers
353
views
What SSMS and/or Visual Studio tools sync SQL Server environments?
I need to sync table structures, stored procedures, triggers, data, etc. between environments. There are dev, QA, and production environments. I am in a Microsoft-centric environment.
What tools ...
- 529
2
votes
1
answer
2k
views
Export SQL Server varbinary field to string using Visual Basic script in SSIS?
I'm using SSIS to export data from a set of tables to flat files. The export is running great except for one table with a varbinary field. The export is running a Visual Basic script task to load the ...
- 173
7
votes
1
answer
1k
views
Visual Studio 2010 deployment script creates objects in wrong order - trigger after stored procedure
I created a view that selects from multiple tables in a complex query.
Due to the complexity, I created insert/update/delete INSTEAD OF triggers to handle these operations on the view.
I also created ...
- 253
42
votes
7
answers
14k
views
Why should I use Visual Studio 2010 over SSMS for my database development?
Visual Studio 2010 introduces database projects and a whole array of related features that supposedly facilitate database development. I've used SQL Server Management Studio (SSMS) for many years to ...
- 14.7k
1
vote
1
answer
2k
views
Install SQL server 2008 R2 with VS 2010
Ok, I've installed SQL Server 2008 R2.
I'm trying to add a "SQL Server Database" to an ASP MVC project.
But it keeps telling me I need SQL Server for it to work.
What do I need to do to setup the ...
- 163
5
votes
0
answers
10k
views
"Procedure: XXXX has an unresolved reference to object XXXX" errors [closed]
After using for some time MS SQL Server Management Studio for creating and editing databases I tried to use Visual Studio 2010 "SQL Server 2008 Database Project" for this.
I used the SQL 2008 Wizard ...
- 1,555