The visual-studio tag has no wiki summary.
23
votes
7answers
5k 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 ...
5
votes
1answer
538 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 ...
2
votes
2answers
115 views
Is there a SQL Server 2008 R2 specific target for SSDT projects?
I am making a SQLCLR stored procedure in Visual Studio 2012. I have these options for target platform:
Is there not a SQL Server 2008 R2 specific option? Is this because SQL 2008 R2 shares the same ...
2
votes
3answers
117 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 ...
2
votes
1answer
243 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 ...
2
votes
0answers
120 views
Microsoft Visual Studio is Busy
I am working in Visual Studio 2008 on a SSIS package. It is really frustrating that I get "Microsoft Visual Studio is Busy" message quite often. It almost happens every time I try to open a data ...
1
vote
1answer
372 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 ...
1
vote
1answer
1k views
“Procedure: XXXX has an unresolved reference to object XXXX” errors
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
vote
1answer
61 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 ...
